you may also reduce it to filespaces with : select count(*) from backups where state='INACTIVE_VERSION' and filespace_name='YOUR_FILESPACENAME'
John Bremer <[email protected]> Sent by: "ADSM: Dist Stor Manager" <[email protected]> 16/01/2009 00:16 Please respond to "ADSM: Dist Stor Manager" <[email protected]> To [email protected] 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.
