KACE Product Support

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