Kevin, We have BMC Topology Discovery 1.3 and BMC Configuration Discovery 6 with CMDB 1.1 patch 3 and have integrated it with ITSP 4. We are just about to pilot it to see if it all works as expected.
We have created some joins to help identify what components are part of what computer system. For instance we have created a join between the BMC_Component form (prim) and BMC_Asset form. The 'InstanceID' on the asset form links with the 'GroupComponent.InstanceID' on the component form. The links between the tables are not all the same (ie. not always linked by 'InstanceID' and you may need to drill deeper into the underlying join forms to get what you need. We report on the ITSP 4 forms and not the CMDB forms. Are you integrating Topo with ITSM? We are starting to have a look at the following: (CMDB 2.0 looks much better than CMDB 1.1) ARS 7.x ITSM 7 Oracle10g CMDB 2.0 BMC Topo ver ??? BMC Config 7 Keith >>> [EMAIL PROTECTED] 9/11/2006 6:56 PM >>> Speculation on my part, but... (thinking out loud here) Every item in the cmdb has an entry in BMC_Asset. BMC_Asset contains the class type for that record. This should be the top level/group of your report. i.e., you could see all the class types at that level. You could then drill down into each of those class types and use a sub-report to gather more detailed information for that class (the class value would be the driver for which sub-report to use). Repeat the above on how you slice the data class->[sub-class->...] Problem with this model is that the remedy odbc driver is incapable of executing subreports, afaik; so you would need to connect to the db directly. You can use the views generated by remedy for each of the forms to create the top-level report and sub-reports. Axton Grams Kevin Shaffer wrote: > ARS 7.x > CMDB 1.1, patch 3 > Oracle 10g > > I'm a newbie to the CMDB world, so this may be a dumb question ... We have our CMDB populated with data from BMC Topology. I have been tasked to create a report that shows all servers, desktops, laptops and then drill down into each of them to find the details of the asset, i.e Patch, OS, Mem, HD Space, Processor, Software, etc ... My question is the attributes we want to see are in 15-20 different forms .. How are others getting this data into a nice report for managament? > > We have evaluated these options: > > 1. Create a view in the database and do the joins directly in Oracle > 2. Create joins of joins in the Remedy Admin tools > 3. Create subreports inside of Crystal. > > Any lessons learned out there on the best approach. Also I am struggling with what links these tables. i.e How are the records in BMC_Patch related back to BMC_Asset. Any advice. > > TIA > > Kevin > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
