- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-02-2019 02:56 AM
Hello,
I'm a beginner with ServiceNow,
I'm trying to do a report with the automatic assignment rules defined at my Servivenow installation, but I can't.
I know that the table used is sysrule_assignment, but I can't find it since report menu when I create a new report.
Could you help me?
Solved! Go to Solution.
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-04-2019 11:08 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-02-2019 09:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-04-2019 02:18 AM
Thank you very much Sachin! .
It can help me, but I "think" that for the end user have access to it, I'll have to export the list to a file, havent't it? The user asks me a Servicenow report, to access it since Servicenow.
Anyway I'll use your idea if isn't possible to obtain a servicenow report with this table.
Thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-04-2019 08:21 AM
This is happening since system tables are not reportable by default due to many reasons like performance..
https://docs.servicenow.com/bundle/madrid-performance-analytics-and-reporting/page/use/reporting/concept/c_ReportOnSystemTables.html
You can add sysrule_assignment table as exception in below UI properties to allow reporting.
Regards,
Sachin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-04-2019 11:08 AM
I thank you so much! You do not know how your help has help me...