Re: [ADSM-L] command to query how much data is stored

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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Kelly Lipp
Sent: Monday, November 10, 2008 10:06 PM
To: ADSM-L AT VM.MARIST DOT 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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Cheung, Richard
Sent: Monday, November 10, 2008 10:55 PM
To: ADSM-L AT VM.MARIST DOT 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.