Re: [ADSM-L] backup starttime and endtime

1.      How far back you can go is determined by the "Activity Log
Retention" parameter. Issue a "q status" to see what you server is set
to.

2.      set sqldisplaymode wide
        select entity,start_time,end_time from summary where
entity='<NODE_NAME>' 
        

: : Greg Yuzik : :

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Avy Wong
Sent: Wednesday, August 01, 2007 12:12 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] backup starttime and endtime

Hello,
     Is there a way to get the   'Last Backup Start Date/Time' & 'Last
Backup Completion Date/Time'  for the past 30 days on a node? Thanks.


                                      Node Name: FORW1TDP
                                 Filespace Name: Forw1.DOMDBS
                     Hexadecimal Filespace Name:
                                           FSID: 1
                                       Platform: TDP Domino
                                 Filespace Type: API:DominoData
                          Is Filespace Unicode?: No
                                  Capacity (MB): 0.0
                                       Pct Util: 0.0
                    Last Backup Start Date/Time: 07/31/2007 22:03:33
                 Days Since Last Backup Started: 1
               Last Backup Completion Date/Time: 07/31/2007 00:20:22
               Days Since Last Backup Completed: 1
Last Full NAS Image Backup Completion Date/Time:
Days Since Last Full NAS Image Backup Completed:

                                      Node Name: FORW1TDP
                                 Filespace Name: \\forw1\f$
                     Hexadecimal Filespace Name:
5c5c6561726d61696c315c6624
                                           FSID: 2
                                       Platform: TDP Domino
                                 Filespace Type: NTFS
                          Is Filespace Unicode?: Yes
                                  Capacity (MB): 817,706.9
                                       Pct Util: 81.9
                    Last Backup Start Date/Time:
                 Days Since Last Backup Started:
               Last Backup Completion Date/Time:
               Days Since Last Backup Completed:
Last Full NAS Image Backup Completion Date/Time:
Days Since Last Full NAS Image Backup Completed:










Avy Wong
Business Continuity Administrator
Mohegan Sun
1 Mohegan Sun Blvd
Uncasville, CT 06382
ext 28164
************************************************************************
**************************
The information contained in this message may be privileged and
confidential and
protected from disclosure. If the reader of this message is not the
intended recipient, or
an employee or agent responsible for delivering this message to the
intended recipient,
you are hereby notified that any dissemination, distribution, or copy of
this
communication is strictly prohibited. If you have received this
communication in error,
please notify us immediately by replying to the message and deleting it
from your
computer.
************************************************************************
**************************