Re: Reading SE Audit Trails
Brett Schubert wrote: > > I did a little more investigation into this "Integer internal time value". I > assumed the integer was a the number of seconds since "some date". > I wrote a little convertion table in excel and it appears the integer is > "The number of seconds since January 1st 1970 12:00 AM". > This corresponds closely with my audit table dates. The highest integer in > the table is 930273124 which converts to 25/06/1999 01:12 AM using this > method. This is the date the audit trail was stopped. The lowest integer > corresponds with the date I began the trail, way back in January. See what happens when you assume?!?! I guess the SE audit times are not like the IDS timestamps. Actually it is probably seconds since 1969-12-31 23:59:59 which is the UNIX zero time, type time_t, so these are translatable using the standard UNIX time_t functions like localtime()/asctime() and ctime(). Art S. Kagel > Brett Schubert <brett.schubert@timewise.com.au> wrote in message > news:930695153.626962@diddley.primus.com.au... > > You'd think that a "time" value would specify time in some way. If it is > an > > some sort of serial (or sequential integer), then why isn't it called > that? > > > > Art S. Kagel <kagel@bloomberg.net> wrote in message > > news:37792A45.331B157F@bloomberg.net... > > > Brett Schubert wrote: > > > > > > > > According to the Informix FAQ part 6.17 (Reading SE Audit Trails), an > > audit > > > > file includes five header fields. One of which is described in the FAQ > > as: > > > > > > > > a_time integer Integer internal time value. > > > > > > > > My question is? What is this internal time value based on and how do I > > > > convert this value to a meaniful date/time value. > > > > > > If the SE internal time is anything like IDS internal time it is just > > > an integer with no relation to real time at all. It is a number that > > > is incremented for each operation so that is is different for every > > > transaction and operation. > > > > > > Art S. Kagel > > > > > > Name: Audit Trail Date Converter.xls > Audit Trail Date Converter.xls Type: Excel File (application/vnd.ms-excel) > Encoding: x-uuencode