How to include the Agent description field in DSM reporter

Document ID : KB000004294
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

We wish to include the details in the description field of the agent properties dialogue of DSM Explorer in our reports but cannot select this as a field

description4.png

Cause:

This field is not currently exposed to DSM reporter.

Resolution:

Execute the following query in SQL Server Management Studio

use mdb

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=ip_address;'+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))

 

The field "Description" will now be available in the computer tab of the field browser in DSM reporter

description2.png

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.