ServiceNow fix script: get CMDB Azure classes details to see when records last updated

 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();
        }
    }
}

Comments

Popular posts from this blog

GlideRecord setValue

URL link in addInfoMessage