Posted: Fri Oct 05, 2012 3:57 am Post subject: use of CMDB
I am looking for a network management database.
1. need to store all the information in a database.
2. need to search the data and complex query will be required to execute.
Joining of tables are also expected.
(data will be of various level.As for telecom network, it will be Node, Shelf, Slot, card, Port etc and data volume will be good enough.)
Will it be a good option to use any CMDB(eg UCMDB) for this requirement?
Joined: Mar 04, 2008 Posts: 1883 Location: Newcastle-under-Lyme
Posted: Fri Oct 05, 2012 9:10 pm Post subject: Re: use of CMDB
Does this mean you do not wish responses from other than "Guys"? _________________ "Method goes far to prevent trouble in business: for it makes the task easy, hinders confusion, saves abundance of time, and instructs those that have business depending, both what to do and what to hope."
William Penn 1644-1718
Joined: Sep 16, 2006 Posts: 3110 Location: London, UK
Posted: Sat Oct 06, 2012 9:56 pm Post subject:
A couple of points.
This site is the ITIL Community Forum. This site is dedicated to ITIL discussions
There is a vast difference from Advice (free) and consluting (cost).
Now to reply to your posts
You need to talk to NMS tools Vendors or google for them and do research. There are some non expensive ones and some expensive ones.
This site is unable to answer NMS tool product information as the members may not have been exposed to more than a few tools whereas you need to look at a lot of tools.
Asset / Inventory Management
As I stated earlier, Excel and MS Access are good stating points.
A CMDB is a lot more than an asset register. The CMDB track and manages the relationship between CI (configuration items) and the lifecycle of such. This requires a level of complexity. In addition, a CMDB is absolutely worthless without the Configuration Management process that ensures that the data is maintained.
ITIL is all about IT Service Management and how to do it well, effective and efficient (best practice). Configuration management is part of that.
Any database, tool, etc can be integrated to any other - for a price. Usually it requires a specialist - application or database - who makes some sort of tool
Basically... you need to seek else where, these are not the droids you are looking for _________________ John Hardesty
ITSM Manager's Certificate (Red Badge)
Change Management is POWER & CONTROL. /....evil laughter
Thanks for your advice or as u said FREE CONSULTATION.
Google is accessible to everyone and if that can solve everything then there's no point of looking for a discussion forum.
but thanks a lot anyway.
I am looking for some help like the posts in the following link.
If someone has to maintain a Network inventory database which will be integrated later,with some other external system to fetch the data,
what kind of database would be the best option?
[data volume will be good enough and we need to maintain CI relationship also.]
[we have used Cramer before and now we are using UCMDB for Inventory management.
but in UCMDB, we are facing some problem like, we need to request many times to get the proper output from database side.As, I came to know that UCMDB cant fire a complex query.
which will be impractical as it is a time consuming process.
in previous case, like in Cramer it was able to fire some complex query and provides the output in a single response.]
So, in future I need to avoid such ambiguity.
Any help on this matter???
We tried many alternatives like you suggested but were unable to make any progress.
We can make the connectivity and solve the purpose using step by step CI relationship, but that will take a longer time to get the expected response.
CI relaitonship in UCMDB serves the purpose of storing and managing data but in an integration scenario, cant find any feasible option to fetch the data where complex query is supposed to be used.
now, imagine there are many relationship hierarchy like A->B->C->D->E.
We need data from E as well as the one related to it and lies in A.
now, the suggested approach is to use the CI relationship ID which we get in response with data in E to fetch the related data in D and so on to fetch data from A.
Now this will obviously impact badly on the system performance(the one integrated with UCMDB).
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum