Loading
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

    Expand Post

Related  Product Forums


                     → Flexera One



                      → Snow Atlas



                      → FlexNet Manager



                      → Snow License Manager



                       → App Broker


       Need help finding an answer?


        Ask a Question →


Loading
How can I check if Snow Inventory Server <ApiEndpoint> works correctly and could it be the same as <BaseAddress> ?