How to report on Indicator use in Data Visualizations?

[VincentLastname]

We need to determine the impact of changing or deleting one of the many Indicators our teams manage and knowing where it's used is key.

I'm trying to see if there exists a way, preferably out-of-the-box, to find where Indicators are being used in Data Visualizations in Platform Analytics? also known as Data Sources from the perspective of editing a Visualization

(Also, for clarity, I do not need to search for their use in Widget's inside of Performance Analytics which I'm being told is being sunset at the end of the year)

Here is a screenshot of a Data Source [pa_indicator] being used in a Visualization. 

I know the PAR Visualization [par_visualization] table is close, but that only shows Data Visualizations that are using a table, like Task [task] rather than Indicators.

ServiceNow version: Washington

[Nick Marshall]

I would also be interested in understanding this - team is currently migrating from Performance Analytics to Platform Analytics; currently track usage and location of widgets, filters and reports across dashboards by exporting this detail from the Admin Console - they would like to understand what similar could be done in Platform Analytics. 

[olgaredkina · Accepted solution]

Hi Vincent,

There are 3 places indicator can be used in next experience UI:

1. Saved visualizations  - par_visaulization table

2. Dashboard widget (both saved and not saved visaulizations)  - par_dashboard_widget table

3. Technical dashboards/UI builder pages - sys_ux_macroponent table

To check if indicator is used you would search by indicator sys_id in "properties" field for par_visaulizations, "Component proeprties" in par_pashboard_widget and in "Composition" field of sys_ux_macroponent table. You can just search "Contains" <indicator sys_id> or if you want to be extra sure "contains" "indicator":"<indicator sys_id>".

Regards,

Olga

[VincentLastname]

PAR Dashboard Widget [par_dashboard_widget] is the table I needed. Thanks!

Not able to open the sys_ux_macroponent table so I dunno if that works.