Hi Eric, Stefan's method will be quicker than mine, smaller table to parse.
- 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: Schulz Stefan <stefan.sch...@cancom.de> Sent: Thursday, July 11, 2019 11:17 AM To: ADSM-L@VM.MARIST.EDU Subject: [EXTERNAL] [ADSM-L] AW: Number of volumes per client Hi Eric, i'd suggest "select node_name,count(distinct volume_name) from volumeusage group by node_name". You could also further filter with "where stgpool_name..." or "where copy_type='BACKUP'/'ARCHIVE'" Best Regards, Stefan Schulz CANCOM GmbH CANCOM GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Ralf Binder, Stefan Fritz, Jens-Peter Gotter, Paul Holdschik, Dirk Kiefer, Petra Trost-Gürtner Diese E-Mail und alle mit gesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! This e-mail and any files transmitted with it are confidential and intended solely for the use of the addressee! -----Ursprüngliche Nachricht----- Von: ADSM: Dist Stor Manager <ADSM-L@VM.MARIST.EDU> Im Auftrag von Loon, Eric van (ITOP NS) - KLM Gesendet: Donnerstag, 11. Juli 2019 15:55 An: ADSM-L@VM.MARIST.EDU Betreff: [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=DwIFAw&c=jf_iaSHvJObTbx-siA1ZOg&r=hMBqtRSV0jXgOdXEmlNk_-O9LHkPCGSh9PJBRSlL8Q4&m=o_j_99v5y2_C1cPNbeG8vPoLNRKzQ-f0AK8t2hENg_k&s=K2tlxD5WfG5WUbMPu9ge0ijUoIw4DmZhLBIELbOBuxg&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 ********************************************************
