Hi Nishu,
Please help me on this . Here is the Script Include
var Populate_affected_CI = Class.create();
Populate_affected_CI.prototype = {
initialize: function() {},
FilteraffectedCI: function() {
var answer = [];
var CI1 = new GlideRecord('cmdb_ci');
CI1.addEncodedQuery('sys_class_name=cmdb_ci_service^ORsys_class_name=cmdb_ci_service_discovered^ORsys_class_name=cmdb_ci_server^environment=Production^install_status=1^operational_status=1');
CI1.query();
while (CI1.next()) {
answer.push(CI1.sys_id.toString());
}
var CI2 = new GlideRecord('cmdb_ci');
CI2.addEncodedQuery('sys_class_name=u_cmdb_ci_ceep^ORsys_class_name=cmdb_ci_database^ORsys_class_name=cmdb_ci_db_instance^ORsys_class_name=cmdb_ci_oracle_database^ORsys_class_name=cmdb_ci_win_cluster^ORsys_class_name=cmdb_ci_win_cluster_resource^ORsys_class_name=cmdb_ci_netgear^ORsys_class_name=cmdb_ci_lb^ORsys_class_name=cmdb_ci_lb_bigip^ORsys_class_name=cmdb_ci_mainframe_hardware^ORsys_class_name=cmdb_ci_appl_ibm_cics^ORsys_class_name=cmdb_ci_mainframe_lpar^ORsys_class_name=u_cmdb_ci_storage_array^ORsys_class_name=cmdb_ci_san_fabric^ORsys_class_name=cmdb_ci_hardware^ORsys_class_name=cmdb_ci_app_server_websphere^ORsys_class_name=cmdb_ci_appl_ibm_wmq^ORsys_class_name=cmdb_ci_datacenter^ORsys_class_name=cmdb_ci_dns_alias^ORsys_class_name=cmdb_ci_config_file_tracked^ORsys_class_name=cmdb_ci_computer^ORsys_class_name=cmdb_ci_comm^ORsys_class_name=cmdb_ci_printer^ORsys_class_name=u_tcr^ORsys_class_name=cmdb_ci_scanner^ORsys_class_name=cmdb_ci_kubernetes_service^ORsys_class_name=cmdb_ci_kubernetes_cluster^ORsys_class_name=cmdb_ci_kubernetes_node^ORsys_class_name=cmdb_ci_kubernetes_pod^ORsys_class_name=u_cmdb_template_affected_ci^install_status=1^operational_status=1');
CI2.query();
while (CI2.next()) {
answer.push(CI2.sys_id.toString());
}
var CI3 = new GlideRecord('cmdb_ci');
CI3.addEncodedQuery('sys_class_name=u_facilities_change_ci_s^operational_status=1');
CI3.query();
while (CI3.next()) {
answer.push(CI3.sys_id.toString());
}
var CI4 = new GlideRecord('cmdb_ci');
CI4.addEncodedQuery('sys_class_name=cmdb_ci_spkg^ref_cmdb_ci_spkg.u_app_bible=true');
CI4.query();
while (CI4.next()) {
answer.push(CI4.sys_id.toString());
}
return 'sys_idIN' + answer;
},
type: 'Populate_affected_CI'
};
