relationship between alm_asset and cmdb_model tables

[liams]

Hello,

I'm interested in understanding the purpose and connection between the "alm_asset" and "cmdb_model" tables. Could you please provide information on what data these tables store, their respective uses, and how they are related to each other?

Thank you!

[AJ-TechTrek]

HI @liams ,

Please refer below.

• 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, organisations can easily track which assets belong to which model types, enabling better management, maintenance, and reporting.

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

Thanks

AJ

Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/

ServiceNow Community Rising Star 2024

[SK Chand Basha]

Hi @liams Synchronisation between asset and ci

If update one of these fields on the hardware asset record or on the connected

configuration item record, then the corresponding record will also be updated.

Mark helpfull ! If this helps you to understand.

[NNC7015581]

Thank you for the screenshot.