What is the use and relationship between alm_asset and cmdb_model table

[Atik]

Hello,

I wanted to know what the below tables store, the use of tables, and the relationship between these tables.

1.alm_asset

2.cmdb_model table

Thanks,

Atik

[Abbas_5]

Hello @Atik,

Please refer to the below link:
https://www.servicenow.com/community/itsm-forum/difference-between-cmdb-ci-and-alm-asset-table/m-p/7...

If it is helpful, please mark it as helpful and accept the correct solution.

Thanks & Regards,

Abbas Shaik

[AshishKM]

Hi @Atik, 

The alm_asset table stores all type of asset data ( hardware , software etc ). The model table(s) basically describe the "type of asset" with granuler level details like cost, model, company, manufacture ect. 

Example : In any org, Emplyee(s) has laptops but all laptops are not same type ( model or configuration). So Org IT team will manage all model level infomration in model table and indiviudal laptop in asset table. 

So wheneven some model is going to out of support by manufacture, IT team can eaisy list all assets ( laptop ) for replacement ( or upgrade ). 

-Thanks,
AshishKM

[Abhijeet_Pawar]

• Hello @Atik ,
•   alm_asset:
• This table stores information about assets in your organization. Assets can include hardware devices like computers, servers, printers, networking equipment, and so on, as well as software assets.
• The alm_asset table typically contains attributes such as asset tag, serial number, manufacturer, model, location, status, assigned user, etc.
• It helps organizations track their physical and digital assets, manage their lifecycle, and facilitate asset-related processes like procurement, maintenance, and retirement.
• The table might have relationships with other tables like cmdb_ci (Configuration Item) for CI relationships, sys_user for assigned users, and possibly other tables depending on your organization's configurations and requirements.
• cmdb_model:
  • This table stores information about configuration item models. In the context of ServiceNow, a configuration item (CI) refers to any component or service managed in the CMDB.
  • cmdb_model table typically contains details about the models of various CIs in your environment. These could be hardware models (e.g., server models, laptop models) or software models (e.g., application versions, operating system versions).
  • Attributes stored in this table might include model name, manufacturer, description, specifications, etc.
  • It helps in standardizing and organizing the configuration items within the CMDB, facilitating better management, tracking, and reporting.
  • This table could have relationships with other tables like cmdb_ci to associate models with actual CIs, cmdb_manufacturer to link manufacturers, and other related tables depending on your CMDB setup.
• Relationship between these tables:
• Typically, in a CMDB setup, there would be a relationship between the alm_asset and cmdb_model tables.
• This relationship is often established through a reference field in the alm_asset table that points to the cmdb_model table. This reference field would typically hold the model of the asset recorded in the alm_asset table.
• By linking assets to their respective models, organizations can easily track which assets belong to which model types, enabling better management, maintenance, and reporting.

Additionally, the cmdb_model table might be linked to other tables within the CMDB for further categorization and management purposes.

Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution.