GlideRecordUtil - Global

The GlideRecordUtil script include is a utility class for working with GlideRecords.

This script include is available in server-side scripts. For use cases, see Using discovery script includes.

GlideRecordUtil - getCIGR(String sys_id)

Returns the GlideRecord object for the specified configuration item (CI) using just the sys_id of the CI.

Use this method to quickly obtain a specific CI without knowing its associated class/table.

表 : 1. Parameters

Name	Type	Description
sys_id	String	Sys_id of the desired CI.

表 : 2. Returns

Type	Description
GlideRecord	GlideRecord object of the specified CI.

The following example returns the GlideRecord object for the specified CI using just the sys_id of the CI.

var now_GR = new GlideRecordUtil().getCIGR("2dfd7c8437201000deeabfc8bcbe5d56");

GlideRecordUtil - getFields(GlideRecord gr)

Returns an array of all the fields in the specified GlideRecord.

注:

If there is a field name which is the same as the table name, the getFields() method does not return the value of the field.

表 : 3. Parameters

Name	Type	Description
gr	GlideRecord	GlideRecord instance positioned to a valid record.

表 : 4. Returns

Type	Description
Array	Field names for the specified GlideRecord.

var queryString = "priority=1^ORpriority=2";
var now_GR = new GlideRecord('incident');
now_GR.addEncodedQuery(queryString);
now_GR.query();
now_GR.next();

var gRU = new GlideRecordUtil();
var fieldList = gRU.getFields(now_GR);
gs.info(fieldList);

Output: Line breaks added for presentation.

sys_id,skills,closed_by,assigned_to,contract,category,escalation,state,reassignment_count,location,
time_worked,order,due_date,number,upon_approval,sys_tags,sla_due,follow_up,reopen_count,notify,business_stc,
caused_by,rejection_goto,assignment_group,comments_and_work_notes,incident_state,opened_at,parent_incident,
business_service,wf_activity,calendar_duration,group_list,caller_id,comments,priority,sys_updated_by,
variables,delivery_task,resolved_at,sys_updated_on,parent,active,opened_by,expected_start,watch_list,
company,upon_reject,work_notes,sys_created_by,additional_assignee_list,approval_set,cmdb_ci,user_input,
sys_created_on,close_code,contact_type,resolved_by,rfc,approval_history,activity_due,severity,child_incidents,
,subcategory,work_end,closed_at,close_notes,variables,business_duration,knowledge,approval,sys_domain_path,
sys_mod_count,problem_id,calendar_stc,work_start,sys_domain,correlation_id,sys_class_name,short_description,
impact,description,correlation_display,urgency,made_sla,delivery_plan,work_notes_list

GlideRecordUtil - getGR(String baseTable, String sys_id)

Returns a GlideRecord instance for the given table, positioned to the given sys_id, and of the right class (table).

This method is useful when you need to load a GlideRecord from a sys_id, but you don't know what the actual table is (because it may be extended from the base table). This method always returns a GlideRecord of the correct type base_table: the name of the base table that the specified sys_id is in.

表 : 5. Parameters

Name	Type	Description
baseTable	String	The name of the base table containing the sys_id.
sys_id	String	The sys_id of the desired record.

表 : 6. Returns

Type	Description
GlideRecord	The GlideRecord for the specified sys_id.

var now_GR = new GlideRecordUtil().getGR("cmdb_ci_computer", "2dfd7c8437201000deeabfc8bcbe5d56");

GlideRecordUtil - getTables(String tableName)

Returns a list of the ancestors of a specified table.

注:

The specified table is included in the list of its ancestors.

表 : 7. Parameters

Name	Type	Description
tableName	String	Name of the table.

表 : 8. Returns

Type	Description
Array	List of ancestors of the specified table.

The following example shows the ancestors of the Linux Server [cmdb_ci_linux_server] table.

var tables = new GlideRecordUtil().getTables("cmdb_ci_linux_server");
gs.info("Tables returned: " + tables);

Output:

Tables returned: [cmdb_ci_linux_server, cmdb_ci_server, cmdb_ci_computer, cmdb_ci_hardware, cmdb_ci, cmdb]

GlideRecordUtil - mergeToGR(Object hashMap, GlideRecord now_GR, Object ignore)

Sets the fields in the specified GlideRecord with the field values contained in the specified hashmap, unless that field name is in the ignore hashmap.

表 : 9. Parameters

Name	Type	Description
hashMap	Object	An Object instance (being used as a hashmap), with properties named for fields and containing the fields' value.
now_GR	GlideRecord	The GlideRecord instance to receive the field values.
ignore	Object	An optional hashmap of field names to ignore.

表 : 10. Returns

Type	Description
void

This example updates a computer record's name and os fields, but does not update the sys_created_by field:

var now_GR = new GlideRecordUtil().getGR("cmdb_ci_computer", "2dfd7c8437201000deeabfc8bcbe5d56");   
var obj = {"name": "xyz", "os": "windows 2000", "sys_created_by", "aleck.lin"};
var ignore = {"sys_created_by": true};
new GlideRecordUtil().mergeToGR(obj, now_GR, ignore);
now_GR.update();

GlideRecordUtil - populateFromGR(Object hashMap, GlideRecord now_GR, Object ignore)

Populates a given hashmap from a GlideRecord. Each field in the GlideRecord becomes a property in the hashmap.

表 : 11. Parameters

Name	Type	Description
hashMap	Object	The object to populate with fields and values from a GlideRecord.
now_GR	GlideRecord	A GlideRecord instance positioned to a valid record.
ignore	Object	Optional. A hashmap of field names to exclude when populating the object. For each key-value pair in the map, the key is the name of the field to exclude and the value is true. {"field_name": true}

表 : 12. Returns

Type	Description
void

This example populates an object with fields and values from a Computer [cmdb_ci_computer] record.

var util = new GlideRecordUtil();
var objectToPopulate = {};
var computer = util.getCIGR("2dfd7c8437201000deeabfc8bcbe5d56"); // get CI record from cmdb_ci_computer
var ignore = {"sys_created_on": true, "sys_updated_by": true};
util.populateFromGR(objectToPopulate, computer, ignore);
// Now objectToPopulate contains field/value pairs from the computer GlideRecord
gs.info(JSON.stringify(objectToPopulate));

Output:

{
   "sys_id": "2dfd7c8437201000deeabfc8bcbe5d56",
   "operational_status": "1",
   "os_service_pack": "Service Pack 2",
   "cpu_manufacturer": "7aad6d00c611228400f00e0f80b67d2d",
   "sys_updated_on": "2024-07-27 22:28:37",
   "first_discovered": "2007-03-13 20:55:20",
   "invoice_number": "INV0166221",
   "sys_created_by": "admin",
   "warranty_expiration": "2019-10-07",
   "ram": "1534",
   "cpu_name": "Intel(R) Pentium(R) M processor 1.86GHz",
   "cpu_speed": "798",
   "sys_domain_path": "/",
   "disk_space": "51",
   "cost_center": "d9d0a971c0a80a641c20b13d99a48576",
   "assigned": "2024-03-16 07:00:00",
   "purchase_date": "2018-10-07",
   "last_discovered": "2007-04-12 23:17:45",
   "can_print": "0",
   "sys_class_name": "cmdb_ci_computer",
   "manufacturer": "aa0a6df8c611227601cd2ed45989e0ac",
   "cpu_count": "1",
   "vendor": "aa0a6df8c611227601cd2ed45989e0ac",
   "assigned_to": "47de9c73c61122930033f6521d1bb785",
   "os_version": "5.1.2600",
   "serial_number": "L3BB911",
   "cd_rom": "0",
   "unverified": "0",
   "asset": "8bc1ba8837f3100044e0bfc8bcbe5db9",
   "cpu_core_count": "1",
   "skip_sync": "0",
   "sys_domain": "global",
   "install_date": "2023-10-06 08:00:00",
   "asset_tag": "P1000227",
   "hardware_status": "installed",
   "install_status": "1",
   "name": "*ASSET-IBM",
   "virtual": "0",
   "po_number": "PO27711",
   "sys_class_path": "/!!/!2/!(",
   "company": "a66b1fb03710200044e0bfc8bcbe5d08",
   "department": "221f79b7c6112284005d646b76ab978c",
   "cost": "3665",
   "os": "Windows XP Professional",
   "sys_mod_count": "17",
   "monitor": "0",
   "model_id": "a9a2d0c3c6112276010db16c5ddd3461",
   "cost_cc": "USD",
   "location": "8225b668ac1d55eb679878e192fca315",
   "category": "Do not migrate to asset",
   "fault_count": "0"
}