VSA Subclient Content Table/View

Last post 05-08-2017, 9:13 AM by Jedi_knight_82. 4 replies.
Sort Posts: Previous Next
  • VSA Subclient Content Table/View
    Posted: 03-27-2017, 1:59 PM

    Good Afternoon,

    Does anyone know the table/view that retains the infromation about the servers that are assocatied to VSA subclients?  At the moment, the only way that I know how to pull this information is using the query below.  What I don't like about this method is that it relying on the backup to get the list of VMs that are being protected under the subclient.

    My end goal is to be able to automate the provisioning of customers that subscribe to this type of backup.


    Attachment: subclientContent.png
  • Re: VSA Subclient Content Table/View
    Posted: 03-28-2017, 9:29 PM


    Are you only looking for DB query to get the protected VMs list from subclients ? or a report would do? e.g. Vm Backup Report. 


  • Re: VSA Subclient Content Table/View
    Posted: 03-29-2017, 8:41 AM

    I'm looking for a DB query that will get me this information.

  • Re: VSA Subclient Content Table/View
    Posted: 03-31-2017, 3:00 PM

    Or is there a way to pull this information via the API?

  • Re: VSA Subclient Content Table/View
    Posted: 05-08-2017, 9:13 AM

    Good Morning,


    I was able to find the table (APP_SubClientProp) that dynamically stores the information pretaining to the VSA subclient.  My problem now is how do you parse the output from the SQL query below. 

    SQL Query:

    declare @MyVM asvarchar (50)

    set @MyVM ='WILLI001-VM011'

    selectdistinct a.clientid, a.clientname,c.name, b.subclientName,d.attrVal

    from CommServ.dbo.CommCellSubClientConfig as a, CommServ.dbo.APP_Application as b, CommServ.dbo.APP_BackupSetName as c, CommServ.dbo.APP_SubClientProp as d

    where a.clientname ='VSA_LAB2VCS01'

    and a.clientid = b.clientId

    and b.subclientStatus != 4

    and b.subclientStatus != 32

    and b.backupSet = c.id

    and c.name ='WILLI001'

    and b.id = d.componentNameId

    and d.attrName ='Virtual Server Dyanimc Content'

    and d.attrVal like'%'+ @MyVM +'%'

    SQL Output:

    <?xml version="1.0" encoding="UTF-8" standalone="no" ?><VirtualServer_VMSubClientEntity><children allOrAnyChildren="0" displayName="" equalsOrNotEquals="1" name="" path=""/><children allOrAnyChildren="0" displayName="WILLI001-VM011" equalsOrNotEquals="1" name="" path="" type="10"/></VirtualServer_VMSubClientEntity>


    XML Edititor:

     <children displayName="" allOrAnyChildren="0" equalsOrNotEquals="1" name="" path=""/>
     <children displayName="WILLI001-VM011" allOrAnyChildren="0" equalsOrNotEquals="1" name="" path="" type="10"/>
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 © 2019 Commvault | All Rights Reserved. | Legal | Privacy Policy