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
