Neil, I do all of our Remedy reports in SSRS. If you use the views, you should be able to query off of HPD:Help Desk and set the group parameter on the report to the assigned support group field, then do a count for each group. The assignment log form will show you all assignments, both past and present. You'll want to look at the help desk form for the current ones, unless you want to add some data parameters to the report if you stick with the assignment log.
HTH, -Matt Matthew C. Gayford Application Developer & Remedy Administrator University of North Carolina Wilmington (910) 962-7177 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of npeterson Sent: Sunday, November 23, 2008 5:32 PM To: arslist@ARSLIST.ORG Subject: Re: SQL Reporing Services - making sense of Remedy Table structure Thanks both of you - this advice had gotten me almost to where I need to be. One wierd thing I've noticed is that in the HPD_HelpDeskAssignmentLogJoin table (the table I believe has what I need in it) , there are two rows for each submitted incident. The difference is on the Request_ID - one will be something like INC00005(HDA0000565) and the second will be something like INC00005(HDA0000249) This is causing all of my reports to some out double. I've tried to filter this down using fields like actual duration second and while it did get the numbers down thay were not acurate. Has any had to deal with something like this before or have any advice? Thanks neilp Drew Shuller wrote: > > npeterson, query the views instead. Or look for the Database Guide in the > documentation. > > Drew > ERCOT > >> 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" >> > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > -- View this message in context: http://www.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-structure-tp20626113p20651835.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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"