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

@Rahul Nair 

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

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

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.

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.

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

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