Sending System Log Information to a file

[JimWilson]

Does anyone know how to send data from the system log to a file?
In OnDemand Client, ' system log ' I tried looking up all message # 82 for 2007, it found 313,948 loads, then I selected all, then I tried to do a copy and received a message saying it could only copy up to 200,000 lines.
At a command prompt what would I key in to get the system log message # 82 from 01/01/2007 to 12/31/2007 to go to a file?
This is on a Windows Box, OnDemand version 8.3

[JimWilson]

Here is what I did

arsdoc query -h ServerName -H -f "System Log" -i "WHERE (msg_num = 82) and (time_stamp BETWEEN 1177218000 and 1199167199)" -o I:\DocGet\TEST.TXT -u AdminUser -p Password -v

[jo19021]

That works.  Now, how can I create a query against the system log to run every day, and use the current system date to query the past 24 hours of activity.  The -S does not seem to work and I am getting the last 3 months worth. 

[jo19021]

This is the query I have so far that is not working.

arsdoc query -h ARCHIVE -u admin -p ondemand -f "System Log" -o jaybosyslog.txt -i "WHERE (msg_num BETWEEN 34 and 64)? ?S ?12/13/10,12/13/10,%x?

[pankaj.puranik]

This may not be a solution but this is what you could do until you find a solution.

If you are on a unix system, you could simply write a shell script and use the arsdoc query and the unix 'date' function. Set this script as a batch to run every day.

Cheers
Pankaj.

[pankaj.puranik]

There's one more option.
Create a named query on the System Log folder and use the date range as 't-1' and 't'.
Use this named query in the arsdoc query with the named query option.
This should work.

Cheers
Pankaj.

[jo19021]

That worked great.  Does ondemand allow for delimiting the output of a query?