script : Get updated time based on field name and record from system history table & sys audit
Logic :
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;
}
https://www.servicenow.com/community/now-platform-blog/script-get-updated-time-based-on-field-name-and-record-from/ba-p/2291904