Re: [ADSM-L] First Backup day

2007-08-23 15:42:28
Subject: Re: [ADSM-L] First Backup day
From: "Colwell, William F." <bcolwell AT DRAPER DOT COM>
Date: Thu, 23 Aug 2007 15:40:16 -0400
Hi Shawn,

use this sql to find the oldest backup date -

select min(backup_date) from backups
 where node_name = 'NODE' and filespace_name = '\\node\c$'

It will return just one line of output. The filespace criteria is
I use it because we have nodes with old filespaces like '\\node-nt\c$'.

Bill Colwell
Draper lab

> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of Shawn Drew
> Sent: Thursday, August 23, 2007 11:48 AM
> Subject: First Backup day
> We have a request to provide the first day backups were run for a list
> of
> nodes.  The registration date isn't good, as there is a
> several day lag from registration to first backup.
> These dates are older than the age of the event and activity log.  Can
> anyone suggest a select statement for this?
> ________________________________________________
> Shawn Drew
> Data Protection Engineer
> Core IT Production
> Office:   212.471.6998
> Mobile: 917.774.8141
> This message and any attachments (the "message") is intended solely
> the addressees and is confidential. If you receive this message in
> error, please delete it and immediately notify the sender. Any use not
> in accord with its purpose, any dissemination or disclosure, either
> whole or partial, is prohibited except formal approval. The Internet
> can not guarantee the integrity of this message. BNP PARIBAS (and its
> subsidiaries) shall (will) not therefore be liable for the message if
> modified. Please note that certain functions and services for BNP
> Paribas may be performed by BNP Paribas RCC, Inc.
>          --------------------------------
> Ce message et toutes les pieces jointes (ci-apres le "message") sont
> etablis a l'intention exclusive de ses destinataires et sont
> confidentiels. Si vous recevez ce message par erreur, merci de le
> detruire et d'en avertir immediatement l'expediteur. Toute utilisation
> de ce message non conforme a sa destination, toute diffusion ou toute
> publication, totale ou partielle, est interdite, sauf autorisation
> expresse. L'internet ne permettant pas d'assurer l'integrite de ce
> message, BNP PARIBAS (et ses filiales) decline(nt) toute
> au titre de ce message, dans l'hypothese ou il aurait ete modifie.
> Veuillez noter que certaines fonctions et certains services pour BNP
> PARIBAS peuvent etre fournis par BNP Paribas RCC, Inc.

<Prev in Thread] Current Thread [Next in Thread>