The basic purpose of this query is to get the current storage policies of all VMs from API.
We want the current storage policies. Not one that has been deleted. Not a duplicated one. Not one read off the last backup. The current storage policy, as per displayed in Commvault GUI client. We also want to know if this can be achieved in a single API call.
We’re running into some issues with the Commvault API, where we get deleted and duplicate storage policies. It’s also extraordinarily inefficient, requiring 3 calls to get 1 storage policy, resulting in it taking more than 40 minutes to get all storage policies, versus a minute or two in SQL.
I am using below REST API call for VM’s Client, then SubClient id, to get Storage Policy from SubClient properties.
VM’s Storage Policy from Subclient Properties