Re: Pull data from CMDB

2014-01-30 Thread Jim Coryat (jcoryat)
not have the trailing underscore. For Asset data the prefix is AST_ with the same class name as the CMDB class that underlies it. Jim Coryat x34655 From: shambo maitra [mailto:shamb...@gmail.com] Sent: Wednesday, January 29, 2014 9:08 AM Subject: Re: Pull data from CMDB ** Hi Rasmus, Login

Pull data from CMDB

2014-01-29 Thread Rasmus JORGENSEN
Hi all Does any of you know which tables in the SQL database contains information from the CMDB classes (Base.Element, ComputerSystem etc.) ? I have to know the sources for exporting the data to Qlikview. Best regards R Oplev Steria: www.steria.dk

Re: Pull data from CMDB

2014-01-29 Thread shambo maitra
Hi Rasmus, Login to database with aradmin. Use the class form as table name but replace all white spaces and special character with '_'. Eg-BMC.CORE:BaseElement is BMC_CORE_BASEELEMENT and same way use attributes as columns but use where clause as data_set_id=BMC.ASSET if your production dataset