Hi,
Is there a way to get the "sys_id" available in the Field (field_list) or directly in the script on the Script form in PA?
It's not possible to select "sys_id" in the available fields on the Script form in PA to use it in the Script. This is needed to query the cmdb_rel_ci for some validations for the current record.
The following structure is built in PA:
1) Created Indicator Source on Facts table: Database Instance [cmdb_ci_db_instance]
2) Created an Indicator for this Indicator Source: "# of pass DB instances for platform validation".
Indicator details:
Aggregate: SUM
Scripted: checked
Script: SH.Validate DB platform relation
Script details:
Source:
Remark: In the Available field list is sys_id not visible.
Script:
checkPlatformforDBInstance(current);
function checkPlatformforDBInstance(record){
var rValue = 0;
var sysId = record.sys_id; //sys_id is not available..
var vTable = 'cmdb_rel_ci';
var vCol;
var vStrQuery ='parent='+sysId;
if(sysId != ''){
var grVal = new GlideRecord(vTable);
grVal.addEncodedQuery(vStrQuery);
grVal.query();
while(grVal.next()){
if(grVal.child.sys_class_name == 'cmdb_ci_win_server'){
rValue = 1;
}
}
}
return (rValue);
}
Dirty workaround: There is a dirty way (add sys_id in XML and import Script record in ServiceNow) to make sys_id available in the script area, but this is not the preferred way forward.
Another approach: This report can also be created with a database view, but I don't want to do this.
Hopefully, someone is able to help me with this issue!
Cheers,
Serkan
Serkan, If run into this issue, my workaround isn't elegant either.
I'll check with the development team and follow up.
