How do we find out the record, given the sys_id?

[upasanamahanta]

Given a sys_id, how do we find to which record the sys_id belongs to?

[arobertson]

I would have thought you could look on the task table and create a filter to search for sys_id in question?

[Community Alums]

Out on share there is an app called OneSearch that searches (among other items) sys_id. Perhaps that is what you are looking for?

[Chuck Tomasi · Accepted solution]

You COULD write a script that goes through sys_db_object and checks each table to see if it can find the record. With over 2,000 tables in a default Helsinki instance, this could take a while. The *untested* script might look something like this:

var mySysId = 'xxxxxxxxxxxxxxxxxxxxx'; // put in your sys_id here
var table = new GlideRecord('sys_db_object');
table.query();

while (table.next()) {
       var gr = new GlideRecord(table.getValue('name'));
       if (gr.get(mySysId)) {
                   gs.log('it looks like it came from ' + gr.getValue('label'));
                   break;
       }
}

[upasanamahanta]

yes, Chuck. Even I was thinking about to write this script. Thank you