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: http://ibm.biz/IBMSpectrumProtectServermon Performance Mustgather for Spectrum Protect: http://ibm.biz/IBMSpectrumProtectPerformanceMustgather Spectrum Protect Blueprint: http://ibm.biz/IBMSpectrumProtectBlueprints 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 ********************************************************