
MWuendisch asked a question.
How can I check if Snow Inventory Server <ApiEndpoint> works correctly and could it be the same as <BaseAddress> ?
How can I check the functionality? For Debugging purpose I put a wrong URL in this XML Tag <ApiEndPoint> in snowserver.config, but couldn't find a error message in the logfile after restat the snow inventory service. How can I check the functionality ? And second question: could I use the same URL for <BaseAddress> as for <ApiEndPoint>? KR Mathias
Hey Mathias,
As far as I'm aware they can't be the same because it causes a loop back. If my Snow Inventory Server Base Address is using Port 443 I tend to put the API on Port 80. It's for the InventoryService that's installed on the Snow License Manager server for managing the deletions of Devices, Computers and Users.
If you check data clean-up below it's a good starting point to check if it's working, you can also check the InventoryService logs in C:\Program Files\Snow Software\Logs on the License Manager server, not the Inventory Server.
Example:
<Server>
<SiteName>DEMO</SiteName>
<IncomingFolder>C:\Program Files\Snow Software\Snow Inventory\Server\Incoming</IncomingFolder>
<BaseAddress>https://externalinventory.company.com:443</BaseAddress>
<ApiEndpoint>http://svr01inv01.int.domain.local:80</ApiEndpoint>
</Server>
Once you've changed the ApiEndpoint, you need to run the following scripts against the database and then check the SnowSoftwareInventoryService logs on your Snow License Manager server.
Update database tables
USE SnowInventory
EXECUTE slm.GetAPIKey
EXECUTE slm.GetServerAddress
Use SnowLicenseManager
EXECUTE inv.UpdateAPIKey
EXECUTE inv.UpdateServerAddress
Confirm the changes
SELECT * FROM SnowInventory.inv.Apikey
SELECT * FROM SnowLicenseManager.inv.tblApiKey
SELECT * FROM SnowLicenseManager.dbo.tblApiKey
SELECT * FROM SnowInventory.inv.ServerAddress
SELECT * FROM SnowLicenseManager.inv.tblServerAddress
SELECT * FROM SnowLicenseManager.dbo.tblServerAddress
Data clean-up
If you run the below it'll show you how many devices have been deleted from the front end but not synced and deleted from the backend.
SELECT COUNT(*) FROM SnowInventory.inv.AgentManifest WHERE ClientID IN (SELECT ClientID FROM SnowLicenseManager.inv.tblComputerInvSlmMap WHERE ComputerID = 0)
You can then use the below script to delete the 'left over' devices in a safe manor.
USE [SnowInventory]
DECLARE @AssignedId bigint
DECLARE @LOOP as CURSOR
SET @LOOP = CURSOR FOR
SELECT AssignedId
FROM SnowInventory.inv.AgentManifest
WHERE ClientId IN (SELECT ClientId FROM SnowLicenseManager.inv.tblComputerInvSlmMap WHERE ComputerID = 0)
OPEN @LOOP
FETCH NEXT FROM @LOOP INTO @AssignedId
WHILE @@FETCH_STATUS = 0
BEGIN
DECLARE @p1 inv.AssignedIdTargetTableType
INSERT INTO @p1 values(@AssignedId)
RAISERROR (N' STARTED: Removing Asset...',10,1) WITH NOWAIT
EXEC [inv].[DeleteIdentity] @AssignedIds=@p1
RAISERROR (N' FINISHED: Removing Asset...',10,1) WITH NOWAIT
FETCH NEXT FROM @LOOP INTO @AssignedId
END
CLOSE @LOOP
DEALLOCATE @LOOP
Thanks
Laim