CMDB

[Khushi_]

Hi all, What is the relation between cmdb_model and cmdb_model_category. Which table stores the relation between these two.

[AJ-TechTrek · Accepted solution]

Hi @Khushi_ ,

Refer below KB article to provide more insight of relation in cmdb Model and cmdb model category.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0724180

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.

Thanks

Ajay Kumar

[Pankaj kr]

Hi Khushi,

You can find the relation in list view also from the cmdb_model table. PFB snap for more info.

If you found this reply useful, please mark it as solution/helpful.

Thanks and Regards,

Pankaj Kumar

[Harish Bainsla · Accepted solution]

Hi

In ServiceNow, the cmdb_model and cmdb_model_category tables are part of the Configuration Management Database (CMDB) schema, and they are related to each other through a reference field.

Here is the basic relationship between these tables:

1. cmdb_model Table:

   • This table stores information about hardware and software models in the CMDB.
   • Examples of models include computer models, server models, printer models, etc.
   • It contains various attributes related to the models, such as the manufacturer, category, and other details.

2. cmdb_model_category Table:

   • This table stores information about model categories in the CMDB.
   • Model categories provide a way to categorize and organize different types of models.
   • Examples of categories might include "Computer," "Server," "Printer," etc.

3. Relation:

   • The relationship between these two tables is established through a reference field in the cmdb_model table.
   • The reference field in the cmdb_model table points to the cmdb_model_category table, indicating the category to which a specific model belongs.

Reference Field:

• In the cmdb_model table, you would typically find a reference field that refers to the cmdb_model_category table. The name of this reference field might be something like category or cmdb_model_category.

[Khushi_]

Hi Harish, Thank you so much for such a explained and elaborated answer 😊 .