//Find table based on sys_id.This script should be run as admin user in global scope. Script gives output as table name and sysId
Link to video:https://youtu.be/_DT34P734NA
github link : https://github.com/anilvaranasi/ServiceNow
//Developed by Srinivas Anil Kumar Varanasi
//This script should be run as admin user in global scope
//Script gives output as table name and sysId
//Find table based on sys_id.
runQueryonTables();
function runQueryonTables() {
var sLog = '';
var outputJson = {};
var tableList = [];
var outputList = [];
var sysId = '2f738cab0f3600105bc5e7b1d4767e3b'; // sys_id to be updated based on requirement
var grTable = new GlideRecord('sys_db_object');
grTable.query();
while (grTable.next()) {
tableList.push(grTable.name + '');
}
for (var m = 0; m < tableList.length; m++) {
outputJson = runQuery(tableList[m], sysId);
outputList.push(outputJson);
}
for (var k = 0; k < outputList.length; k++) {
if(outputList[k].output.length >0) {
sLog += outputList[k].tableName + "=" + outputList[k].output + "\n";
}
}
gs.print("Tables matching sys_id =" + sLog);
}
function runQuery(tableName, sysId) {
var output = '';
var outputJson = {};
try {
var grQuery = new GlideRecord(tableName);
grQuery.query('sys_id', sysId);
grQuery.query();
if (grQuery.next()) {
output = grQuery.sys_id + '';
}
} catch (err) {
output = 'no access to table ' + err;
}
outputJson = {
"tableName": tableName,
"output": output
};
return (outputJson);
}
