CommServe DB query to list all the clients with version?

Last post 10 hours, 26 minutes ago by Venkat_Jupalli. 7 replies.
Sort Posts: Previous Next
  • CommServe DB query to list all the clients with version?
    Posted: 10-04-2019, 11:53 PM

    How do i fetch  (not from web console) using SQL query to get a list of all clients with version just like the list we get when we go to CommServe > Client Computers 

     

    TIA:)

  • Re: CommServe DB query to list all the clients with version?
    Posted: 10-07-2019, 1:34 AM
    Hi bumblebee,

    There is a report availble in the Commvault Store called CommCell Configuration which include the hostname, platform, version, service pack, hotfix level. Please see https://cloud.commvault.com/webconsole/softwarestore/#!/135/663/13285

    This report can be imported into your Metrics server.

    Please let me know if this will help you?
  • Re: CommServe DB query to list all the clients with version?
    Posted: 10-07-2019, 2:26 AM

    i want to get it through query, so i can put that in a workflow.

  • Re: CommServe DB query to list all the clients with version?
    Posted: 10-07-2019, 8:13 AM

    You can download the report, click on edit and see the query on the edit screen

  • Re: CommServe DB query to list all the clients with version?
    Posted: 10-07-2019, 6:37 PM
    Hi bumblebee,

    To expand on Amey's update

    You can download the Commcell Configuration report from https://cloud.commvault.com/webconsole/softwarestore/#!/135/663/13285
    Once downloaded you can import the report into WebConsole as per http://documentation.commvault.com/commvault/v11/article?p=103433.htm

    Inside WebConsole > select Reports >Select the report Commcell Configuration
    Select File > Edit
    On the left pane make sure Dataset is selected
    Click on Properties and click edit (the pencil icon)

    You can see the query used, please note you will need to change the username to an admin or master user in this line: SELECT @userId = id FROM UMUsers WHERE login = @sys_username
    Example: SELECT @userId = id FROM UMUsers WHERE login = 'admin'

    If you are unable to access the SQL Query from the Commcell Configuration report, please log a support ticket and we will provide this to you
  • Re: CommServe DB query to list all the clients with version?
    Posted: 10-08-2019, 1:48 AM

    SELECT * FROM [CommServ].[dbo].[CommCellClientVersion]

  • Re: CommServe DB query to list all the clients with version?
    Posted: 13 hours, 58 minutes ago

    Thanks Anthony. 

     

    Is there any documentation which i can refer to know about these queries.

  • Re: CommServe DB query to list all the clients with version?
    Posted: 10 hours, 26 minutes ago
    Hello bumblebee,
    To start with, you can check the CommCell Views : http://documentation.commvault.com/commvault/v11/article?p=39461.htm.
    also, we have around 200 editable reports on commvault store, which cover most of the reporting requirements. you can edit those reports and check the queries.
    Thanks
    Venkat
     
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 © 2019 Commvault | All Rights Reserved. | Legal | Privacy Policy