Published Report not Showing Any Data
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-18-2015 06:22 AM
Hey guys, I'm sure this is related to either an ECL or Business rule for querying the table, but so far my changes haven't worked, so looking for some help.
I'm trying to publish some reports (first, below, is on the incident table, but there will also be more on the request and task table) for non-itil users to be able to view. When I look at them (obviously, as an ITIL user w/ admin/report admin) they look fine, but when I imitate one of the users, I can't see any of the list data.
(as me,data is covered, but the line items are there):
(as my test user w/ a non-itil role, no data showing):
Any ideas? They should only be able to read the data, not access it. Also, I would like to use best practices w/ concerns to security, so whatever least rights are available and not use up an extra license.
- Labels:
-
Analytics and Reports
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-21-2019 11:08 PM
I'm not sure what eventually worked for author of the question but the above response by sumit did help me in resolving a problem I was also having with reports.
Just in case someone else encounters the same, I was intending to be able to view reports via a widget in the Service Portal which may be accessed by users without any roles. My problem was it was showing no data - "0" - when viewed publicly even though I've shared it for Everyone/public. Apparently, the Business Rule "Incident query" was active so all I had to do was deactivate it.
Release: Madrid
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-03-2020 05:35 AM
Hi,
I checked and found the business rule, incident query, was active too and made it inactive (using London). Once I did that the report showed data for me when I used the URL link.
Are there any negative affects to turning off the incident query BR? The Publish a report ServiceNow Wiki page makes no mention of this other than mentioning, " Business rules may affect how records are collected for public reports."
Thanks.
Gabe
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-24-2020 10:46 PM
Hi, gsm.
My impression is that the business rule incident query acted as sort of another security mechanism to restrict access to data. My view is that ACLs should be usually enough to control this. In this case, I would suggest to double check data that may possibly be exposed by deactivating such business rules and double check whether you would need any additional ACLs to protect such data.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-08-2021 02:51 AM