Reports created from a list are automatically shared

MarkD
Tera Expert

ServiceNow has a feature that allows users to create report from a list of records:

To do this, we select the three dots from a column header, then "Bar Chart" or "Pie Chart" from the menu.

MarkD_0-1749488983476.png

 

However, whenever we do this, the resulting report is automatically shared with four specific users.

 

MarkD_2-1749489122739.png

 

I'm not sure where this was configured in order to change it.  Can anyone point me to where I can change this so that the reports aren't automatically shared?

 

1 ACCEPTED SOLUTION

MarkD
Tera Expert

Following up with the solution, in case it helps someone else in the future.

 

When you share a report a record gets created on the following table:

sys_report_users_groups

 

On this table I filtered to show entries where the Report ID was empty:

MarkD_0-1749504157946.png

...the same four names appeared!

I deleted these records, and the problem was resolved. *

 

The presence of these records that were missing a report ID seemed to cause any new report to be automatically shared with the users.

 

*Note that I had to use a background script to delete the records with gs.deleteRecord(true)

View solution in original post

3 REPLIES 3

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @MarkD 

No, this feature is not available out-of-the-box. I believe sharing should always be explicit to ensure users know exactly with whom the report is being shared."

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

MarkD
Tera Expert

Following up with the solution, in case it helps someone else in the future.

 

When you share a report a record gets created on the following table:

sys_report_users_groups

 

On this table I filtered to show entries where the Report ID was empty:

MarkD_0-1749504157946.png

...the same four names appeared!

I deleted these records, and the problem was resolved. *

 

The presence of these records that were missing a report ID seemed to cause any new report to be automatically shared with the users.

 

*Note that I had to use a background script to delete the records with gs.deleteRecord(true)

manu18461099391
Tera Contributor

instead of using this, i use create report option by using tables. so that i can see them anytime on ServiceNow