How Do I Build a Query For Reports Shared With a Certain User or Group?

[JosephW1]

I am trying to build a query for all reports shared with any given user or group. I am unsure where this data is stored.

I have discovered that the sys_report table's "User" field is set to GLOBAL if the report is shared globally, group if shared to groups or users, and to the creator's user sysid if not shared. However, I am unable to query which users or groups via that field and I have been unable to find a field in the sys_report table that seems to house the values of which users or groups the report is shared with.

Please, which table(s) and field(s) house the information I am looking for? Thank you so much!

[JosephW1 · Accepted solution]

As per https://community.servicenow.com/community?id=community_question&sys_id=a4d9fcd7db4e67807d3e02d5ca96...

It is the sys_report_users_groups table's "User ID" field. Thank you.