Where can I find field "Last IP-Address" in Query Designer / DSM Reporter?

Document ID:  TEC1549415
Last Modified Date:  07/11/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details


  • CA Client Automation


  • CA Client Automation:Release:12.5 SP1
  • CA Client Automation:Release:12.5 SP1 Feature Pack 1
  • CA Client Automation:Release:12.8
  • CA Client Automation:Release:12.8 Feature Pack 1
  • CA Client Automation:Release:12.9
  • CA Client Automation:Release:14.0
  • CA Client Automation:Release:14.0 SP1


  • CA Client Automation:BITCM
  • CA Asset Management:TNGAMO
  • CA Software Delivery:TNGSDO
  • CA Remote Control:TNGRCO

Where can I find field "Last IP-Address" in Query Designer / DSM Reporter?

There is the property "Last IP-Address" in the agent section of the computer properties. (together with "registered", "last run", Trust level" ...)
I'm looking for this field in the Query Designer and the DSM Reporter, but can't find it.

All Versions of Client Automation

The field 'ip_address' from table 'ca_agent' is not available in field section within the DSM Reporter out of the box.

But this can be added using SQL Queries.


1. In SQL Server Management Studio, execute the following query:

use mdb

INSERT INTO rpdatfld
('ITRM_DISCOVEREDHARDWARE11','ENU','Last IP Address','ca_agent','ip_address',
'Last IP Address',1,1,15,7,0,
'Crit0PseudoTemplate=Last IP Address = ''$CritValueLabel$'';'+CHAR(13)+CHAR(10)+
'Crit0Name=Last IP Address;'+CHAR(13)+CHAR(10)+
'Category=General Information>Computer;'+CHAR(13)+CHAR(10)+
'Crit0PossibleValues=SELECT DISTINCT ip_address as label, ip_address as value FROM ca_agent ORDER by label;'+CHAR(13)+CHAR(10)+
'Description=Last IP Address;'+CHAR(13)+CHAR(10)+
'Name=Last IP Address;'+CHAR(13)+CHAR(10)+
'SqlTemplate=$target.primarykeyfield$ in ($Crit0Sql$);'+CHAR(13)+CHAR(10)+
'Crit0SqlTemplate=SELECT object_uuid FROM ca_agent WHERE ip_address $CritOperator$ ''$CritValue$'';'+CHAR(13)+CHAR(10)+



2. Close and reopen the DSM Explorer/DSM Reporter. The "Last IP Address" field will now be available.


Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255


Not what you were looking for?

Search Again >

Product Information

Support by Product >


Join a Community >