search cancel

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

book

Article ID: 112977

calendar_today

Updated On:

Products

CA Automation Suite for Data Centers - Configuration Automation CA Client Automation - Asset Management CA Client Automation - IT Client Manager CA Client Automation CA Client Automation - Remote Control CA Client Automation - Asset Intelligence CA Client Automation - Desktop Migration Manager CA Client Automation - Patch Manager

Issue/Introduction

I need to make sure all agent machines are updating to the Domain Manager so that they receive any needed software etc.

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

Resolution

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:

<Please see attached file for image>

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:

<Please see attached file for image>

User-added image

<Please see attached file for image>

User-added image

<Please see attached file for image>

User-added image

<Please see attached file for image>

User-added image

<Please see attached file for 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:

<Please see attached file for image>

User-added image

<Please see attached file for image>

User-added image

<Please see attached file for image>

User-added image

<Please see attached file for 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
 

Attachments

1558696336756000112977_sktwi1f5rjvs16iid.jpeg get_app
1558696334845000112977_sktwi1f5rjvs16iic.jpeg get_app
1558696333031000112977_sktwi1f5rjvs16iib.jpeg get_app
1558696331277000112977_sktwi1f5rjvs16iia.jpeg get_app
1558696329298000112977_sktwi1f5rjvs16ii9.jpeg get_app
1558696327681000112977_sktwi1f5rjvs16ii8.jpeg get_app
1558696325931000112977_sktwi1f5rjvs16ii7.jpeg get_app
1558696324032000112977_sktwi1f5rjvs16ii6.jpeg get_app
1558696322289000112977_sktwi1f5rjvs16ii5.jpeg get_app
1558696320331000112977_sktwi1f5rjvs16ii4.jpeg get_app