ADSM-L

Re: search in q actlog

2002-05-22 21:28:18
Subject: Re: search in q actlog
From: "Seay, Paul" <seay_pd AT NAPTHEON DOT COM>
Date: Wed, 22 May 2002 21:25:44 -0400
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


<Prev in Thread] Current Thread [Next in Thread>