Add 'Description' field from Scalability Server section to DSM Reporter

Products

• CA Client Automation - IT Client Manager
• CA Client Automation

Issue/Introduction

On Scalability Server section, it's possible to add a description to each server:

Is it possible to add this field to a DSM Report?

Environment

Client Automation - 14.5 and above

Resolution

In order to add this field to DSM Explorer, the following query can be executed:

INSERT INTO rpdatfld
VALUES
('ITRM_DISCOVEREDHARDWARE11',
'ENU','Scalability Server Description','ca_server',
'description','Scalability Server 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_server;'+CHAR(13)+CHAR(10)+
'Column=description;'+CHAR(13)+CHAR(10)+
'Crit0PossibleValues=SELECT DISTINCT description as label, description as value FROM ca_server ORDER by label;'+CHAR(13)+CHAR(10)+
'Description=Description;'+CHAR(13)+CHAR(10)+
'Name=Description;'+CHAR(13)+CHAR(10)+
'From=ca_server;'+CHAR(13)+CHAR(10)+
'SqlTemplate=$target.primarykeyfield$ in ($Crit0Sql$);'+CHAR(13)+CHAR(10)+
'Crit0SqlTemplate=SELECT dis_hw_uuid FROM ca_server WHERE Description $CritOperator$ ''$CritValue$'';'+CHAR(13)+CHAR(10)+
'Where=dis_hw_uuid=PRIMOBJECT;'+CHAR(13)+CHAR(10)+
'ProcessSiblings=0;'+CHAR(13)+CHAR(10))

After this, the field will be available under "Computer" tab:

And when running a report that uses this field, the info will be shown in the Report itself:

 

Additional Information

If for some reason, it's required to remove this field, the following query can be executed:

delete from rpdatfld 
where srcid = 'ITRM_DISCOVEREDHARDWARE11' and tblname='ca_server' and fldname='Scalability Server Description'