One slight correction, Date/Time fields are Unix epoch of 1/1/1970. Date fields have a different epoch
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of RFrench Sent: Monday, November 24, 2008 1:08 PM To: arslist@ARSLIST.ORG Subject: Re: SQL Reporing Services - making sense of Remedy Table structure Welcome to the joy of reporting from Remedy :-> There is database documentation, IMHO its as good as some m/soft documentation l have found. If anyone understands it please let me know! Well done for using the tables, the OBDC link that is supplied is unless to say the least, in particular for advance reporting esp enterprise reporting. Some banana skins, to be aware of Date fields are epoch dates e.g. number of seconds after 01/01/1970 00:00:00 this can be solved using TSQL functions. On the forms you will see a pull down list, the values stored in the field, are a numeric value. However you can use a function, to look up the value. I have TSQL functions for the above done in SQL 2005 if you want. Some of the look up values between the tables are not obvious to the say the least, the HPD_Help_Desk form and the SLA form springs to mind. I do not have the details to hand at the moment as I'm at home. This is particular ITSM, where a number of the relationships as based on GUID number's. I'm sure its in the system somewhere however l have not found it yet. Nor does there seem to be any central point of information, be that website or document. When a form is created, a corresponding view with the same name is created. So you will find a view called HPD_Help_Desk, which corresponds to the form of the same name. >From what l can see of your reporting requirements, l agree with Matthew Gayford. My job is reporting, at the moment l report from 3 versions of Remedy. As l say to date whilst l have resolved a number of challenges, there are gaps in my knowledge which l would like to plug. We also looking to use SSRS as some point future to provide report for our customers. Regards Robert French -- View this message in context: http://www.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-s tructure-tp20626113p20668739.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"
