ServiceNow Queries

One large „query” is better than a lot of „get” methods

With most work, people are always looking to make things quicker, more efficient and productive.

I might not be able to help in many Business areas but I can show you how to improve the way you query!

Tested on the table: Logs [syslog]

Number of rows in table: 58 927 139

 Number of sys_ids in probe: 10 000

ServiceNow QueryScript output:

*** Script: START
*** Script: probe size: 10000
*** Script: one_query_time: 3164
*** Script: get_query_time: 6342
*** Script: END

If you’re interested in receiving the script, please reachout to us and reference this post. 

Podziel się tym artykułem