- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-15-2017 10:12 AM
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.
Solved! Go to Solution.
- Labels:
-
Incident Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-15-2017 10:27 AM
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:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-15-2017 10:27 AM
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:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-15-2017 11:01 AM
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 <
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-15-2017 11:12 AM
Awesome glad to help. Please mark this post as answered so others benefit from knowing the correct answer. Thanks.