Sending System Log Information to a file

Previous topic - Next topic

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?