Query to find the proxy server assigned to a Amazon virtualization client

Last post 12-12-2019, 11:47 AM by bstibal. 1 replies.
Sort Posts: Previous Next
  • Query to find the proxy server assigned to a Amazon virtualization client
    Posted: 12-11-2019, 8:24 AM

    Is it possible to list the proxy server associated with a virtualization client created for taking Intellisnap backup for Amazon..

    App_GetInstancePropertiesResponse.instanceProperties.virtualServerInstance.associatedClients.memberServers.client.clientName

     

    How can i retrieve it through SQL query to CommServe DB

  • Re: Query to find the proxy server assigned to a Amazon virtualization client
    Posted: 12-12-2019, 11:47 AM

    Here are the queries I used to get IntelliSnap Proxy information:

     

    DECLARE @temp1 TABLE
    (
    ClientName varchar(50),
    SubClient varchar(50),
    ProxyServer varchar(50)
    )

    INSERT INTO @temp1
    select Distinct a.clientname, a.subclient, c.DisplayName
    from dbo.CommCellSubClientConfig a
    join dbo.APP_SubClientProp b (nolock)
    on a.appid = b.componentNameId
    join dbo.CNClientInfoView c (nolock)
    on b.attrVal = c.ID
    where (b.attrName = 'Snap copy : proxy to use' or b.attrName = 'Enable Snap Backups') and subclient Like 'RDM_%' and b.modified = 0 and a.data_sp_copy_retendays = 45
    order by c.DisplayName

    DECLARE @temp2 TABLE
    (
    ClientName varchar(50),
    SnapEngineName varchar(50)
    )

    INSERT INTO @temp2
    select Distinct a.clientname, d.SnapEngineName
    from dbo.CommCellSubClientConfig a
    join dbo.APP_SubClientProp b (nolock)
    on a.appid = b.componentNameId
    join dbo.SMSnapShotEngine d (nolock)
    on b.attrVal = d.SnapShotEngineId
    where b.attrName = 'Snap Engine' and a.subclient Like 'RDM%' and b.modified = 0 and a.data_sp_copy_retendays = 0 and a.subclientstatus not like '%Uninstalled%'
    order by a.clientname

    SELECT a.ClientName, a.SubClient, a.ProxyServer, b.SnapEngineName
    FROM @temp1 a
    JOIN @temp2 b on a.ClientName = b.ClientName
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.
Close
Copyright © 2020 Commvault | All Rights Reserved. | Legal | Privacy Policy