Easy way to gather Check-in history?
We are needing to know when and how many times a machine has checked in over its history. Anyone know of a way to generate this in a report or script? Thanks for any help.
Answers (1)
Sorry, my formatting got screwy....
Asset history is stored in the ASSET_HISTORY table. For a list of times that a machine has checked in you could use the following query:
SELECT DISTINCT(TIME)
FROM ASSET_HISTORY
WHERE NAME = 'computername'
ORDER BY TIME
In my experience at least one thing changes with every checkin so this query should return a list of every time the machine has checked in. For a straight dump of everything that has changed use this query:
SELECT *
FROM ASSET_HISTORY
WHERE NAME = 'computername'
ORDER BY TIME
Comments:
-
Perfect. Thanks! - joshua278 10 years ago