Loading
Where I need to look to check when particular computer was initially added to SNOW. I am looking for a specific date, date since when computer/server/any item is visible in SNOW. Thank you, Grzegorz

  • You can see when the computer reported for the first time in Inventory.

    Normally, it appeared in SLM after the next successful DUJ.

    Use this query in the INV database:

     

    SELECT * FROM [SnowInventory].[inv].ChangeSequenceNumber

    WHERE SequenceNumber = (

     SELECT DISTINCT MIN(SequenceNumber)

     FROM [SnowInventory].[inv].ChangeSequenceNumber 

     WHERE ClientId IN

     (

      SELECT DISTINCT ClientId

    FROM [SnowInventory].[inv].AgentManifest

    WHERE HostName = 'Your-hostname-goes-here'

    AND IsError = 0

     )

     GROUP BY ClientId)

    Expand Post
  • much easier to go to search for all computers in SLM and add the column 'client install date'

    • Yes, easier.

      Although I assume that depending on how you upgrade from one version to another, this date could probably change. Where does this "Client Install Date" actually come from?

      • As far as I'm aware, it updates whenever a new agent is installed, or at least in my experience it has. I always default to the Applications Installation History report to see when a device first scanned, or if needed, your initial answer I've used a few times too. :)

  • Like Adam I also often use the client install date, bit this sometimes gets overwritten, when you install a new agent version by msi.

    But in SLM you have an additional possibility, the report "Application installation history"

    Here you can add a filter to search for the specific computer.

    Then you can see all installed and removed application for that computer. The oldest "First Discovered" date is the date the computer first appeared in Snow License Manager.

    But this information get lost, in case you remove the computer.

    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
Where I need to look to check when particular computer was initially added to SNOW. I am looking for a specific date, date since when computer/server/any item is visible in SNOW. Thank you, Grzegorz