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

[VaranAwesomenow]

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

Check sys audit

var obj1 = getAuditData(recordSysId1, 'u_practice_leader', 'u_enterprise_architecture_service_item');
//gs.print(obj1.updatedTime);
function getAuditData(documentKey, fieldName, tableName) {
var returnJson = {};
var query = 'documentkey=' + documentKey + '^tablename=' + tableName + '^fieldname=' + fieldName;
var grSysAudit = new GlideRecord('sys_audit');
grSysAudit.addEncodedQuery(query);
grSysAudit.orderByDesc('sys_created_on');
grSysAudit.setLimit(1);
grSysAudit.query();
if (grSysAudit.next()) {
returnJson.updatedTime = grSysAudit.sys_created_on + '';
}
return returnJson;
}