The Configuration Management Database (CMDB) concept of ITIL seems to generate the most questions from readers and may stem from the relatively small amount of information on the Web regarding it. So let’s take a few moments to look at the seemingly arcane CMDB, and remove the needless cloak of mysticism around it. The CMDB […]
The Configuration Management Database (CMDB) concept of ITIL seems to
generate the most questions from readers and may stem from the relatively
small amount of information on the Web regarding it. So let’s take a few
moments to look at the seemingly arcane CMDB, and remove the needless
cloak of mysticism around it.
The CMDB is a relational database that serves as the nerve center of IT
service management. While the word ‘configuration’ makes people think it
is tracking build information, it is far greater than that. The CMDB
represents a logical model of IT. As such, it is tasked with tracking
configuration items (CI), attributes (metadata) about each and, very
importantly, their relationships to one another.
The CMDB can be all in one database or interfaced together (federated) to
preserve normalization of data, ease of collection, etc.
First off, everything is a configuration item. Hardware, software,
people, accommodations (ITIL’s term for facilities), data files,
documentation (including data records), and services are all top-level
CIs. What an organization uses, and how they use it, are based on their
needs.
For example, under hardware, maybe they need tables for each CI type to
track network devices, servers, storage devices, etc. Records, such as
those for changes, problems and incidents, also are CIs and need to be
defined based on business need. In general, you want to use a CI when
one-to-many and many-to-many relationships exist. However, risk or other
needs also may prompt you to define a class of CIs vs. simply using
attributes.
A good way to think of attributes is that they are the data fields that
make up the CI tables. As an example of CI vs. attribute, would you want
to have a field in the server CI record called ‘Operating System’ or
would you want a CI called ‘Operating System’ that then had attributes
defining each type of operating system in use? The correct answer depends
on your needs.
At the heart, we know we need to understand some basic elemental
attributes regardless of CI type such as:
documentation, etc.;
has it been retired? You want enough meaningful status values to
represent the lifecycle of the CI;
vendor ID or the internal department;
for calculating the book value;
associated with the CI. In other words, work with accounting to make sure
that the correct total purchase cost is entered. This may include
purchase price, shipping, professional services, etc.
this CI? ITIL is big on confidentiality, integrity and availability
(CIA), but you should use what makes the most sense;
groups may need to know the physical location as well as logical
locations;
attribute evolve into something unmanageable.)
For each CI type, you may add, change or delete attributes as needed, but
you want to keep the CI structure both meaningful and manageable. If the
CMDB becomes too complex to maintain, then its value plummets and people
will stop using the system out of frustration.
Database table relationships could be as follows:
a component?
component CIs make it up?
against it. This may be the same as the change record IDs but it’s listed
separately here. The reason is to show all RFCs — accepted and rejected;
allows for the Change Manager and other stakeholders to gauge historical
activity;
with?
Moving along, assembled or compound CIs are made up of n-levels of
hierarchically grouped components. A SQL Server is made up of hardware,
software and documentation. A service is made up of hardware, software,
documentation, and people. The idea is to understand how CIs are
assembled for cost, impact analysis, overall planning and so on. For
those people with a manufacturing systems background, think of an
assembled CI as being analogous to a bill of material (BOM).
One of the most important outputs of Configuration Management is the
documentation of relationship. It is critical that the CMDB be able to
relate all of the various CI types together. These relationships allow
for Change Management to do impact analysis.
If I allow this change to happen, what are the risks? Who and what are
involved? By having the relationships in the CMDB, the Change Manager can
begin to answer those questions.
The bottom line is that the CMDB is the hub system of all activity in the
world of IT Service Management. The exact tables and composition should
be driven by the needs of the business, then the services that support
those needs and finally the resources that comprise each service that IT
delivers. When people ask what a CMDB should look like, they must realize
that there is no one-size-fits-all answer. They must work to understand
what the business needs, what IT needs and then design a data model that
meets those requirements.
Note: For further reference, the ITIL Service Support volume lists
potential CI attributes in Annex 7C of Configuration Management.
Ethics and Artificial Intelligence: Driving Greater Equality
FEATURE | By James Maguire,
December 16, 2020
AI vs. Machine Learning vs. Deep Learning
FEATURE | By Cynthia Harvey,
December 11, 2020
Huawei’s AI Update: Things Are Moving Faster Than We Think
FEATURE | By Rob Enderle,
December 04, 2020
Keeping Machine Learning Algorithms Honest in the ‘Ethics-First’ Era
ARTIFICIAL INTELLIGENCE | By Guest Author,
November 18, 2020
Key Trends in Chatbots and RPA
FEATURE | By Guest Author,
November 10, 2020
FEATURE | By Samuel Greengard,
November 05, 2020
ARTIFICIAL INTELLIGENCE | By Guest Author,
November 02, 2020
How Intel’s Work With Autonomous Cars Could Redefine General Purpose AI
ARTIFICIAL INTELLIGENCE | By Rob Enderle,
October 29, 2020
Dell Technologies World: Weaving Together Human And Machine Interaction For AI And Robotics
ARTIFICIAL INTELLIGENCE | By Rob Enderle,
October 23, 2020
The Super Moderator, or How IBM Project Debater Could Save Social Media
FEATURE | By Rob Enderle,
October 16, 2020
FEATURE | By Cynthia Harvey,
October 07, 2020
ARTIFICIAL INTELLIGENCE | By Guest Author,
October 05, 2020
CIOs Discuss the Promise of AI and Data Science
FEATURE | By Guest Author,
September 25, 2020
Microsoft Is Building An AI Product That Could Predict The Future
FEATURE | By Rob Enderle,
September 25, 2020
Top 10 Machine Learning Companies 2021
FEATURE | By Cynthia Harvey,
September 22, 2020
NVIDIA and ARM: Massively Changing The AI Landscape
ARTIFICIAL INTELLIGENCE | By Rob Enderle,
September 18, 2020
Continuous Intelligence: Expert Discussion [Video and Podcast]
ARTIFICIAL INTELLIGENCE | By James Maguire,
September 14, 2020
Artificial Intelligence: Governance and Ethics [Video]
ARTIFICIAL INTELLIGENCE | By James Maguire,
September 13, 2020
IBM Watson At The US Open: Showcasing The Power Of A Mature Enterprise-Class AI
FEATURE | By Rob Enderle,
September 11, 2020
Artificial Intelligence: Perception vs. Reality
FEATURE | By James Maguire,
September 09, 2020
Datamation is the leading industry resource for B2B data professionals and technology buyers. Datamation's focus is on providing insight into the latest trends and innovation in AI, data security, big data, and more, along with in-depth product recommendations and comparisons. More than 1.7M users gain insight and guidance from Datamation every year.
Property of TechnologyAdvice. © 2025 TechnologyAdvice. All Rights Reserved
Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.
