We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

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

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

4 REPLIES 4

Michael Ritchie
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.


great full 




Trackpad Business Consultant

Connect:
track-pad.com  13013776567 Talent@track-pad.com