UI Builder Reports
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
8 hours 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
8 hours 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
5 hours 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/
