How to extract all category subcategory item report?

[Sameeksha M]

How to extract Category Subcategory Item from incident table?

All together report based on dependent value in one excel sheet.

[Jean-Emmanuel 1]

Hello Sameeksha,

You can extract the list of categories and subcategories from All> System Definition > Choice Lists

On the displayed list, add filter on the fields Table ( Table is incident) and Elements (Element contains category).

Right click on any column, and then you can Export in the format of your choice

Hope it helps you.

Please Mark ✅ Correct/helpful if applicable, Thanks!! 

[Sameeksha M]

Hi Jean,

I want all these 3 CSI in one excel sheet. 

Is that possible to extract category subcategory item in one excel sheet?

[Jean-Emmanuel 1]

Thank you for your feedback,

If I understand correctly, you want Item, Subcategory and Category as columns of your list.

You can do it easily in ServiceNow with Database view ( equivalent of join if you know SQL) on the same table and choose Dependant value as the key for the join.

You can found resource regarding Database view here

Hope it helps you.

Please Mark ✅ Correct/helpful if applicable, Thanks!!