Page 1 of 1

Creating Application level in CMDB

Posted: Fri Jan 03, 2014 2:12 am
by lokeshwari
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 ?

Posted: Fri Jan 03, 2014 3:31 am
by UKVIKING
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

Posted: Fri Jan 03, 2014 3:56 am
by lokeshwari
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 )

Posted: Fri Jan 03, 2014 4:25 am
by UKVIKING
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

Posted: Fri Jan 03, 2014 4:44 am
by lokeshwari
Thanks a tonn...

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