We don’t have sentinel yet so I have some reports and monitors written in Oracle pl/sql that select infomation from the G.I. tables. In those reports/monitors I use the (gmt - x hours) value which changes between gmt-5 and gmt-6 depending on if it is daylight savings time or not. Any ideas if G.I. stores the ‘Server’s time zone’ either in the database or in some config file that I could make use of to populate my variable that holds the (gmt - x hours) value in my select statements? This would save me the time of creating a one-off solution to automate the DST change twice a year rather than having someone change the (gmt - 5 to gmt - 6). Thanks for any suggestions! Jay Williamson

continue reading.....