Hi all,
My requirement is to show color codes in server table based on nearing/expired EOS dates.
- Red color EOS within 3 month (less than or equal to 4 months)
- Amber color EOS within 6 month (Between 4 to 8 months)
- Green color EOS in 1 yrs 0r above. (More than 8 months)
I have created a script include but it isn't working. PFB -
Script include -
var EOSColourCodes = Class.create();
EOSColourCodes.prototype = {
initialize: function() {},
redColour: function(current) {
var server = new GlideRecord('cmdb_ci_server');
server.addEncodedQuery('operational_statusIN1,9^u_os_eosISNOTEMPTY');
server.query();
while (server.next()) {
var gdt1 = new GlideDate(server.u_os_eos);
var gdt2 = new GlideDate();
gdt2.addMonthsUTC(4);
if (gdt1 <= gdt2) {
return false;
} else {
return true;
}
}
},
type: 'EOSColourCodes'
};
Field style -
1 ACCEPTED SOLUTION
Thanks all,
I was able to get this sorted using Field Styles scripting.
