// 7.  Set all Data Management Tasks to 'Cancelled'...
// JWJ  03.13.24
ClearUserLog();
UserLog("1. Starting 'data-management' script", "DATA-MANAGEMENT");
gs.setSession.setStrictQuery(true);
// --use a GlideRecord against the data management table  ****  our variable is 'grcmdbtask'
var grcmdbtask = new GlideRecord('cmdb_data_management_task');
// --create the query
grcmdbtask.addEncodedQuery('state=1^stateNOT IN3,4,7,8');
// --call the query
grcmdbtask.query();
UserLog("2. found " + grcmdbtask.getRowCount() + " records to update.", "DATA-MANAGEMENT");
while (grcmdbtask.next()) {
    // --flip the state over
    UserLog("3. changing: " + grcmdbtask.number + " to CANCELLED.", "DATA-MANAGEMENT");
     //grcmdbtask.getValue('cmdb_data_management_task');
     //grcmdbtask.getValue(grcmdbtask.sys_id);
    //UserLog(grcmdbtask.number);
    grcmdbtask.state = 'cancelled';
    grcmdbtask.update();
}
UserLog("Post Upgrade 7 complete: ", "DATA-MANAGEMENT");
gs.info('Post Upgrade 7 complete '); // was gs.info