Write a script for this scenario
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā02-27-2024 07:13 AM
I want a fetch a sys_id for this record ,latest_communication_date will trigger 5 time when the status will change to in stock ?
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā02-27-2024 07:36 AM
What do you mean, you need a sys_id? You are looking at the record itself, right? That means the sys_id is already in the URL of the record, and you can also find it by right clicking and check the sysID.
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā02-27-2024 07:49 AM
I am implement this scenario in this script
var last15days = Class.create();
last15days.prototype = {
initialize: function() {},
report: function() {
var result = {}; // Using an object to store unique sys_id values
var grCCC = new GlideRecord('cmdb_ci_computer');
grCCC.addQuery('u_latest_communication_date', '>', gs.daysAgoStart(10));
grCCC.addQuery('hardware_status', 'in_stock');
//grCCC.addQuery('sys_created_on', '<', gs.daysAgoStart(15));
//grCCC.addQuery('sys_created_on','>', gs.daysAgoStart(15));'u_latest_communication_date', '>', gs.daysAgoStart(15),
grCCC.addQuery('sys_class_name', 'cmdb_ci_computer');
//grCCC.setLimit(5900);
grCCC.query();
while (grCCC.next()) {
var auditQuery = 'documentkey=' + grCCC.sys_id + '^fieldname=u_latest_communication_date' ;
var grSysAudit = new GlideRecord('sys_audit');
grSysAudit.addEncodedQuery(auditQuery );
grSysAudit.query();
var count = grSysAudit.getRowCount();
if (count > 5 )
result[grCCC.sys_id] = true; // Use sys_id as key in the object
}
// Convert object keys to an array before returning
return Object.keys(result);
},
type: 'last15days'
};