Re: search in q actlog
2002-05-22 21:28:18
The search option does not allow for this, but the select command does allow
you to do anything you want. If you make the select a script or macro you
can just about create your own 'q actlog' command with variables as input.
These are the fields you can search on:
DATE_TIME:
MSGNO:
SEVERITY:
MESSAGE:
ORIGINATOR:
NODENAME:
OWNERNAME:
SCHEDNAME:
DOMAINNAME:
SESSID:
SERVERNAME:
This is a sample select statement to do what you want.
select * from actlog where (lower(message) like '%error%' or lower(message)
like '%fail%') and date_time >current_timestamp - 2 hour
This one generates output more like the q act command:
select cast(date_time as char(16)), message as "Message
" from actlog where (lower(message) like '%error%' or lower(message) like
'%fail%') and date_time >current_timestamp - 2 hour
Paul D. Seay, Jr.
Technical Specialist
Naptheon, INC
757-688-8180
|
|
|