Hi Eric, These should give you what you are looking for
echo "************************************************************************" echo "* Node Activities - How many volumes each client has data data11*" select count(DISTINCT volume_name) as Num_volumes, node_name, stgpool_name from volumeusage group by node_name, stgpool_name order by volumes desc echo "****************************************************************************************************************" echo "************************************************************************" echo "* Node Activities - List each volume and how many nodes are on tape*" select volume_name, stgpool_name, count(distinct node_name) as Nodes from volumeusage group by volume_name, stgpool_name order by 3 desc echo "****************************************************************************************************************" echo "************************************************************************" echo "* Node Activities - For each node list avg MB per tape change %TAPE% to match your specific tape pool*" select vu.node_name, ao.total_mb, count(distinct vu.volume_name) as tapes, ao.total_mb/count(distinct vu.volume_name) as "AVG MB/tape" from volumeusage vu, auditocc ao where vu.stgpool_name like '%TAPE%' and vu.node_name=ao.node_name group by vu.node_name, ao.total_mb order by 4 echo "****************************************************************************************************************" Ronald C. Delaware Senior Consultant IBM Corporation | System Lab Services 925-822-3977 (Office) 925-457-9221 (cell phone) mailto:ron.delaw...@us.ibm.com From: Marc Lanteigne <marclantei...@ca.ibm.com> To: ADSM-L@VM.MARIST.EDU Date: 07/11/2019 07:15 AM Subject: [EXTERNAL] Re: [ADSM-L] Number of volumes per client Sent by: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> Hi Eric, You could do something like this: select node_name,count(distinct(volume_name)) from contents group by node_name - Thanks, Marc... ___________________________________________________ Marc Lanteigne Spectrum Protect Specialist AVP / SRT 416.478.0233 | marclantei...@ca.ibm.com Summer Hours: Monday to Thursday, 6:00 to 16:30 Eastern Latest Servermon for Spectrum Protect: https://urldefense.proofpoint.com/v2/url?u=http-3A__ibm.biz_IBMSpectrumProtectServermon&d=DwIFAg&c=jf_iaSHvJObTbx-siA1ZOg&r=hLJKqiq5uZKR2bRDOYSNbd0R_g8juynSkOjr_umT9g4&m=vEW1Kb5UUNJPB6-7WBTG96C-LFZSJeY_p5sCXJARzBE&s=sFMbbETX5Vd-NzoKeMgvqidCuJ4lqzzWfrbvhCmp57E&e= Performance Mustgather for Spectrum Protect: https://urldefense.proofpoint.com/v2/url?u=http-3A__ibm.biz_IBMSpectrumProtectPerformanceMustgather&d=DwIFAg&c=jf_iaSHvJObTbx-siA1ZOg&r=hLJKqiq5uZKR2bRDOYSNbd0R_g8juynSkOjr_umT9g4&m=vEW1Kb5UUNJPB6-7WBTG96C-LFZSJeY_p5sCXJARzBE&s=1i1fKfzAmWtRtt_3kdvSRz48l_g0KoSdNZV97yLWULY&e= Spectrum Protect Blueprint: https://urldefense.proofpoint.com/v2/url?u=http-3A__ibm.biz_IBMSpectrumProtectBlueprints&d=DwIFAg&c=jf_iaSHvJObTbx-siA1ZOg&r=hLJKqiq5uZKR2bRDOYSNbd0R_g8juynSkOjr_umT9g4&m=vEW1Kb5UUNJPB6-7WBTG96C-LFZSJeY_p5sCXJARzBE&s=U_G1kdJgxQvMe1i8Y98Tj8lNOFw_D-Ua0VSfBT5vPsQ&e= Follow me on: Twitter, developerWorks, LinkedIn -----Original Message----- From: Loon, Eric van (ITOP NS) - KLM <eric-van.l...@klm.com> Sent: Thursday, July 11, 2019 10:58 AM To: ADSM-L@VM.MARIST.EDU Subject: [EXTERNAL] [ADSM-L] Number of volumes per client Hi guys, I'm looking for a SQL statement to count the amount of volumes used per client. Can anybody help me out here? Thank you very much in advance! Kind regards, Eric van Loon Air France/KLM Storage & Backup ******************************************************** For information, services and offers, please visit our web site: https://urldefense.proofpoint.com/v2/url?u=http-3A__www.klm.com&d=DwIFAg&c=jf_iaSHvJObTbx-siA1ZOg&r=hMBqtRSV0jXgOdXEmlNk_-O9LHkPCGSh9PJBRSlL8Q4&m=nfOo48SnthJS2-_HlS7z2-jiv1rUtIJ711DzUTOx0LY&s=nT8p19UU2HYBIURwdYRBqCDMI_GY8rLissfAm5ZG45E&e= . This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 ********************************************************
