Assistance Needed to Modify Workflow for Daily Storage Policy Change on All SQL Instances"
Hi, could you please help me with this? We are using the following workflow already preconfigured in Commvault: Demo - Client Group Policy. We need to automatically change the Storage Policy of the SQL Job on a daily basis to meet the copy requirements. The only customization we need is to modify the workflow so that it changes the Storage Policy on all SQL instances and not just the first instance. I really appreciate your support!
@Mike Struening@chrisknows can you help me please?
Page 1 / 1
The code works, but it only moves the storage policy for one instance. I need it to move the storage policy to all instances.
Turn that on and assign the appropriate storage policy and clients
Save as script
Modify the xml - either put it in a workflow or use the generated batch <associatedStoragePolicies> <storagePolicyName>Server plan</storagePolicyName> </associatedStoragePolicies>
You can override the storage policy on the group which should apply to all the default subclients on all the instances of the SQL servers you assign to the group.
@FeRox
Sorry for taking so long to respond, I’m not around much these days. but the way that I do it is by querying for the instances and then looping through them using the ForEachJSon activity.
Generate the url to get the instances using using the httpclient script activity
Feed the uri to the httpclient to get the list of instancs in json format
logger.info("The url for the retrieving for "+clientName+" instances has been set to e" + restInstanceUri + "]"); logger.info("The url for the subclients for "+clientName+" instances has been set to e" + restSubclientUri + "]");
The path will have to match the path to the subclients you are interested in.