Is possible to create a report with assignment rules?

I_aki_Maria
Giga Contributor

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?

1 ACCEPTED SOLUTION

I_aki_Maria
Giga Contributor
I thank you so much! You do not know how your help has help me... 

View solution in original post

6 REPLIES 6

sachin_namjoshi
Kilo Patron
Kilo Patron

You can also report using list view filters.

 

Type sysrule_assignment.LIST in your navigator to go to list view of assignment rules.

 

find_real_file.png

 

REgards,

Sachin

 

 

I_aki_Maria
Giga Contributor

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

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

 

 

I_aki_Maria
Giga Contributor
I thank you so much! You do not know how your help has help me...