Create report showing the last date a machine contacted the CA Server/Database

Document ID : KB000112977
Last Modified Date : 04/09/2018
Show Technical Document Details
Introduction:
I need to make sure all agent machines are updating to the Domain Manager so that they receive any needed software etc.
Question:
Can a report be made for all machines that have not updated the Domain Manager in the last week or two?
Environment:
ITCM - All Versions
Answer:
The Agent Last Run date for All Computers can be sorted on in DSM Explorer by selecting All Computers sorting  on the 
"Agent Last Run" column:

User-added image


A report of all agent machines that have not contacted/updated the domain manager since a certain time could also be made.
First create a New query, select New- Computer- General Inventory- Computer- Last Agent Run and set the date to less than  
a certain date such as 2 weeks ago:

User-added image

User-added image

User-added image

User-added image
User-added image
After saving the above query a report based on the query can be made:

In reporter right click Report Templates and select to create a new Report Template, select Asset or user Report, give it a name and in the query field select the query made earlier then save and run the report:
User-added image

User-added image

User-added image

User-added image

 
Additional Information:
Please see these related knowledge documents:

How do I extract user information like last log off, last log on and logon hours?
KB000053635
https://comm.support.ca.com/kb/how-do-i-extract-user-information-like-last-log-off-last-log-on-and-logon-hours/kb000053635

Last Agent Execution Date Info within the MDB
KB000054402
https://comm.support.ca.com/kb/last-agent-execution-date-info-within-the-mdb/kb000054402