I see it's been about a day, and I'd hate for you to be disappointed, Kelly, so here goes.
select stgpool_name, sum(est_capacity_mb*pct_utilized/100) from volumes group by stgpool_name OK, so it's short by about 200 characters -- I'll just have to try harder next time. :o) disclaimer: I didn't take the time to test it, but it should work with minimal troubleshooting. ________________________________ Alex Paschal Storage Solutions Engineer MSI Systems Integrators ________________________________ Your Business. Better. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Kelly Lipp Sent: Monday, November 10, 2008 10:06 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] command to query how much data is stored Tsm> audit license Tsm> query auditocc pooltype=primary Will show all nodes capacity in the primary storage pools. I think query auditocc pooltype=primary node=nodename or perhaps q auditocc nodename pooltype=primary will do it as well. Now the big dogs will weigh in with the perfect 300 character SQL select statement with it summarized, etc, but this will get you started. Kelly Lipp CTO STORServer, Inc. 485-B Elkton Drive Colorado Springs, CO 80907 719-266-8777 www.storserver.com -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Cheung, Richard Sent: Monday, November 10, 2008 10:55 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] command to query how much data is stored What is the command to show how much data is currently stored in a storage pool - eg tapepool? Not for any specific individual nodes - just at a pure 'how much data is in a storage pool' level? <html> <body> <font face="arial" color=#808080 size="-2"><img alt="Santos Logo" src="http://www.santos.com/library/logo.gif"> <br>Santos Ltd A.B.N. 80 007 550 923<br> Disclaimer: The information contained in this email is intended only for the use of the person(s) to whom it is addressed and may be confidential or contain privileged information. If you are not the intended recipient you are hereby notified that any perusal, use, distribution, copying or disclosure is strictly prohibited. If you have received this email in error please immediately advise us by return email and delete the email without making a copy.</font> <font face="arial" color=#008000 size="-2">Please consider the environment before printing this email</font> </body> </html> This message (including any attachments) is intended only for the use of the individual or entity to which it is addressed and may contain information that is non-public, proprietary, privileged, confidential, and exempt from disclosure under applicable law or may constitute as attorney work product. If you are not the intended recipient, you are hereby notified that any use, dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, notify us immediately by telephone and (i) destroy this message if a facsimile or (ii) delete this message immediately if this is an electronic communication. Thank you.