Locate any record in any table, by sys_id in ServiceNow
Dozens of times, I've seen hard-coded sys_ids in scripts or system properties, and wanted to know what record they correspond to. Unfortunately, there isn't really a good way to do this without knowing what table the sys_id is in!
The global search box only supports searching by sys_id on tables for which that is specifically enabled, so the only solution for this has often been to scour script after script, digging down until I find where the sys_id is actually used, and try to decipher what table it corresponds to. Well, today I decided - "Enough is enough" - and I wrote a script to check each table for me. I was surprised at the ease with which I was able to accomplish my goal, as well as the speed and simplicity of the script.
Skip to the end of this article for the part where I give you a way to import this directly into your instance, for free!
So without further adieu, here is my code:
function findAnywhere(sysIDToFind, getHTML) {
if (getHTML !== true && getHTML !== 'true') {
getHTML = false;
}
var grCheck;
var tableName;
var url = gs.getProperty('glide.servlet.uri');
var grTable = new GlideRecord('sys_db_object');
//Make sure we're not looking at a ts (text search) table.
grTable.addEncodedQuery('sys_update_nameISNOTEMPTY^nameISNOTEMPTY^nameNOT LIKEts_');
grTable.query();
while (grTable.next()) {
tableName = grTable.getValue('name');
grCheck = new GlideRecord(tableName);
if (grCheck.get(sysIDToFind)) {
url += tableName + '.do?sys_id=' + sysIDToFind;
if (getHTML) {
url = '<a href="' + url + '">' + url + '</a>';
}
return url;
}
}
}Let's walk through what this code does, and then I'll show you how to use it.
First, you can see that the function (findAnywhere) takes two arguments: sysIDToFind, and getHTML. On the first line under the function, we check if the input variable getHTML is set to a valid boolean value. If it isn't, we default it to false. This way, if the user enters anything other than true (including nothing at all) as their second argument, we default the value to 'false'.
Next, we initialize a couple of variables for later use, and create a GlideRecord called 'grTable' on the sys_db_object table. This table is "the tables table". It's essentially a registry of all the other tables in the system, and some basic information about them. Later, we'll iterate over this list of every table and check each one for the sys_id we're looking for.
But before we can check each table, we want to narrow the search a little bit, to save us time, performance, and false positives. To do this, we use grTable.addEncodedQuery(). This allows us to combine several queries into one string:
This "encoded query" verifies that the name and update name fields are not empty, and then checks that the name doesn't begin with or contain ts_. This is because tables beginning with "ts_" are text search tables, and may result in false positives.
After building our filter and querying, we want to iterate over each entry in the table. For that, we use a while loop:
so for each table in our list of tables, we're going to create another GlideRecord, and check if we can ".get()" the sys_id we're searching for in that table:
In the if block (if we've found the sys_id we're looking for in this table), we generate the URL to the record so that we can return it (either on its' own, or inside of an <a href="//"></a> HTML tag:
Now, if we were to put this into a script include, we could call it like so:
If you wanted, you could work this functionality into an application module that would execute the search, return the URL, and redirect the browser to it!
For those of you who don't want to risk (or, let's face it, bother) doing this yourselves, you can import my script into your instance by following these instructions:
Click here to download my update set as an XML file.
To load into your instance, go to System Update Sets -> Retrieved Update Sets, and then click the Import Update Set from XML UI action.
Choose the XML you downloaded from the link above, then click Upload.
Finally, click on the "findAnywhere" update set in your list, and follow the instructions here, to preview and commit it.