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"
