var tables_to_deoperate = generateReport().toString();
gs.print('\n tables_to_deoperate: \n' + tables_to_deoperate);
deoperateRecordsOfTables(tables_to_deoperate);
function generateReport() {
var tables = new GlideRecord('sys_db_object');
tables.addQuery('name', 'CONTAINS', 'azure');
tables.addQuery('name', 'IN', getTableExtensions('cmdb_ci'));
tables.query();
// gs.print(tables.getRowCount());
var encoded_condition = 'sys_updated_on<javascript:gs.beginningOfOneYearAgo()';
var tables_meeting_condition = [];
while (tables.next()) {
var table_name = tables.name.toString();
var msg = '';
var azure_table = new GlideRecord(table_name);
azure_table.addQuery(encoded_condition);
azure_table.orderByDesc('sys_updated_on');
azure_table.query();
var records_count = azure_table.getRowCount();
msg += 'Table name: ' + table_name + '\n';
msg += 'Number of records in table \'' + table_name + '\': ' + records_count + '\n';
msg += 'https://' + gs.getProperty('instance_name') + '.service-now.com/' + table_name + '_list.do' + '\n';
if (records_count > 0) {
azure_table.next();
msg += 'Last updated record date/time: ' + azure_table.sys_updated_on.getDisplayValue() + '\n';
var current_azure_table = new GlideRecord(table_name);
current_azure_table.addQuery('operational_status', 1); // Where 'Operational Status' is 'Operational'.
current_azure_table.query();
if (current_azure_table.getRowCount() == records_count)
msg += 'All records have an Operational Status of: ' + azure_table.getDisplayValue('operational_status') + '\n';
else
msg += 'Only ' + current_azure_table.getRowCount() + ' records have an Operational Status of: ' + azure_table.getDisplayValue('operational_status') + '\n';
}
tables_meeting_condition.push(table_name);
gs.print(msg);
}
// gs.print(tables_meeting_condition);
// gs.print(tables_meeting_condition.length);
return tables_meeting_condition;
}
function deoperateRecordsOfTables(tables_to_deoperate) {
var tables = tables_to_deoperate.split(',');
for (var i=0; i<tables.length; i++) {
var azure_table = new GlideRecord(tables[i]);
azure_table.addQuery(encoded_condition);
azure_table.addQuery('operational_status', 1); // Where 'Operational Status' is NOT 'Operational'.
azure_table.query();
gs.print('azure_table.getRowCount(): ' + azure_table.getRowCount());
gs.print('tables[i]: ' + tables[i]);
while (azure_table.next()) {
// azure_table.operational_status == '6'; // Set 'Operational Status' to be 'Retired'
azure_table.autoSysFields(false); // Leave last update intact
azure_table.setWorkflow(false); // Skip business rules and notifications
azure_table.setEngines(false); // Skip data policy rules
// azure_table.update();
}
}
}
these seem to work! function onSubmit () { alert ( g_form . getDisplayBox ( 'cost_center' ). value ); //--classic UI alert ( g_form . getDisplayValue ( 'cost_center' )); //--service portal }
Comments
Post a Comment