Benoit Crestey
ServiceNow Employee
ServiceNow Employee

Why?

  • To explore the cosmos of your ServiceNow data like a jedi

 

What is the Data Explorer?

  • It is a tool to navigate the data in the platform
    • It can display Records (table but also CMDB), References and CMDB Relationships
    • It is now limited to administrators, but could be improved later
  • As of now it is a lab to test more advanced features, I am still analyzing the Use Cases
    • Feel free to contact me if you have feedback or ideas

 

What does it look like?

BenoitCrestey_0-1687276203723.png

 

Warnings

  • This tool is a technical tool I developed, it is not an official ServiceNow tool
  • This tool could be bugged and should be used for debug purpose only

 

Usage

  • From any Form, click on the UI action to open the navigator in a new Window
    • From this view, it is possible to select a Node and click on it to see relationships
    • By clicking on relationships, the map will deploy

BenoitCrestey_0-1687275424596.png

Main Window

BenoitCrestey_1-1687275448377.png

 

Main Window (commented)

BenoitCrestey_2-1687275471467.png

How to install

  • As an admin, download and install the attached Update Set on your instance :
    • Download
    • Navigate to System Update Sets > Retrieved Update Sets.
    • Click the Import Update Set from XML link
    • Select the downloaded file and Upload
    • Open the Update Set
    • Click Preview Update Set
    • Click Commit Update Set
    • Navigate the cosmos (optional step)

 

Known limitations

  • Remote and Rotation Tables ignored
  • Incoming reference on sys_db_object ignored
  • Some technical tables ignored, see script for detail

 

Technical objects

  • UI Page
    • BCRCMDBExplorerv3
  • Script Include (Ajax)
    • BCRCMDBExplorerHelper : Main script
    • BCRTableUtilsHelper : use for Scoped Applications (could be used later)
  • UI Action
    • On global

 

Version History

3.1 : First Release

3.2 : Add ability to load incoming of current selected CI, menu repaired, link to article

3.4 : UI modifications

 

Comments
Benoit Crestey
ServiceNow Employee
ServiceNow Employee

Update 3.2 released with minor changes

- Ability to load incoming of current selected CI without changing the parameter for otehr CIs

- Menu on right click repaired

- Added link to this Community Article

Jens Dienst
Tera Explorer

If you happen to ever come near Dresden get in touch, I'd be happy to buy you a beer for it. 🙂

Benoit Crestey
ServiceNow Employee
ServiceNow Employee

Update 3.4 released with minor changes

- Improvement in UI

eromanek
Tera Contributor

Is there a way to use this tool in reporting?  I'm having trouble getting to one specific set of information using the task_time_worked table and want to see where the data I want is accessible in the databases and links.

Version history
Last update:
‎11-14-2023 02:35 AM
Updated by:
Contributors