Hello Rudolf, It would be much simpler to use the corresponding views rather than the T tables. E.g AST_ComputerSystem view rather than table T762. Most relationships inherit from BMC_Component in CMDB 1.1, so you can find these in the view BMC_Component. There are also others like BMC_Dependency and BMC_Impact. In CMDB 2.0, I think it is all in BMC_BaseRelationship.
Regards, Murtuza. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rudi Sent: Tuesday, April 24, 2007 9:35 AM To: [email protected] Subject: Database Relations/Structure in MS SQL (Remedy Asset) I am looking for informations about the relations between tables. For example I need to know where are the tables for computer CI people CI Relationships to the CI and the fields who connect this tables. I found computers in T762, people in T751, but the informations in the relationship tab I cant find. Anyone can give me a hint, where the database structure is hidden ? Mit freundlichem Gruss / Kind regards Rudolf Boettcher ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
