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.
Solved
Commvault DB Query to list all the Virtual Machines (VSA) clients
+5- Apprentice
Best answer by Rajiv
Hello
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
- Vaulter
Please try with the API and let us know if this helps:
https://api.commvault.com/#734d6b5e-cebf-42b2-b673-7af1449082b5
+5- Apprentice
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.
+5- Apprentice
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.
+15- Vaulter
- Answer
Hello
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
+5- Apprentice
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
+5- Apprentice
Readiverse Academy Certifications
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.