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:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: Wednesday, April 27, 2005 8:58 AM To: [email protected] 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 [EMAIL PROTECTED] ******************************** -------------------------------------------------------- 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/ --------------------------------------------------------
