DSM Reporter: How to add the "Description", "Agent Version" or 'Agent Registered' as available fields for reporting

Products

• CA Client Automation - Asset Management
• CA Client Automation - IT Client Manager
• CA Client Automation

Issue/Introduction

We wish to include the details in the "Description", "Agent Version" and "Agent Registered" fields found in DSM Explorer, as reportable fields in DSM Reporter:

 

Cause

This field is not currently exposed to DSM reporter.

Environment

Client Automation (ITCM) -- any version

Resolution

Execute the following query in SQL Server Management Studio to add these fields:

 

-- Agent description
INSERT INTO rpdatfld
VALUES
('ITRM_DISCOVEREDHARDWARE11',
'ENU','Description','ca_agent',
'description','Description',
1,1,15,7,0,
'Crit0PseudoTemplate=Description = ''$CritValueLabel$'';'+CHAR(13)+CHAR(10)+
'DisplayEnum=;'+CHAR(13)+CHAR(10)+
'Crit0Type=CT_STRING;'+CHAR(13)+CHAR(10)+
'Usage=0;'+CHAR(13)+CHAR(10)+
'CriteriaCount=1;'+CHAR(13)+CHAR(10)+
'PseudoTemplate=($Crit0Pseudo$);'+CHAR(13)+CHAR(10)+
'Crit0Name=Description;'+CHAR(13)+CHAR(10)+
'Crit0ValueSelector=VS_EDITABLELIST;'+CHAR(13)+CHAR(10)+
'Category=General Information>Computer;'+CHAR(13)+CHAR(10)+
'Table=ca_agent;'+CHAR(13)+CHAR(10)+
'Column=description;'+CHAR(13)+CHAR(10)+
'Crit0PossibleValues=SELECT DISTINCT description as label, description as value FROM ca_agent ORDER by label;'+CHAR(13)+CHAR(10)+
'Description=Description;'+CHAR(13)+CHAR(10)+
'Name=Description;'+CHAR(13)+CHAR(10)+
'From=ca_agent;'+CHAR(13)+CHAR(10)+
'SqlTemplate=$target.primarykeyfield$ in ($Crit0Sql$);'+CHAR(13)+CHAR(10)+
'Crit0SqlTemplate=SELECT object_uuid FROM ca_agent WHERE Description $CritOperator$ ''$CritValue$'';'+CHAR(13)+CHAR(10)+
'Where=object_uuid=PRIMOBJECT;'+CHAR(13)+CHAR(10)+
'ProcessSiblings=0;'+CHAR(13)+CHAR(10))


-- Agent version
INSERT INTO rpdatfld
VALUES
('ITRM_DISCOVEREDHARDWARE11',
'ENU','Agent Version','ca_agent',
'agent_version','Agent Version',
1,1,15,7,0,
'Crit0PseudoTemplate=Description = ''$CritValueLabel$'';'+CHAR(13)+CHAR(10)+
'DisplayEnum=;'+CHAR(13)+CHAR(10)+
'Crit0Type=CT_STRING;'+CHAR(13)+CHAR(10)+
'Usage=0;'+CHAR(13)+CHAR(10)+
'CriteriaCount=1;'+CHAR(13)+CHAR(10)+
'PseudoTemplate=($Crit0Pseudo$);'+CHAR(13)+CHAR(10)+
'Crit0Name=Description;'+CHAR(13)+CHAR(10)+
'Crit0ValueSelector=VS_EDITABLELIST;'+CHAR(13)+CHAR(10)+
'Category=General Information>Computer;'+CHAR(13)+CHAR(10)+
'Table=ca_agent;'+CHAR(13)+CHAR(10)+
'Column=agent_version;'+CHAR(13)+CHAR(10)+
'Crit0PossibleValues=SELECT DISTINCT agent_version as label, agent_version as value FROM ca_agent ORDER by label;'+CHAR(13)+CHAR(10)+
'Description=Agent Version;'+CHAR(13)+CHAR(10)+
'Name=Agent Version;'+CHAR(13)+CHAR(10)+
'From=ca_agent;'+CHAR(13)+CHAR(10)+
'SqlTemplate=$target.primarykeyfield$ in ($Crit0Sql$);'+CHAR(13)+CHAR(10)+
'Crit0SqlTemplate=SELECT object_uuid FROM ca_agent WHERE Description $CritOperator$ ''$CritValue$'';'+CHAR(13)+CHAR(10)+
'Where=object_uuid=PRIMOBJECT;'+CHAR(13)+CHAR(10)+
'ProcessSiblings=0;'+CHAR(13)+CHAR(10))

-- Agent Registered

INSERT INTO rpdatfld
VALUES
('ITRM_DISCOVEREDHARDWARE11',
'ENU','Creation and Update information>Agent Registered','ca_agent',
'creation_date','Creation and Update information>Agent Registered',
1,1,15,4,292,
'DisplayEnum=;'+CHAR(13)+CHAR(10)+
'FormatType=292;'+CHAR(13)+CHAR(10)+
'Usage=0;'+CHAR(13)+CHAR(10)+
'Category=General Information>Computer;'+CHAR(13)+CHAR(10)+
'Table=ca_agent;'+CHAR(13)+CHAR(10)+
'Column=creation_date;'+CHAR(13)+CHAR(10)+
'Name=Creation and Update information > Agent Registered;'+CHAR(13)+CHAR(10)+
'From=ca_agent;'+CHAR(13)+CHAR(10)+
'Where=ca_agent.object_uuid=PRIMOBJECT;'+CHAR(13)+CHAR(10)+
'ProcessSiblings=0;'+CHAR(13)+CHAR(10))

 

These fields will now be available in DSM Reporter:

Additional Information

As this is a customization it is possible that it may be reverted by future product upgrades and this has not undergone any QA testing.