Creating Application level in CMDB

Discussion forum dedicated to configuration management and ITIL
Post Reply
User avatar
lokeshwari
Itiler
Itiler
Posts: 7
Joined: Mon Nov 18, 2013 7:00 pm

Fri Jan 03, 2014 2:12 am

Hi,

I am quiet new to this Forum and even Configuration Managment work.

I need to create Application level in CMDB and define attributes for application CI type ....

Can some one suggest me with any kind of source which i can i refer ?


User avatar
UKVIKING
ITIL Expert
ITIL Expert
Posts: 3639
Joined: Fri Sep 15, 2006 8:00 pm
Location: London, UK

Fri Jan 03, 2014 3:31 am

So

1) you are required to do something that you have no idea what to do
2) you have a limited idea of what Configuration Management is
3) you have a limited idea of what a CMDB is
4) you have a limited idea of database design

And you want the members to answer all of the above

And where should we (meaning me) send the invoice for

Training you in database design
Training you in ITIL process - Configuration Management
Training you in tool design
----------------------------------------------------------------------

That said,

A CMDB is a relational database that holds detailed info about a company's IT assets that are used to deliver services. The info about the IT Assets have to be detailed enough so that the different types of IT Assets can be linked together so that the relationship between the different devices can be tracked.

Each type of IT Asset has different requirements for information that is gather about the asset. An IT Asset in a CMDB is called a Configuration Item (CI) and all of the unique info about the IT Asset are called attributes

Information in general about CMDBs and Configuration Management can be found in the ITIL Books
Specifics about designing tools - databases, etc - can be found in database development books
John Hardesty
ITSM Manager's Certificate (Red Badge)

Change Management is POWER & CONTROL. /....evil laughter
User avatar
lokeshwari
Itiler
Itiler
Posts: 7
Joined: Mon Nov 18, 2013 7:00 pm

Fri Jan 03, 2014 3:56 am

Thank you so much for the clarity..

1) you are required to do something that you have no idea what to do -
( I have an idea with confusions and looking some guidance from experienced people )
2) you have a limited idea of what Configuration Management is
( Trying to Enhance the skilss )
3) you have a limited idea of what a CMDB is
( Going through the books to know more abour CMDB )
4) you have a limited idea of database design
( Will contact Technical Teams for Database Design )
User avatar
UKVIKING
ITIL Expert
ITIL Expert
Posts: 3639
Joined: Fri Sep 15, 2006 8:00 pm
Location: London, UK

Fri Jan 03, 2014 4:25 am

lokeshwari,

Good. Get more knowledge about ITIL / ConfigMgmt process

The ITIL books are the best source

Now for the specifics

A CI is nothing more than a record in a database

Each type of IT Asset may have fields in that record for that type
Some fields are the same for all assets
some are not.
Some IT assets are tangible = physical or virtual
Some IT assets are intangible - collection of something tangible
Examples of tangible assets are servers, routers,
Example of intangible asset are Service


For example:
Operating System could be a record field for server or network device
but not for Service

Key fields are database fields that hold unique ID for referencing the record in the table in the database. They are used to link tables together. More info in database books

So an Application CI would have both the specifics about the application as direct fields as well as reference fields to other CIs and well as being a reference for other CIs

For example

Server --> Application
Application --> licenses
Application --> version

The most basic CMDB (lite) is an Asset Register where the IT assets are in a list in an Excel spreadsheet.

one sheet for servers
one for routers
one for this
etc

Then to graduate to a CMDB, the spreadsheet data is linked in a database. MS access or SQL databases.

MS Access is good way to test develop a CMDB
John Hardesty
ITSM Manager's Certificate (Red Badge)

Change Management is POWER & CONTROL. /....evil laughter
User avatar
lokeshwari
Itiler
Itiler
Posts: 7
Joined: Mon Nov 18, 2013 7:00 pm

Fri Jan 03, 2014 4:44 am

Thanks a tonn...

Will surely get more knowledge about CM and will work on my project.
Post Reply