Mass Text Copy/Paste Reporting Help

[JordanL2]

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!

[Tanushree Maiti]

Hi @JordanL2 

Assuming Subscriber ID has been stored in Incident table though it generated outside but it got synched.

1. Report (recommended 1) , List View  (Recommended 2)

Using a standard ServiceNow list view (like Incidents or Tasks) is the fastest way to perform bulk lookups without importing anything.

• Navigate to your target table (like Incident.list) and click the funnel icon to open the filter builder.
• Select the field holding your subscriber ID, change the operator to is one of, and paste your list of Subscriber IDs into the text box. ( In report , is one of can take more values than list view)
• Click Run

2) if you are simply doing an ad-hoc weekly review ,then  importing a list into a custom or staging table isn't required.

3)Since you need to do this weekly and pasting long lists can be tedious and error-prone, consider these built-in platform features:

• Save the Filter for Everyone: After running your list view search, you can save the filter conditions so other team members can access them. You can save the report and share with team
•  "copy and paste" filter conditions in list view and for reports:  refer: https://www.servicenow.com/community/sysadmin-forum/how-to-quot-copy-and-paste-quot-filter-condition...