The user relationship is held on AST:AssetPeople form. I have not seen a document with the details you are looking for that contains the relationship forms. -----Original Message----- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tue, 24 Apr 2007 8:18 AM Subject: Re: Database Relations/Structure in MS SQL (Remedy Asset)
Ok, views are the better way, no question. I found some views for my use, but not the one with the relations. >From the other (answer) post (thx Murtuza) I found now CMDB_Relationship_BaseRelation witch looks very interesting, but I dont have the corresponding field descriptions. Unfortunately I have no administrative rights at Remedy, I am "only a skilled user". So I can not have a look at the admin tool. We are a small subsidiary in a concern. We are not involved in customizing. We have to put in data and now we want the data out ;-) . I know, the are a own report generator in Remedy, but not enough for me. CR and the ODBC connection for Remedy is not flexible enough for me. Before I go to ask my big boss for more rights...where can I find this "documents that describe the relations between the entities" you talk about? I use Remedy since a few days and it looks like a interesting, OS independend and very complex system, worth to spend some days more to make some good lists for "normal users". Mit freundlichem Gruss / Kind regards Rudolf Boettcher > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Michiel Beijen > Sent: Dienstag, 24. April 2007 09:45 > To: arslist@ARSLIST.ORG > Subject: Re: Database Relations/Structure in MS SQL (Remedy Asset) > > Rudolf, > > I'm afraid the relations between the tables in Remedy is not > hidden in the database. > Also, the T-table numbers differ between environments, please > do not rely on them but use the view names. Every T table has > a corresponding view in the database. > Depending of the ITSM version you are using there can be > documents that describe the relations between the entities in > your system and where they are stored. Another method is to > look into the admin tool, open up the asset form and check > the properties on the table fields. > You will see the names of the forms where those relations are > stored and also the qualification of the relation. > -- > Met vriendelijke groet / Kind regards > Michiel Beijen > ______________________________________________________ > MANSOLUTIONS > Energieweg 60-62 > 3771 NA Barneveld > The Netherlands > Tel. +31-(0)612968592 > Mail [EMAIL PROTECTED] > Internet http://bsm.mansolutions.nl > > On 4/24/07, Rudi <[EMAIL PROTECTED]> wrote: > > 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" > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ AOL now offers free email to everyone. Find out more about what's free from AOL at AOL.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"