Hi Rudolf, Relational integrity is not enforced on the database level, but through workflow. That is the reason why you do not see any relationships in the database. Basically you shouldn't have to worry about the DB as it is "just" the storage that Remedy uses for it's data (it's not specified how the views are generated for example). How and if an application enforces referential integrity depends entirely on the application.
Hugo On 4/24/07, Rudi <[EMAIL PROTECTED]> wrote:
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: [email protected] > 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"
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
