Keep in mind that the Base Element view will only provide those attributes on that class. To get the additional attributes that are specific to a class you will need to query that view directly.
BMC_CORE_BMC_ is the prefix for all the class views in the database. Use the views that do 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:[email protected]] Sent: Wednesday, January 29, 2014 9:08 AM Subject: Re: Pull data from CMDB ** 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 is same else if you have created some other production /golden dataset use that one where clause. Rrgds Shambo. On Wednesday, January 29, 2014, Rasmus JORGENSEN <[email protected]<mailto:[email protected]>> wrote: ** 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<http://www.steria.dk> & www.steria.com<http://www.steria.com> Steria leverer IT-baserede forretningsydelser til offentlige og private virksomheder over hele verden. Vi arbejder typisk som en "Trusted Transformation Partner", der i tæt samarbejde med kunderne videreudvikler deres IT systemer på grundlag af vores forretningsforståelse og førende IT-ekspertise. Vi tager kundernes udfordringer op og bistår dem med innovative IT-løsninger, så de bliver i stand til at optimere deres forretning. Vores 20.000 medarbejdere arbejder på tværs af 16 lande for at støtte kundernes processer og systemer, der får hverdagen til at fungere for millioner af mennesker over hele kloden. This message is intended exclusively for the designated addressee. It may contain confidential material. If you are not the correct addressee, please notify the sender immediately and destroy the message. The content of this message will engage the responsibility of Steria only if it has been sent by an authorized person acting in the strict scope of his functions and for purposes that are related to his competence. Although reasonable efforts have been made to keep this transmission free from viruses, the sender will not be liable for damages caused by a transmitted virus. _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
