
GS asked a question.
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

GS asked a question.
Need help finding an answer?
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)
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.