A Group is missing from shared reports of a dashboard

[Himanshu Raj]

Hi All,

I am having issue with multiple reports in a dashboard missing an assignment group to which the reports were shared. I am not able to figure out how it is removed. Is there any way we can check who updated the sharing setting for reports/ dashboard in ServiceNow.

Thanks in advance.

[hafsaparveen]

Hi Himanshu,

There is a way to track changes to records, including changes to sharing settings for reports and dashboards. You can use the System Audit [sys_audit] table to view a history of changes made to a record.

1. Go to "System Audit" (sys_audit.list)  in the application navigator.
2. Apply filters to find the specific reports or dashboards ("sys_report" for reports, "sys_dashboard" for dashboards) you're concerned about.
3. Look for records related to the reports or dashboards.
4. Open the audit record to see details like the user who made the change, the date, and what exactly was modified.

I hope this is helpful. Please mark this response as helpful if it helps you.

[JaeggerLegane13]

I would recommend the following solution:

Steps:
1. Open filter navigator and type sys_report_users_groups.list
2. Search the related report
3. If changes were made to the assignment group, you should find it in the group ID field.
Also recommend to add the updated by column so you know who caused the edit.

Example:

[Himanshu Raj]

Thanks for your reply.
I already tried this, but since a group is removed from sharing setting of that report, the corresponding record is missing from this table and also, I couldn't find any corresponding record in deleted Records table. 

Please let me know if you have any further idea on same. Thanks in advance.