Reporting on a System Table

jscal
Kilo Contributor

Hello everyone,   I need some help   getting this report,       I   will really appreciate it   if someone can give me a hand,  

I need   to create a report,   and get the information of   all the   assignment groups a bunch of incidents had. ( Assignment History)

I know how to extract the Calendar and Listed Version of Each incident,     using this post: http://wiki.servicenow.com/index.php?title=Viewing_a_Record%27s_Change_History#gsc.tab=0

But i need to extract the same info   but from   several incidents,     so I came across   this post: http://wiki.servicenow.com/index.php?title=Reporting_on_System_Tables#gsc.tab=0

where they explain   that I need to add it to the glide.ui.permitted_tables property. Navigate to System Properties > UI Properties and locate the property labeled List of system tables (beginning with "sys_", comma separated), that are reportable.  

So I go to My ServecieNow Instance, and put on the   sys_properties.list   on the Navigation Filter, in there   I can see all this   Sys listing tables   explained in this   Post:   https://docs.servicenow.com/bundle/helsinki-release-notes/page/administer/reference-pages/reference/...

So when its time   to edit the   table   following this   steps:   https://docs.servicenow.com/bundle/helsinki-servicenow-platform/page/administer/reference-pages/task...     I found the tables:

BorrarSN.PNG

But   Every time I try to click on   any to edit it,   the system kicks me out of that window   and I get the following message:

To edit a specific system property, use the appropriate Configuration page

So can anyone tell me what am I doing wrong?

Or if there is another way?

Im Using Helsinki.

Hope   you guys can help me,

Have a Great day,

VN

1 ACCEPTED SOLUTION

Chuck Tomasi
Tera Patron

Here's a little trick Jose,



Enter the table name in the navigation filter...



find_real_file.png



When the list comes up, pick a column, right click, and create   bar chart report.



find_real_file.png



You are now running a report on that table. Configure the report the way you like!



find_real_file.png



Generating Reports - ServiceNow Wiki


View solution in original post

2 REPLIES 2

Chuck Tomasi
Tera Patron

Here's a little trick Jose,



Enter the table name in the navigation filter...



find_real_file.png



When the list comes up, pick a column, right click, and create   bar chart report.



find_real_file.png



You are now running a report on that table. Configure the report the way you like!



find_real_file.png



Generating Reports - ServiceNow Wiki


Thank you so much   Chuck,     this worked !