Client Automation - Add AM Status, SD Status and RC Status fields in reporter

Products

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

Issue/Introduction

The fields AM Status, SD Status and RC Status are not availlable in DSM Reporter. How to add them ?

Environment

Client Automation - All Versions.

Resolution

Execute these SQL Queries :

-- SD Status
update rpdatfld
set fldname='Derived Status>Software Delivery ORI'
WHERE srcid='ITRM_DISCOVEREDHARDWARE11' and tblname='ca_agent' and fldname = 'Derived Status>Software Delivery'

INSERT INTO rpdatfld
VALUES
('ITRM_DISCOVEREDHARDWARE11',
'ENU','Derived Status>Software Delivery','ca_agent',
'derived_status_sd','Derived Status>Software Delivery',
1,1,15,4,0,
'Crit0PseudoTemplate=SD Derived Status = ''$CritValueLabel$'';'+CHAR(13)+CHAR(10)+
'DisplayEnum=Operational=0|Locked by RAC=1|Locked by Move=2|Locked by RAC and Move=3|Locked by Roam=4|Locked by RAC and Roam=5|Preregistered=536870912|Not Installed=268435456;'+CHAR(13)+CHAR(10)+
'Crit0Type=CT_OBJECT;'+CHAR(13)+CHAR(10)+
'Usage=0;'+CHAR(13)+CHAR(10)+
'CriteriaCount=1;'+CHAR(13)+CHAR(10)+
'PseudoTemplate=($Crit0Pseudo$);'+CHAR(13)+CHAR(10)+
'Crit0Name=SD Derived Status;'+CHAR(13)+CHAR(10)+
'Crit0ValueSelector=VS_LIST;'+CHAR(13)+CHAR(10)+
'Category=General Information>Computer;'+CHAR(13)+CHAR(10)+
'Table=ca_agent;'+CHAR(13)+CHAR(10)+
'Column=derived_status_sd;'+CHAR(13)+CHAR(10)+
'Crit0PossibleValues=Operational=0|Preregistered=536870912|Not Installed=268435456|Locked by RAC=1|Locked by Move=2|Locked by RAC and Move=3|Locked by Roam=4|Locked by RAC and Roam=5|;'+CHAR(13)+CHAR(10)+
'Description=SD Derived Status;'+CHAR(13)+CHAR(10)+
'Name=Derived Status>Software Delivery;'+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 derived_status_sd IN ($CritValue$);'+CHAR(13)+CHAR(10)+
'Where=((object_uuid=PRIMOBJECT AND $(RDS_RESULT_TABLE).TYPE=1) OR (object_uuid=SECSERVER));'+CHAR(13)+CHAR(10)+
'ProcessSiblings=0;'+CHAR(13)+CHAR(10))



-- AM Status

update rpdatfld
set fldname='Derived Status>Asset Management ORI'
WHERE srcid='ITRM_DISCOVEREDHARDWARE11' and tblname='ca_agent' and fldname = 'Derived Status>Asset Management'


INSERT INTO rpdatfld
VALUES
('ITRM_DISCOVEREDHARDWARE11',
'ENU','Derived Status>Asset Management','ca_agent',
'derived_status_am','Derived Status>Asset Management',
1,1,15,4,0,
'Crit0PseudoTemplate=AM Derived Status = ''$CritValueLabel$'';'+CHAR(13)+CHAR(10)+
'DisplayEnum=Operational=0|Alert=1|Warning=2|Information=3|Legacy=-1|Not Installed=-2|Agentless=-3|Preregistered=-4|;'+CHAR(13)+CHAR(10)+
'Crit0Type=CT_OBJECT;'+CHAR(13)+CHAR(10)+
'Usage=0;'+CHAR(13)+CHAR(10)+
'CriteriaCount=1;'+CHAR(13)+CHAR(10)+
'PseudoTemplate=($Crit0Pseudo$);'+CHAR(13)+CHAR(10)+
'Crit0Name=AM Derived Status;'+CHAR(13)+CHAR(10)+
'Crit0ValueSelector=VS_LIST;'+CHAR(13)+CHAR(10)+
'Category=General Information>Computer;'+CHAR(13)+CHAR(10)+
'Table=ca_agent;'+CHAR(13)+CHAR(10)+
'Column=derived_status_am;'+CHAR(13)+CHAR(10)+
'Crit0PossibleValues=Operational=0|Alert=1|Warning=2|Information=3|Legacy=-1|Not Installed=-2|Agentless=-3|Preregistered=-4|;'+CHAR(13)+CHAR(10)+
'Description=AM Derived Status;'+CHAR(13)+CHAR(10)+
'Name=Derived Status > Asset Management;'+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 derived_status_am=$CritValue$;'+CHAR(13)+CHAR(10)+
'Where=((object_uuid=PRIMOBJECT AND $(RDS_RESULT_TABLE).TYPE=1) OR (object_uuid=SECSERVER));'+CHAR(13)+CHAR(10)+
'ProcessSiblings=0;'+CHAR(13)+CHAR(10))



-- RC Status
update rpdatfld
set fldname='Derived Status>Remote Control ORI'
WHERE srcid='ITRM_DISCOVEREDHARDWARE11' and tblname='ca_agent' and fldname = 'Derived Status>Remote Control'

INSERT INTO rpdatfld
VALUES
('ITRM_DISCOVEREDHARDWARE11',
'ENU','Derived Status>Remote Control','ca_agent',
'derived_status_rc','Derived Status>Remote Control',
1,1,15,4,0,
'Crit0PseudoTemplate=RC Derived Status = ''$CritValueLabel$'';'+CHAR(13)+CHAR(10)+
'DisplayEnum=Migrated=5|Preregistered=9|Not Installed=7|Locked=401|Locked (Local Security)=301|Active Session=402|Active Session (Local Security)=302|Listening=403|Listening (Local Security)=303|Not Listening=404|Not Listening (Local Security)=304|Stopped=406|Stopped (Local Security)=306|;'+CHAR(13)+CHAR(10)+
'Crit0Type=CT_OBJECT;'+CHAR(13)+CHAR(10)+
'Usage=0;'+CHAR(13)+CHAR(10)+
'CriteriaCount=1;'+CHAR(13)+CHAR(10)+
'PseudoTemplate=($Crit0Pseudo$);'+CHAR(13)+CHAR(10)+
'Crit0Name=RC Derived Status;'+CHAR(13)+CHAR(10)+
'Crit0ValueSelector=VS_LIST;'+CHAR(13)+CHAR(10)+
'Category=General Information>Computer;'+CHAR(13)+CHAR(10)+
'Table=ca_agent;'+CHAR(13)+CHAR(10)+
'Column=derived_status_rc;'+CHAR(13)+CHAR(10)+
'Crit0PossibleValues=Migrated=5|Preregistered=9|Not Installed=7|Locked=401|Locked (Local Security)=301|Active Session=402|Active Session (Local Security)=302|Listening=403|Listening (Local Security)=303|Not Listening=404|Not Listening (Local Security)=304|Stopped=406|Stopped (Local Security)=306|;'+CHAR(13)+CHAR(10)+
'Description=RC Derived Status;'+CHAR(13)+CHAR(10)+
'Name=Derived Status > Remote Control;'+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 derived_status_rc=$CritValue$;'+CHAR(13)+CHAR(10)+
'Where=((object_uuid=PRIMOBJECT AND $(RDS_RESULT_TABLE).TYPE=1) OR (object_uuid=SECSERVER));'+CHAR(13)+CHAR(10)+
'ProcessSiblings=0;'+CHAR(13)+CHAR(10))

 

These fields will be available here :