Being a computer, it's doing exactly what you told it to! I think you meant 'where date_time > current_timestamp - 3 days' (if you have '=' it will only find records from 3 days ago that match the current time down to the second)
Also, to find multiple message numbers, you can use 'msgno in (1064, 988)' -Ken Mueller -----Original Message----- From: Joni Moyer [mailto:[EMAIL PROTECTED] 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] ********************************
