Hi everyone,
I’m looking for some guidance on a reporting scenario in ServiceNow. A stakeholder is working with a weekly report (generated outside of ServiceNow) that contains a large list of subscriber IDs. She needs a way to determine whether any tickets in ServiceNow are associated with those subscribers.
Ideally, we’re hoping to:
- Take a bulk list of subscriber IDs (copy/paste, not an import)
- Query ServiceNow to identify any related incidents/tasks/records
- Avoid having to search each subscriber ID individually
I’ve explored the reporting module but haven’t found a straightforward way to support bulk filtering from a pasted list of values. The list of values will be changing weekly.
Questions:
- Is there a recommended approach for performing bulk lookups like this?
- Would this require importing the list into a table (e.g., via Data Import or staging table) and then reporting off that? This is not our preferred route but worth asking.
- Are there any out-of-the-box features, scripts, or best practices for handling this type of use case?
Any suggestions or patterns you’ve used for similar scenarios would be greatly appreciated.
Thanks in advance!
