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

[Shree14]

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 · Accepted solution]

Hi @Shree14 ,

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

1. 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
2. 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

[Shree14]

Thanks @AndersBGS.

Your suggested approch helps and when I tried to Launch Dependency for the Indicator Source, I could get the Dashboard it  has been used.

But when I launch dependency for Dashboard, I could see the Indicators userd, but not vice versa.

Could you please confirm if we can see the dependency from Indicator/Source.

[AndersBGS]

Hi @Shree14 ,

Which version of ServiceNow are you utilizing?

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

Best regards

Anders

[Shree14]

Hi @AndersBGS ,

I'm using UTAH Version.