Joe...just a shot in the dark here...did you check web services? Maybe some web service against an external employee dbase? Again...just a thought. Hope this helps...
On 3/29/12, Joe Martin D'Souza <[email protected]> wrote: > 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" -- Sent from my mobile device _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
