Re: activity log select statement

Joni,

You can try the following query.

select date(date_time),time(date_time),nodename,sessid,session,process
from actlog where date(date_time)=date(current_timestamp - 3 days) and
msgno in (1064,988) order by process

Regards, Samiran Das


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Joni Moyer
Sent: Wednesday, April 27, 2005 8:58 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: activity log select statement


Hello All!

I was just wondering why I am not receiving any output?  I am issuing
the following select statement and I get nothing in return, but as you
can see in the activity log there is info within it for those numbers.
Any suggestions would be appreciated.  Thanks!

select date(date_time),time(date_time),nodename,sessid,session,process
from actlog where date_time=current_timestamp - 3 days and
msgno=1064.988 order by process

Date/Time             Message

--------------------
----------------------------------------------------------
04/25/05 19:04:01     ANR0984I Process 1686 for BACKUP NAS
(DIFFERENTIAL)
start
                       ed in the FOREGROUND at 19:04:01. (SESSION:
106935, PROC
                       ESS: 1686)

04/25/05 19:04:01     ANR1064I Differential backup of NAS node
NAS_SERVER_4, fi
                       le system /.etc_common, started as process 1686
by admin
                       istrator LIDZR8V. (SESSION: 106935, PROCESS:
1686)

04/25/05 19:04:01     ANR2753I (NAS_4-DIFFERENTIAL):ANR0984I Process
1686
for B
                       ACKUP NAS   (SESSION: 106935)

04/25/05 19:04:01     ANR2753I (NAS_4-DIFFERENTIAL):ommon, started as
process 1
                       686 by adm  (SESSION: 106935)

04/25/05 19:04:26     ANR0513I Process 1686 opened output volume N00021.
(SESSI
                       ON: 106935, PROCESS: 1686)

04/25/05 19:06:01     ANR1067I NAS Backup process 1686 completed.
(SESSION:
106
                       935, PROCESS: 1686)

04/25/05 19:06:01     ANR2753I (NAS_4-DIFFERENTIAL):ANR1067I NAS Backup
process
                        1686 comp  (SESSION: 106935)

04/25/05 19:06:01     ANR0988I Process 1686 for BACKUP NAS
(DIFFERENTIAL)
runni
                       ng in the FOREGROUND processed 65,536 bytes with
a compl
                       etion state of SUCCESS at 19:06:01. (SESSION:
106935, PR
                       OCESS: 1686)

04/25/05 19:06:01     ANR2753I (NAS_4-DIFFERENTIAL):ANR0988I Process
1686
for B
                       ACKUP NAS   (SESSION: 106935)

04/25/05 19:06:01     ANR0515I Process 1686 closed volume N00021.
(SESSION:
106
                       935, PROCESS: 1686)

04/27/05 08:36:29     ANR2017I Administrator LIDZR8V issued command:
QUERY
ACTL
                       OG begind=04/24/2005 begint=00:00 search="process
1686"
                        (SESSION: 127880)



********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************
--------------------------------------------------------

If you are not an intended recipient of this e-mail, please notify the sender, 
delete it and do not read, act upon, print, disclose, copy, retain or 
redistribute it. Click here for important additional terms relating to this 
e-mail.     http://www.ml.com/email_terms/
--------------------------------------------------------