How to determine if a catalog field is used in any reports
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-11-2022 06:27 AM
I have a request from a user to hide some fields on our incident form. Easy enough to do, however, i want to ensure that the fields being hidden aren't used in any reports that i don't know about and that will cause users anxiety if their reports aren't correct.
Is there a way to determine if a field is used on any reports, either out-of-box reports or user created reports?
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-11-2022 06:32 AM
Start with this
instanceNameservice-now.com/sys_ui_list_element_list.do?sysparm_query=list_id.sys_name%3Dincident&sysparm_view=
This will show if anyone is using the column in their list view.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-11-2022 06:40 AM
Thanks Mike. I tried this and i can pull up the fields on our incident form but how can i tell what specific list view and reports the fields in question are on?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-14-2023 10:46 PM - edited 04-14-2023 10:46 PM
Hi Steve
Did you get an answer to your query? I had the same requirement recently while tidying up redundant attributes.
I found that the fields used by a report can be found in table "sys_report", in the column "field_list". Additionally you may want to check the "filter" column too to see if a field is used by the filter even though it may not appear on a report.