Developer Tools, Integration and Automation

Is there a easy way to query the count of waiting jobs similar to the Job Controller display? I am able to run the Jobs API request for each client but that takes a long time.

I’m using subclient ID to add a VM to a subclient.  I can’t find and example for this.  Does this json template from here actually work? https://documentation.commvault.com/11.24/essential/49184_rest_api_post_subclient_properties.htmlI keep getting 400 Bad Requesthttps://documentation.commvault.com/11.24/essential/assets/features/rest_api/JSON/update_subclient_vm_template.json{ "newName": "", "subClientProperties": { "vmContent": { }, "vsaSubclientProp": { "useChangedTrackingOnVM": , "quiesceGuestFileSystemAndApplications": , "datastoreFreespaceCheck": , "datastoreFreespaceRequired": , "collectFileDetailsForSnap": , "collectFileDetails": } }, "association": { "entity": [{ "clientName": "", "subclientName": "", "backupsetName": "", "instanceName": "", "appName": "Virtual Server" }] }}

HI All,I want to send the the output of the report activity in workflow as the attachment in email activity. However when I try to insert variable in attachment tab of email input, it does not give this option: Please help to understand how i can send the report activity output as attachment in email activity?

Getting 400 Bad Reques “Request body is empty or format is invalid”Its for the Virtualization client and I’m just trying to create a new client.  Should be pretty simple.POST {{ServerUrl}}/ClientThis is in the example call for POSTMAN and not working.  Anyone know what is wrong?{    "clientInfo": {        "clientType": 12,        "virtualServerClientProperties": {            "virtualServerInstanceInfo": {                "vsInstanceType": {{vsInstanceType}},                "associatedClients": {                    "memberServers": [                        {                            "client": {                                "clientName": "{{clientName}}"                            }                        }                    ]                },                "vmwareVendor": {                    "vcenterHostName": "{{vcenterHostName}}",                    "virtualCenter": {                        "password": "{{base64encodedPassword}}",                        "userName": "{{UserName}

Hi!We have a lot of microservices in development that will use RDS PostgreSQL as a DB. They will born together, at same time.I would like to put this new RDS in a existent structure using terraform, adding plans, storage policies, schedules, etc.Has anyone done this? Any tips? I have done some research on the internet and have found very little on the subject.

A question about the implementation of multitenat when using the same commserve.I have not been able to understand if it is necessary a server that acts as a proxy, or that must be enabled to implement it, is there a step by step guide for such implementation, in my case I already have a solution in production and the requirement is to install another company that has a mediagent but that is in a separate environment and does not share resources with the first production environment, acting as a separate solution. is it possible?

Hey Guys!I have no experience in automation. I want to apply for a job that requires IaC. That's all that I know. I don't know what kind of IaC they are talking about. It's a large enterprise environment.  What are your CommVault IaC solutions? There are different solutions, like Ansible. What is supported by CommVault, or what solution works best for you? I know you can save as script, write qcommand scripts, using the Powershell cmdlet, but what is more common nowadays?  What are the benefits of your IaC solutions, why did you implement it, what are the best use cases, and why was it your best decision, otherwise, what do you dislike, and what are some downsides? What kind of automation does not work with CommVault but would be great, what are some features which are you waiting for? Thank you a lot! Kr

Here’s an annoyingly wierd one. I have a workflow that does parsing to create a string for use in a powershell script. This is what the script looks like://Prep Hardcoded Values for use in Powershelldef vCentersList = xpath:{/workflow/configuration/vCenters};def vCenterCount = vCentersList.size();def BackupPolicies = xpath:{/workflow/configuration/BackupPolicies};def forCounter = 0;// Convert vCenter List to vCenter StringStringBuilder strbul = new StringBuilder();strbul.append("@(");for(String str : vCentersList){ forCounter++; strbul.append("'"); strbul.append(str.replaceAll("\\s","")); strbul.append("'"); if (forCounter != vCenterCount){strbul.append(";");}}strbul.append(")");String vCenters = strbul.toString();workflow.setVariable("vCenters",vCenters);return vCenters; The input is a list of vCenter cliententities.. which looks something like this:[“vCenter1”, “vCenter2”, “vCenter3”] When I run the script in the debugger the script returns the following:@('vCe

So I have some scripts that I use to disable/enable the activity controls in my Commcell (so that I can automate maintenance task).  The script works fine on 11.28.65 and returns a JSON showing that everything is working fine.  When I run this against my Commcell that is at 11.28.69, I get this back as a JSON:{ "processinginstructioninfo": { "attributes": [ { "name": "WebServer", "value": "Commserv" } ] }, "errorMessage": "Failed to set [Activity Control] for [CommCell] with error [OPERATION FAILED: Please check logs for more details.].", "errorCode": 587203847}It only returns this if the status needs to change (i.e. activity is disabled, and I’m trying to enable).  If the status doesn’t change (i.e trying to enable activity when it’s already enabled), it comes back with a success.Any idea what logs to look in to see what is going on?As a secondary note, the user only has Global > Administrative

Hi, We had automated the process of creating a vm group for a hypervisor for AWS, this was working for new AWS that were never configured with commvault before, but after we upgraded commvault to the latest version, our script failed while executing subclient._process_add_request(json_request) on a new AWS account with the following error: raise SDKException('Response', '101', self._update_response_(response.text))cvpysdk.exception.SDKException: Response was not success},"errorMessage":"The [AWS-Plan-Development] plan is an Elastic Plan. To select this plan, associate the client to a region.","errorCode":587206437 We noticed that the Workload region wasn't set in the admin console of Commvault (Under Virtualization/Hypervisors) for this new account, which was done automatically before. So after setting this option and rerunning our script, our script could finish the setup successfully. We instantiated the Commvault client, and we could verify that the region was already

HiI am trying to browse VM protected file systems which can be browsed from the CC and Java GUI with:{    "opType": 0,    "queries": [        {        "type": 1,        "queryId": "countQuery",        "aggrParam": {            "field": 0,            "aggrType": 4        }    },     {        "type": 0,        "queryId": "dataQuery",        "dataParam": {            "sortParam": {                "ascending": true,                "sortBy": [                    38,                    0                 ]            },            "paging": {                "firstNode": 0,                "pageSize": 15,                "skipNode": 0            }        }    }    ],    "mode": {        "mode": 2    },    "paths": [        {        "path": "\\"    }    ],    "options": {        "showDeletedFiles": true,        "restoreIndex": false,        "vsDiskBrowse": false,        "vsFileBrowse": true,        "skipIndexRestore": true,        "hideUserHidden": false,        "useExactIndex": false           

Hi,I want to collect or check how much capacity is consumed each client. is there any scripts or automated way rather than check every client’s job history?

Hi,We need to use HCL Domino 12 for security updates.  But the Commvault Backup agent for Domino does not support HCL Domino 12.HCL Domino 12 has a new backup integration feature, we plan to leverage this and use the Commvault via REST or Powershell to integrate with Commvault backup.Has anyone experience with integrating with Commvault using the REST API?Is there a product manager I can contact?Would love to here from the community! Lars 

Hi, I have a list of 100+ clients in commvault. I will need to add new AD groups to existing permission role for these clients in security tab at both client level and file system level. Does anyone know how to use CLI to do it instead of going through GUI one by one?Once I have this CLI command I can put together something in Excel and run them in bulk. I know I can create a client group and add permission in this way but in our environment we have to do the change on clients. Kind regards,Boyi

Hi all,A few months ago I came here to be able to restore sql server databases using the API instead of the qcommandshttps://community.commvault.com/commvault-setup-guides-and-getting-started-51/run-qoperation-exe-from-remote-server-5379So I have the xml file to restore the database and I have a STOPAT parameter.In the xml it shows like this :            <pointInTime>              <timeValue>2023-05-19 09:54:04</timeValue>            </pointInTime> My xml file works if I run sth like :qoperation.exe" execute -cs $CVLTServer -af $CVLTXMLFile -tf $CVLTToken Then it doesn’t if I run :$cvrestendpoint = "http://$CVLTServer:81/SearchSvc/CVWebService.svc" $token = (Get-CVSessionDetail 'Get-CVVersionInfo').sessionToken$restParameters = @{# Variables for holding rest parameters for the request    URI     = ""    Method  = ""    Headers = @{"Authtoken" = $token;"Accept"    = "application/json"}    body = ""}Get-Variable | Where-Object {$_.name -eq '$xml'} | Remove-Variabl

Hello all, I recently found out something that I missed, docs have been updated at some point, so wanted to share this with you all as well. (https://documentation.commvault.com/11.24/essential/131495_predefined_activities_for_workflows.html)So take the CommServDBQuery predefined Activity. You have an input defined as a client computer group and then want to get a list of clients within the group via this activity type. I have seen many people do this...SELECT c.id, c.displayNameFROM APP_ClientGroupAssoc cg WITH(NOLOCK)INNER JOIN APP_Client c WITH(NOLOCK) ON c.id = cg.clientIdWHERE cg.clientGroupId = xpath:{/workflow/inputs/vmGroup/clientGroupId}Note that the where clause contains the input as a variable.So this is a bad thing! Have a read through the doc link above, you can see that there is a risk that this could be used to inject SQL code into the workflow and do something you did not intend to happen.Instead, change it to below…SELECT c.id, c.displayNameFROM APP_ClientGroupAssoc cg

Hi all. I have a question regarding the Workflow Configurations (see this post:) In general I know how to use these and they work like a charm. Unfortunately I don’t have any possibility to see the configured values after setting them.E.G. I have a “configuration” with the name “TestConfig” of type String. I can set it to “Whatever” in the properties of the workflow and the workflow will use it. But if I have a look again in the properties it looks as if “TestConfig” is empty and not set.Am I missing something or is there no possibility to look at the configured values?

how to from reports or (best) power shell check contents of selected Library / Mount Paths . I know that for particular MP can do that from CS console but i look for automatic way and more on Library level beside MP by MP.

I am trying to create a JSON payload to submit to qoperation the problem I seem to be running into is that I can’t access the properties of the cliententity object.I tried to see what would happen if i did something like  logger.info(servers[0].clientName)and the output I get is null.This is what the script looks like: This is what the for loop looks like: This is the output:  Clearly I am doing something wrong.I posted this in the private area in hope it would get more traction.Thanks.

Hi All,I have MSP like structure where do have 8-10 companies. I have created power bi dashboard using REST APIs and can segregated clients based on that. Now business wants to segregate data Application wise. Company1 will have multiple application (Network, AD, File server etc.)Is there any way to have such hierarchy and pull data into Commvault reports without using Client computer groups?

Hello I need to implement backups for a new customer who has different companies and wants to do it from his commserve which already backs up other customers machines that are in a different IP range.Thanks for your help!

Hello, i created workflow and use foreach for run backup task (multiple clients). how i can wait job complete for multiple parallel jobs?i tried use WaitForJobCompletion in step after starting backup task. If configure "number OfParallelExecutions" value in "1" for foreach, task is executed sequentially (it's normal,  we are waiting for the task to complete to start another task).When configure "number OfParallelExecutions" value in (for example) "10"  for foreach and use WaitForJobCompletion in step after starting backup task, the tasks are executed in parallel, but we have error "Error Code: [19:1805]" in workflow. But, workflow work correctly and backup done.finnaly, is there a way to monitor (for jobs waiting for other steps on the workflow) the execution of multiple parallel  (backup) jobs runs inside a "foreach" block outside of "foraech" block? When uses "number OfParallelExecutions" value in (for example) "10"  for "foreach" block.Thanks

I have a customer asking if CV has a way to confirm the validity of the backups that are taken. I am not aware of any way to test whether a backup has all the content it is supposed to backup versus what is on the target server that is being backed up. Beyond the normal stuff like alerts, reports, dashboard etc etcThey ran into an issue where one of their backup admins made a mistake and let a failure ride for several months, had a critical recovery request and now they are trying to figure out a way to make sure their backups are sound.I doubt it, if the backup admins are not following the reports/dashboard and alerts then I am not sure what we could provide beyond that.  

I want to automate the creation/adding of new libraries, specifically such of the type “S3 compatible”. So, not a classical Disc Library and neither a Cloud Library (Like Azure or AWS).I’ve crawled through the Python Modules and the REST API but I can’t seem to find any way of adding such “S3 compatible” type library, only normal Disc or Cloud ones.Does anyone know of a way to get this done? Or have I missed something?

Hi Everyone, I am trying to update storage policy copy retention but i am not having a much luck.In the command center you can edit the plan then edit Backup Destinations which are storage polices and it generates an Equivalent API and JSON payload, but when i post to URL it generates i am just getting a return off storagepool list.    is this the correct location post:https://mycommserve/commandcenter/api/StoragePool?Action=copyEdit what i am trying to achieve is that updating retention rule for “retainBackupDataForDays” in number of secondary copy policies. is there any sample that can help?  Thank you!