Table to extract CI classess on CMDB

[Servicenow lear]

Hello All,

I want to extract all CI classess in use in our CMDB.

CMDB-CI has that CI class column but the records are too much to do an export.

Is there a direct table with all CI class in use to view ? 

[JaeggerLegane]

Hello Lear,

You can do this as followed:
1. Filter navigator -> Type cmdb_model_category.list
2. Add the condition -> CI class is not empty
3. Add the column CI Class if not already present
4. Export to excel

This should save you some time instead of exporting the cmdb_ci records which likely go into the thousands or millions.

[AndersBGS · Accepted solution]

Hi @Servicenow lear ,

You can utilize the table "cmdb_class_info". Just write: cmdb_class_info_list in the application navigator.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders 

[KishoreR]

Hi Anders,

I tried but not finding this table from the application navigator. Please advise any other way to open this. 

[AndersBGS]

Hi @KishoreR ,

Did you write cmdb_class_info.list in the application navigator? Are you an admin?

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders