No worries, I got it from someone else on the mail list. I'd like to be able to add the FS name to the query as well but haven't managed to figure it out yet either.
Regards, Iain Barnetson IT Systems Administrator UKN Infrastructure Operations -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: 10 May 2005 16:09 To: [email protected] Subject: Re: [ADSM-L] NAS Report through the ACTLOG table Hi Iain, Yes, it's very beneficial. Thanks! Here is my output. I am just trying to get the name of the filesystem that is being backed up for this process to be reported within this script as well and I can't seem to figure out how to join this select statement with the actlog to associate it and find the filesystem info. I'm pretty positive that it can be done, but I haven't been successful so far. Thank you for your help! NODE_NAME: NAS_SERVER_2_OFFSITE DATE: 2005-05-10 ACTIVITY: NAS Backup START: 00:15:14 END: 00:16:26 length: 00:01:12 MB: 46 FILES: 0 SUCCESSFUL: YES ******************************** Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] ******************************** "Iain Barnetson" <[EMAIL PROTECTED] ALLIBURTON.COM> To Sent by: "ADSM: [email protected] Dist Stor cc Manager" <[EMAIL PROTECTED] Subject .EDU> Re: NAS Report through the ACTLOG table 05/10/2005 10:52 AM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED] .EDU> 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:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: 10 May 2005 15:38 To: [email protected] 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 [EMAIL PROTECTED] ******************************** ---------------------------------------------------------------------- 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. ---------------------------------------------------------------------- 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.
