How to determine if a catalog field is used in any reports

stevezempke
Tera Contributor

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.

3 REPLIES 3

Mike_R
Kilo Patron
Kilo Patron

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.

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?  

Mosh Jah_n1
Giga Expert

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.