Find a specific record used in entire instance like business rules, client script, workflow and all

[surya74]

Hi Everyone,
Need reusable script to find a specific record used in entire instance like Business Rules, Client Scripts, Script Includes, Workflows, Flow designers, Scheduled scripts, ACLS, Data policies, Transform Scripts, Integrations, REST Messages Catalog Variables and all catalog related policies and scripts, custom tables resembling Business Hierarchy and all tables/ columns where Business Hierarchy, Functional Hierarchy and Alternate Hierarchy tables are being referenced.
We need to replace the that record with some other records. Please suggest how to achieve this requirement.

[Tanushree Maiti]

Hi @surya74 

• Use code search in ServiceNow Studio to search through all applications and tables on an instance to locate a specific app, app file, or code snippet. Refer: Find an app or app file using code search
• You can check the Payload field for your keyword in sys_update_xml.
• You can check sys_hub_flow for Subflow related keywords
• Explore sys_variable_value table for keyword search in Workflow activity

At the end , check the tables and to make easy your job, write a background script as per your requirement