list virtual instances of a client installation

Last post 07-08-2020, 7:55 PM by Dannie4. 1 replies.
Sort Posts: Previous Next
  • list virtual instances of a client installation
    Posted: 02-26-2020, 7:49 AM


    How can the virtual clients on a client installation be listed?

    Goal is a workflow which returns the virtual clients associated witha a client, or 0 if no virtual client is accociated. A CSDB query would be helpful, a ForEachJason loop may be ineffective within a large environment.

    Thanks, Kay

  • Re: list virtual instances of a client installation
    Posted: 07-08-2020, 7:55 PM

    I think you're looking for the table APP_VMToPMMap.

    Something like

    SELECT name FROM APP_Client WHERE id IN (SELECT PMClientId FROM APP_VMToPMMap WHERE VMClientId = xpath:{workflow/inputs/clusterClient/clientId})

    should give you all of the cluster members for a given cluster client.

The content of the forums, threads and posts reflects the thoughts and opinions of each author, and does not represent the thoughts, opinions, plans or strategies of Commvault Systems, Inc. ("Commvault") and Commvault undertakes no obligation to update, correct or modify any statements made in this forum. Any and all third party links, statements, comments, or feedback posted to, or otherwise provided by this forum, thread or post are not affiliated with, nor endorsed by, Commvault.
Commvault, Commvault and logo, the “CV” logo, Commvault Systems, Solving Forward, SIM, Singular Information Management, Simpana, Commvault Galaxy, Unified Data Management, QiNetix, Quick Recovery, QR, CommNet, GridStor, Vault Tracker, InnerVault, QuickSnap, QSnap, Recovery Director, CommServe, CommCell, SnapProtect, ROMS, and CommValue, are trademarks or registered trademarks of Commvault Systems, Inc. All other third party brands, products, service names, trademarks, or registered service marks are the property of and used to identify the products or services of their respective owners. All specifications are subject to change without notice.
Copyright © 2020 Commvault | All Rights Reserved. | Legal | Privacy Policy