q occ
or if you HAVE TO have a select,
select node_name, stgpool_name, sum(num_files) from occupancy group by
node_name, stgpool_name
>>> "Lepre, James" <jlepre AT SOLIXINC DOT COM> 1/15/2009 5:33 PM >>>
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.
|