Table to extract CI classess on CMDB

Servicenow lear
Tera Contributor

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 ? 

 

Servicenowlear_0-1705329910073.png

 

1 ACCEPTED SOLUTION

AndersBGS
Tera Patron

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 

View solution in original post

4 REPLIES 4

JaeggerLegane
Kilo Sage

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
Tera Patron

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 

Hi Anders,

 

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

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