It will take quite a while to run, but here is what I put together...probably not a very efficient query, and I haven't tested it with using all stgpools, but you could always do a single query for each stgpool....Oh yeah, and it is based off of EST_CAP, and PCT_UTIL, so it is no real representation by a long shot.
select stgpools.stgpool_name, sum(cast((volumes.EST_CAPACITY_MB) * (volumes.PCT_UTILIZED) / (100) as INT)) / 1024 as "Used_GB", sum(cast((volumes.EST_CAPACITY_MB) * (volumes.PCT_UTILIZED) / (100) * (volumes.PCT_RECLAIM) / (100) as INT)) / 1024 as "RECLAIMABLE_GB" from volumes,stgpools where volumes.stgpool_name = stgpools.stgpool_name group by stgpools.stgpool_name -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bell, Charles (Chip) Sent: Wednesday, June 06, 2007 3:22 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] SQL select for primary stgpool data amount Does anyone have a handy SQL select statement or query that will give you a one-line picture of how much total data you have sitting on all primary storage pools in that moment of time? Thanks in advance! I kinda need this in a hurry... God bless you!!! Chip Bell Network Engineer I IBM Tivoli Certified Deployment Professional Baptist Health System Birmingham, AL ----------------------------------------- Confidentiality Notice: The information contained in this email message is privileged and confidential information and intended only for the use of the individual or entity named in the address. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this information is strictly prohibited. If you received this information in error, please notify the sender and delete this information from your computer and retain no copies of any of this information.
