List report identifying reports within Service Now instance that are displaying a unique column

[Greg Crowe]

I'm needing to determine amongst all the reports within our instance of Service Now, which reports are displaying a specific column. Example, we have 17,000 reports in our instance. 9,400 are list reports. How many of these reports have selected to display column G?

[sachin_namjoshi · Accepted solution]

You can report on sys_report table and query reports contains your intended column.

Regards,

Sachin

[Greg Crowe]

Thank you. I need to determine why when selecting 'select fields for list' I do not have the option of contains.

[Greg Crowe]

I do have the option of like. I was able to make this work.