How to publish or unpublish a report using the Report Builder interface - Support and Troubleshooting

How to publish or unpublish a report using the Report Builder interface Issue .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Important: Report Builder functionality has been deprecated beginning with the Utah release. For information on sharing data visualizations in the Core UI, see the Core UI sharing documentation . For information on sharing data visualizations in Platform Analytics, see the Platform Analytics sharing documentation .

You can publish a ServiceNow report to generate a URL that anyone can use to access it, including people who are not users on the instance. When someone goes to the URL, the report is generated with current data. The report remains available until it is unpublished. This article explains how to publish and unpublish a report using the classic Report Builder interface.

For more information about the purpose, permissions, and accessibility of published reports, see Publish a report .

Before publishing, review the report to confirm it does not contain data that should not be available to users without proper permissions. After publishing, the report URL can be accessed by anyone with internet access — no login or credentials are required.

Release .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Utah and above

Resolution .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Publishing a report Before publishing, review the report to confirm it contains the necessary information and no data that should not be publicly accessible.

Log in to the instance with an account that has the necessary permissions to publish the report. This requires the admin or report_admin role, or both the report_publisher and report_user roles. Go to Reports > View / Run. Locate the report you want to publish and open it for editing. Select the Action Arrow button immediately to the right of the Save button. From the menu that appears, select Publish. A message appears confirming the report is published and providing the report URL. Each time you open this report for editing in the Report Builder interface, the URL appears at the top of the record. Copy and distribute this URL to anyone who needs to view the report.

The URL follows this format:

https:// .service-now.com/sys_report_display.do?sysparm_report_id=

Where is the name of the instance and is the unique system-generated ID of the report.

Unpublishing a report Log in to the instance with an account that has the admin or report_admin role and access to the report record. Go to Reports > View / Run. Locate the report you want to unpublish and open it for editing. Select the Action Arrow button immediately to the right of the Save button. From the menu that appears, select Unpublish. A message appears confirming the report is no longer public. The report URL is no longer accessible. How to find all published reports on your instance Option 1: Filter the sys_report table Go to the sys_report table. Filter the table using the condition roles = public (encoded query: roles=public ). Review the list and identify any report that no longer needs to be published. Option 2: Run a background script Run the following script in Scripts - Background (global scope) to return a count of all published reports:

var grReport = new GlideAggregate('sys_report'); var reportQueryString = "roles=public"; grReport.addEncodedQuery(reportQueryString); grReport.addAggregate('COUNT'); grReport.queryNoDomain(); if (grReport.next()) gs.print(grReport.getAggregate('COUNT')); Note: The is_published boolean field is an informational display field only. The roles field controls which reports are published. When you unpublish a report — either by selecting Unpublish in the report or by removing the public role — a business rule updates the is_published value automatically.

Unpublish all reports at once To unpublish all published reports, run the following script in Scripts - Background (global scope).

Note: Test this script on a non-production instance before running it in production