Pro-Tips Blog

Deep dives, tutorials, and practical guides for ServiceNow developers and admins.

Flow Designer vs. Scripting - REST Message Performance

Some of our existing ServiceNow outbound REST calls were being made through a Flow Designer action, using an imported RestMessage with OAuth authorization (typical OAuth Application Registry and OAuth Profiles). This was initially set up since our /oauth/token endpoints were internal and not on the

Tim Woodruff ·

Find Filthy Inefficient Single-Record Queries FAST

I made a thing. The script at the bottom of this article scans all scripts in a given table/field for GlideRecord queries that use if (gr.next()) {} WITHOUT a preceding .setLimit(1) before .query(). Unfortunately, since there is no way (to my knowledge) to filter out-of-box recor

Tim Woodruff ·

Calculate Distance Between Two Locations in ServiceNow (without an API call!)

If you need to calculate the distance between two Location records in the cmn\_location table in ServiceNow, as long as both of those locations have latitude and longitude values, you can do so using the script below! Usage examples at the bottom. You can turn these functions into methods of a Scr

Tim Woodruff ·

How to Identify Duplicate Records by Multiple Fields in ServiceNow

> “*I have some records in a table which are duplicates. In this case, I can only identify “duplicate records” by whether several fields are identical; not just one. For example, let’s say I want to identify Incidents where the Short description, Assignment group, and Assigned to user are all the sa

Tim Woodruff ·

How to Merge Personal & Company ServiceNow Accounts

If you got your ServiceNow certifications or made progress in courses on NOW Learning using a ServiceNow partner or customer account, you may find that when you move on to another company, you no longer have access to those certifications or training progress. This can be frustrating, and unfortunat

Tim Woodruff ·

5 Lessons About Programming From Richard Feynman

I believe that Richard Feynman can teach ServiceNow developers (and any software developers) a great deal - about physics, sure; but also about our own discipline. I'm something of a physics nut myself (insert Spider-Man meme here), which has led me to something of an obsession with Richard Feynman

Tim Woodruff ·

Your ACLs and Business Rules are Broken (Here's How to Fix Them)

> “My ACL requires a given role. A user has that role, but is still failing the access check. The ACL debugger says that the ACL script is what’s failing, but my ACL is not “Advanced” and there’s no script field! What is going on??” Even when the "Advanced" checkbox is unchecked on your ACLs or B

Tim Woodruff ·

ServiceNow Developers: BE THE GUIDE!

Every ServiceNow developer, administrator, and architect has at one time or another, got a requirement from their client that they know is bad-practice, silly, or sub-optimal. I often come across developers in the ServiceNow communities (such as the ServiceNow Developer [forums](https://commu

Tim Woodruff ·

Search