Re: NAS Report through the ACTLOG table

Joni,
Is this any use to you:

select entity as node_name, date(start_time) as date, cast(activity as -
varchar(10)) as activity, -
time(start_time) as start,time(end_time) as end, - 
cast(substr(cast(end_time-start_time as char(20)),3,8) as char(8)) as
"Length", -
cast(bytes/1024/1024 as decimal(6,0)) as -
megabytes,cast(affected as decimal(7,0)) as files, successful from
summary where -
start_time>=current_timestamp - 1 day and (entity like 'ABZ%' or entity
like 'NAS%') -
and (activity='BACKUP' or activity='NAS Backup') -
order by start, node_name

 


Regards,

Iain Barnetson
IT Systems Administrator
UKN Infrastructure Operations

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Joni Moyer
Sent: 10 May 2005 15:38
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] NAS Report through the ACTLOG table

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
********************************
----------------------------------------------------------------------
This e-mail, including any attached files, may contain confidential and 
privileged information for the sole use of the intended recipient.  Any review, 
use, distribution, or disclosure by others is strictly prohibited.  If you are 
not the intended recipient (or authorized to receive information for the 
intended recipient), please contact the sender by reply e-mail and delete all 
copies of this message.