How to find all Report/PA/Dashboards which are using a Particular Field from Problem Table.

Shree14 · ‎06-21-2023

Hi Developers,

I want to get list of all Reports/Dashbaords which are making use a Field[u_state_code >> String Field with Choices] from Problem Table.

We are planning to depricate the Custom Field and hence we want it's impact in Reporting.

Please let me know the best way to achieve this.

For Report, I could get the list with Filtered condition contains this field, please suggest if we have any other ways.

Thanks,

Shree

AndersBGS · ‎06-21-2023

Hi @Shree14 ,

From my point of view you need to do several investigations:

Reports
1. Look at the table utilized --> is it problem
2. If yes, look at the conditions --> does it have u_state_code
3. If yes, look at the grouped by filled --> does it have u_state_code
Indicator sources
1. Look at the table utilized --> is it problem
2. If yes, look at the conditions --> does it have u_state_code
3. Look at the related indicators conditions --> does it have u_state_code

Above should give you a pretty clear picture if the field us utilized anywhere. From the report/indicator source/indicator, you can utilize the Dependency assessment to investigate which dashboard(s) that will be impacted.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

AndersBGS · ‎06-26-2023

Hi @Shree14 ,

Then you should be able walk back and forth in the dependency view. Where do you experience problem? Dashboard --> Indicator source or Indicator source --> Dashboard?

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Christian45 · ‎08-31-2023

Hey @AndersBGS

I am having the same Q -> not seeing the Dashboard an indicator is used on. (indicator -> dashboard)

the other way around it is working perfectly fine.

do you have any advice here, or if its simply not working that way?

merci

br

Christian

AndersBGS · ‎08-31-2023

Hi @Christian45 ,

In general it should work both ways expect, I do recall a previous version Tokyo or San Diego that there were an error in ServiceNow where you couldn't see the dashboard from the indicator level.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/