Question

Commvault DB Query to list all the Virtual Machines (VSA) clients

  • 10 October 2023
  • 6 replies
  • 148 views

Badge +6

I want SQL query to fetch all the virtual machines in the environment which has Virtual Server agent in it, i..e VSA clients. Is there a documentation wherein i can get simPackageId for all different agents. 


6 replies

Userlevel 3
Badge +10

@Rahul Nair 

Please try with the API and let us know if this helps:

https://api.commvault.com/#734d6b5e-cebf-42b2-b673-7af1449082b5

Badge +6

Rest API and get-cvvirtualmachine is returning lot of information, I only need list of all the VM Names so that i can add it in a List.

Badge +6

Get-CVVitualMachine list above details of all the VMs. Is there way wherein i can only fetch “name” of all the VMs from this output.

Userlevel 4
Badge +11

Hello @Rahul Nair 

Could you please check the query mentioned here and see if that helps: https://documentation.commvault.com/2023e/expert/30867_verifying_backup_status_of_virtual_machines_using_sql_query.html

Best,

Rajiv Singal

Badge +6

Thanks this is giving the VM Names, is there a query which will help to list both VMname, Vcenter Name in which it is configured

 

VmName, VCenterName

Badge +6
Looking for a SQL query which returns this output as per attached screenshot, i need this to use it further to run bulk VM level backups using guid or vm uuid. 

 

Reply