Q actlog question

spiffy

ADSM.ORG Member
Joined
Feb 9, 2007
Messages
374
Reaction score
1
Points
0
PREDATAR Control23

Is there a way i can specify the actlog to NOT return ANE4987E errors when i do a q actlog begindate=xx begintime=xx search=error.
i dont think this is possible, but it is worth a try to see if anyone here knows of a way this can be done.
I want all other ANEXXXXE error messages to appear though...

thanks
 
PREDATAR Control23

Mate' is right ...
Here is what I would recommend:

select date(date_time) as "Date", -
time(date_time) as "Time", message as "Error Message" -
from actlog where -
msgno not in (4987)-
and date_time >= (current_timestamp - 24 hours)

Of course you would get the usual...
"This SQL query may produce a very large result table, or may require a
significant amount of time to compute..." biz...

But does that help you?
-Chef.
 
PREDATAR Control23

add a clause "severity=E" in WHERE statement.

(sorry for the up, just see the date :eek:), but it helps me)
 
PREDATAR Control23

hi

your post look similar to my query

how can i check only error messages with q actlog command.
 
Top