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.

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

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

 

Answered 11/20/2013 by: chucksteel
Red Belt

Please log in to comment

Answers

This content is currently hidden from public view.
Reason: Removed by member request
For more information, visit our FAQ's.

Answer this question or Comment on this question for clarity

Share