Hello Everyone,

If the previous message concerning a select statement cannot be run, then I
found the message numbers within the activity log that contain the
information that I need: 1064 & 988.  I ran the following:

select date(date_time) as "Date",time(date_time) as "Time",message,process
from actlog where date_time>(current_timestamp - 1 day) and msgno in
(1064,988) order by process

and received this:

2005-05-09     19:00:29     ANR1064I Differen             5684
                             tial backup of N
                             AS node NAS_SERV
                             ER_3, file system
                             /.etc_common, st
                             arted as process
                              5684 by adminis
                             trator LID3QE9.
                             (SESSION: 294768,
                             PROCESS: 5684)
2005-05-09     19:05:47     ANR0988I Process              5684
                             5684 for BACKUP
                             NAS (DIFFERENTIA
                             L) running in the
                             FOREGROUND proce
                             ssed 65,536 bytes
                             with a completion
                             state of SUCCESS
                              at 19:05:47. (S
                             ESSION: 294768,
                             PROCESS: 5684)

Is there a way to pull information out of the following output to just look
like a table with the following information:

Date
Begin Time
End Time
NAS_Server_#
Filesystem
Process#
Differential/Full
MB Backed up
Completion State

Thank you in advance!  I am really trying to get an exact way to receive a
detailed NDMP backup report and just can't seem to get what I want.

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