Report of Incident Categories and SubCategories

michaelryba
Kilo Contributor

I am looking to create a report of the Incident Categories and their associated Subcategories so that the list can be reviewed by a customer. Conversely, if no report, where in the system do I go to see the full list of cats and subcats?

Thank you.

1 ACCEPTED SOLUTION

Michael Ritchie
ServiceNow Employee
ServiceNow Employee

Out of the box the category and subcategory fields are of type choice.   Choices are stored in the sys_choice table so you can create a report on that table.   Now this said any table starting with "sys" is excluded from reports but you can follow the steps here to add it: http://wiki.servicenow.com/index.php?title=Reporting_on_System_Tables#gsc.tab=0


http://wiki.servicenow.com/index.php?title=Reporting_on_System_Tables#gsc.tab=0



If you just need to export an Excel file you could also just navigate to this URL as well:


https://INSTANCE-NAME.service-now.com/sys_choice_list.do?sysparm_query=name%3Dincident%5Eelement%3Dc...


View solution in original post

3 REPLIES 3

Michael Ritchie
ServiceNow Employee
ServiceNow Employee

Out of the box the category and subcategory fields are of type choice.   Choices are stored in the sys_choice table so you can create a report on that table.   Now this said any table starting with "sys" is excluded from reports but you can follow the steps here to add it: http://wiki.servicenow.com/index.php?title=Reporting_on_System_Tables#gsc.tab=0


http://wiki.servicenow.com/index.php?title=Reporting_on_System_Tables#gsc.tab=0



If you just need to export an Excel file you could also just navigate to this URL as well:


https://INSTANCE-NAME.service-now.com/sys_choice_list.do?sysparm_query=name%3Dincident%5Eelement%3Dc...


Perfect! Very helpful.


Thank you.





Mike Ryba



Centric Consulting In Balance


(888) 781-7567 office


(630) 544-4441 <(888)%20781-7567> mobile


www.centricconsulting.com | @Centric <https://twitter.com/centric>



On Wed, Nov 15, 2017 at 12:27 PM, michael.ritchie <


Awesome glad to help.   Please mark this post as answered so others benefit from knowing the correct answer.   Thanks.