Report on Category and Sub category.

[Atchutaram]

Hi Experts,

Good Day,

                          I have been trying to generate a report on categories and Sub categories for Incidents, change, knowledge and Problem in one single report.

Could you pleas assist me with this.

Best Regards,

Vinjamuri Srikar

[Community Alums]

Hi @Atchutaram ,

Since Category & Subcategory is not extended from TASK table this is wont be visible on the columns, however in the columns if you extend the Parent field and search for category [incident], subcategory[incident]  if you add to the columns then it will be available..

Once you extend the parent filed search for subcategory as shown below:

  You can do group by "category" and Additional group by " Subcategory"

[Atchutaram]

Hi Sandeep,

                        Thank you for your response, but i am looking for a report which show list of all categories and sub categories in servicenow.

Best Regards,

Atchutram

[Community Alums]

Hi @Atchutaram ,

You could have achieved this, if we had an option to create a report on sys_choice because all the choices are stored in this table. However, by default ServiceNow limits reporting on some of the tables and sys_choice is one among them. Having said, I am not sure if you can really show all the categories and subcategories in on report. 

Please mark helpful/Like, if the solution in line in your expectation.

Regards,

Gagan k

[BharathChintala]

Hey Srikar,

You can achieve it by doing report on sys_choice table. But to get sys_choice table in reporting list update follow property first

system property 'glide.ui.permitted_tables'. 

Thanks,

Bharath