you may also reduce it to filespaces with :

select count(*) from backups where state='INACTIVE_VERSION' and
filespace_name='YOUR_FILESPACENAME'





John Bremer <jbremer AT LANL DOT GOV>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
16/01/2009 00:16
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
Re: [ADSM-L] Inactive Version






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.