logo

NJP

script : Get updated time based on field name and record from system history table & sys audit

Import · Jun 10, 2021 · article

Logic :

image

Script :

Check sys histline

var recordSysId = '5d87cfad1bcb201080af64ab234bcb9a';

var fieldName = 'u_estimated_start_date';//gs.print(getHistorySet(recordSysId));var histObj = getHistLineRecentNewVal(recordSysId, fieldName);gs.print(histObj.updatedTime);function getHistLineRecentNewVal(recordSysId, fieldName) { var returnJson = {}; var query = 'set.id=' + recordSysId + 'field=' + fieldName + 'new!=NULL' ; var grHistLine = new GlideRecord('sys_history_line'); grHistLine.addEncodedQuery(query); grHistLine.orderByDesc('update_time'); grHistLine.setLimit(1); grHistLine.query(); if(grHistLine.next()) { returnJson.updatedTime = grHistLine.update_time + ''; //returnJson.NewValue = grHistLine['new'] + ''; } return returnJson;

}

View original source

https://www.servicenow.com/community/now-platform-blog/script-get-updated-time-based-on-field-name-and-record-from/ba-p/2291904