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

[Rahul Priyadars]

There is not table which stores relationships between Model and Model Category

Model is an Attribute of a CI/Asset with label as Model ID(Reference Field)

Model Category- Model Categories match up CI Classes and Asset Classes. If you create a CI of a particular type, ServiceNow knows to create a corresponding asset of the type identified. When you create an asset, you identify the Model Category so ServiceNow can create a corresponding CI.

 details are in this article 

https://www.servicenow.com/community/in-other-news/models-vs-model-categories-model-management-part-...

Regards

RP

[Ehab Pilloor]

Hi @Khushi_,

In ServiceNow, the `cmdb_model` table represents Configuration Item (CI) models, which are templates or blueprints for actual CIs in the Configuration Management Database (CMDB). On the other hand, the `cmdb_model_category` table stores information about the categories associated with CI models.

The relationship between `cmdb_model` and `cmdb_model_category` is established through a reference field in the `cmdb_model` table. Specifically, the `cmdb_model` table includes a reference field named `category` that points to records in the `cmdb_model_category` table.

To locate the relationship information between these two tables in the ServiceNow platform, you would inspect the schema of the `cmdb_model` table. Here's a brief summary of the relationship:

- Table Name (Reference Field): `cmdb_model`
- Reference Table: `cmdb_model_category`
- Reference Field in `cmdb_model`: `category`

By exploring the schema or data dictionary in ServiceNow, you can gather detailed information about the fields, relationships, and dependencies between the `cmdb_model` and `cmdb_model_category` tables. This understanding is crucial for effectively managing and configuring CI models and their associated categories in the CMDB.

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

Thanks and Regards,

Ehab Pilloor

[Khushi_]

Hi ehab, Thank you for your response 😊. Now I have the clear picture of these two table.

[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