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
