UI Builder Reports

harinya
Tera Contributor

3 weeks ago

Hi,

Can someone please help confirm where UI Builder reports are stored on the backend in ServiceNow (which table)?

We have a database view that is currently being used in a few reports, and I would like to identify all the reports where this view is being used. I am planning to remove one table from the database view and want to understand the impact before making the change.
Thanks in Advance

0 Helpfuls
  • 279 Views
2 REPLIES 2

TharaS657398130
Giga Guru

3 weeks ago

Hi

You can search in normal sys_reports table as well as Indicators(Performance Analytics) or try these

 

  • sys_ux_page
  • sys_ux_macroponent
  • sys_ux_component

 

0 Helpfuls

Ankith Sharma
Tera Guru

3 weeks ago

From what’s  @TharaS657398130 already mentioned, those tables help identify where components/pages are used.

Adding to that, if your goal is to track DB view usage specifically, it’s better to start from the data layer:

  • Check sys_ux_data_source > this is where the actual table/DB view is defined
  • Then look at sys_ux_data_visualization > to see which visualizations are using that data source
  • From there, you can trace usage in sys_ux_page / sys_ux_macroponent

Also don’t forget to check the sys_report (classic reports) and PA indicators (if they're using Performance Analytics)

This approach helps you trace it end-to-end: DB view > data source > visualization > UI usage, which gives a clearer impact before modifying the view.

 

If you found this useful, feel free to mark it as Accept as Solution and Helpful. It makes my day (and helps others too 😉).

Regards,
- Ankit
LinkedIn: https://www.linkedin.com/in/sharmaankith/

0 Helpfuls