I haven't used SSRS much, but I do recall that it is more difficult to report off of applications like Remedy than .NET applications. The reason being that Remedy doesn't store foreign keys and such to relate to other tables in the DBMS, rather storing relationships like that in the application itself. As a result, it will be harder for you to pull in related tables to get all the data you need.
So the advice given to you by Drew is spot on -- use the Views, however, without knowing what you're looking for, you are going to have difficulty. For example, without being a "remedy guy" you probably won't know that Incidents are stored in HPD_HelpDesk. You probably want to engage a person who does have more knowledge of ITSM to help you find the right places to pull data. Shawn Pierson -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of npeterson Sent: Friday, November 21, 2008 11:35 AM To: arslist@ARSLIST.ORG Subject: SQL Reporing Services - making sense of Remedy Table structure I am hoping to user SQL Reporting services to create some Remedy reports, however I can not make one bit of sense of the tables in this Database. We are using Remedy IT Service Management 7.0 - DB is on SQL server 2005. A sample report would just be count all tickets currently assigned to a specific support group. I can not find any reference to support groups, open incidents, support personnel, etc. Is there some secret or guide on what data is stored where? For the record I am not a remedy guy, I just happen to admin the system and have been given some reporting requirement that can not be met with the integrated reporting tools. Thanks -- View this message in context: http://www.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-structure-tp20626113p20626113.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
