Depends what you mean by Data Dictionary: ERD? No, and if they had one it would be VERY large. It's been requested over and over by almost every customer I've worked with. Reality is there isn't one and it would be so complex it would likely be out of date by the time you finished it.
Metadata? Kind of.... Forms and Workflow objects are stored in the DB and you can somewhat extrapolate metadata via the following: · Forms o Database view exists for every form. Replace the special characters with underscores to see it in the DB. IE. For the CTM:People form the view is called CTM_People. o For the actual data tables for this DB View which corresponds to the form, there are 3 data tables for every form. The "arschema" table has an entry for every form and a corresponding Schema ID. The data for that form is then stored in 3 underlying tables referenced by the schema id. § T(schema id) - stores the data § B(schema id) - stores the attachments § H(schema id) - stores the status history · Workflow o Workflow definitions are stored in metadata tables corresponding to the type. Example, Active Links are stored in a few DB tables starting with ActLink_ I would recommend a thorough read of the AR Database Reference guide which explains all the above and much much more. The database level schema for Remedy is quite complex and takes some education and getting used to in order to navigate effectively. Foundation Data in ITSM? This is quite distributed as far as the places it is stored but you can pretty much view all that data from that Application Administration console within the application. I would also recommend a read of the ITSM Concepts guide. Not sure BMC has updated since V7.0 but most of the information is still relevant even in 7.6.04. Look in the Documents section of the Support site under ITSM v7.0 Atrium CMDB? Yes! There Common Data Model is readily available in .pdf and poster format. Additionally you can generate a set of interactive .html documents describing entities, attributes, relationships, etc. via the Atrium Server or you can usually find a set someone already generated on the developers network. Hope this helps. There are numerous other resources beyond those I've mentioned but these are some of the key ones. If you can provide more specifics of what you're looking for we can probably point you in the right direction. Thanks. Nate. Nathan Aker ITSM Solution Architect McAfee, Inc. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of rahul bose Sent: Monday, January 09, 2012 8:10 AM To: [email protected] Subject: Remedy Data Dictionary ** Guys, Do we have a Data Dictionary for Remedy ? Regards, Rahul _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
