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 <rasmus.jorgen...@steria.dk> 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 & 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_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"