Hi:
Need a little help as I'm not very good at the sql language as yet.
This is the query I'm using:
SELECT date,time,c-ip,s-port,cs-method,sc-status,cs-host,cs-uri-stem FROM
c:\iislogfiles\W3SVC1\extend1.log,
c:\iislogfiles\W3SVC30103697\extend1.log,
c:\iislogfiles\W3SVC54472458\extend1.log,
c:\iislogfiles\W3SVC54583666\extend1.log,
c:\iislogfiles\W3SVC620987851\extend1.log,
c:\iislogfiles\W3SVC978284352\extend1.log,
c:\iislogfiles\W3SVC987274646\extend1.log,
c:\iislogfiles\W3SVC1225455001\extend1.log,
c:\iislogfiles\W3SVC1173546801\extend1.log
order by date,time
What I would like to do is convert the GMT time into my time (EST) and also have the output order reversed so that the most recent entry is first and not last.
Also, I noticed that while using Log Lizard, if the first log file in the query does not exist, I get an error.
Thanks for looking at this.