We are having an issue with our Remedy application, where it appears that there is an update on our ‘CTM:People Permission Groups’ form where certain entries are ‘disappearing mysteriously’ apparently with no explanation as to what's causing them to disappear. I turned on API, SQL, Escalation and Filter logging, and nothing traps any activity of any deletes on that form. Which led me to suspect that this might be happening from ‘outside’ of the AR System API layer.. I was told by some of the developers that were on site here before me that they can swear there is nothing outside the application layer that performs any updates or deletes for that matter to our Remedy applications..
However since I cannot get anything through logging, I decided to lay a trap by creating a DB trigger, to capture the DB User and the DB time that these deletes are happening by creating an external audit table on the T table that the CTM:People Permission Groups records are stored.. The time field column I defined in Oracle as TIMESTAMP WITH TIME ZONE.. I need help to interpret the time displayed in this column.. It is displayed as: 27-MAR-12 12.05.05.118256 AM –04:00 How would I convert that to EST? Is it 27-MAR-12 01:05:05 AM EST ??? Is it 26-MAR-12 11:05:05 PM EST ??? Or is it 27-MAR-12 12:05:05 AM EST ??? Joe _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
