ADSM-L

Re: [ADSM-L] Inactive Version

2009-01-15 18:17:11
Subject: Re: [ADSM-L] Inactive Version
From: John Bremer <jbremer AT LANL DOT GOV>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 15 Jan 2009 16:15:36 -0700
select count(*) from backups where state='INACTIVE_VERSION' and
node_name='YOUR_NODENAME'

warning that trolling through the backups table can be very time
consuming and expensive.

John

At 03:33 PM 1/15/2009, you wrote:
Hello Everyone,



      Is there a select statement that will tell me how many active and
inactive versions of files are on the nodes that are backing up.



Thank you



James Lepre

Senior Server Specialist

Solix, Inc.

100 S. Jefferson Road

Whippany, NJ  07981

Phone: 973-581-5362

Cell:  973-223-1921








---------------------------------------------------------------
Confidentiality Notice: The information in this e-mail and any
attachments thereto is intended for the named recipient(s)
only.  This e-mail, including any attachments, may contain
information that is privileged and confidential  and subject to
legal restrictions and penalties regarding its unauthorized
disclosure or other use.  If you are not the intended recipient, you
are hereby notified that any disclosure, copying, distribution, or
the taking of any action or inaction in reliance on the contents of
this e-mail and any of its attachments is STRICTLY PROHIBITED.  If
you have received this e-mail in error, please immediately notify
the sender via return e-mail; delete this e-mail and all attachments
from your e-mail  system and your computer system and network; and
destroy any paper copies you may have in your possession. Thank you
for your cooperation.

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