Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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

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."

*************************************************************************************************************
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/dratulgrover [ 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