Extract OOB categories

[Spade2]

Setting up a new implementation and have to tick off post a question to the community in my BA training;) Is there a way to extract the basic out of the box categories etc to provide to the customer to review?  thanks

[Danish Bhairag2]

Hi @Spade2 ,

You can simply open sc_categories.LIST table and export all the categories created by system/admin in an excel by right clicking on any column and then export excel.

Thanks,

Danish

[Tanushree Maiti]

Hi @Spade2 

To extract and review the basic out-of-the-box (OOTB) categories,

For Incident :

 you will be querying the Choice List [sys_choice] table  as element=category against the name=incident.

For Change Request:

The Change Management application categorizes changes by Type ( Standard, Normal ,Emergency) rather than a traditional drop-down category list.

For Catalog/Service Request:

you will be querying the sc_category table

For Knowledge Article:

You will be querying the kb_category table which is referenced in kb_knowledge .

[shubhamseth]

@Spade2 

Yes, you can extract the OOB categories, but the table depends on what area you mean.

Common examples:

Incident Category/Sub-category: sys_choice

Knowledge Category: kb_category

Catalog Category: sc_category

Service Categories: Depends on the Portal or Taxonomy setup

For Incident categories, export from:

System Definition > Choice Lists
Table = incident
Element = category

For subcategories:

Table = incident
Element = subcategory

You can export the list to Excel using list export.

For Knowledge categories, go to:

Knowledge > Administration > Knowledge Bases

Open the knowledge base and review/export related categories.

For Catalog categories:

Service Catalog > Catalog Definition > Categories