Developer Tools, Integration and Automation

I am trying to get the different backups from the sql database, but I can't find the way without having to go through client, instances....

I would to get the list of failed items (details) using cli/ SQL command I’m trying to create an event/ custom report for whichever option which reports more than 0 failed items and trying to gather the details per job. The cli/ Commserve Table/View that’s equivalent to the following API https://documentation.commvault.com/2024/essential/get_failed_items_in_job.htmlGET <webservice>/Job/{{jobId}}/FailedItemsHost: <host name>Accept: application/jsonAuthtoken: <authentication token> or the table/view where this API is fetching the data  Thanks in advance. 

Hello,We are looking for the REST API to check last successfull Full / Synthetic Full job and its retention of a specific client. Preferably one API call for both ( job date + retention ). Any Ideas ? Thanks

I have created a workflow to configure Azure NetApp NAS Storage Backupnow i am calling this workflow from VRA/VRO through REST API , VRA/VRo teams wants more details on response after executing the workflow with the success staus of the client configurationAs of now VRA/VRO receives on the workflow execution job ID, after rest api call.  VRA admin needs to have more details send back to VRA as response , like the workflow execution staus, client creation status. How i can achieve this ?  

I have used the apis to retire and delete the VMs but since the VMs are added everytime manually in the subclient, I would like to use the API to remove it from the content as well. I used the below mentioned API and it deletes the complete content. I just want one VM to be removed.import requestsurl = "https://commandcenterhostname/commandcenter/api/Subclient/100/content"payload = json.dumps({  "children": [    {      "allOrAnyChildren": True,      "displayName": "test",      "equalsOrNotEquals": True,      "name": "503a1c32-6616-10ds-k9l8-130535306451",      "path": ""    }  ]})headers = {  'Content-Type': 'application/json',  'Authorization': '*token*'}response = requests.request("PUT", url, headers=headers, data=payload, verify=False)print(response.text)  

I need the api to get the contents of the of the subclient and then remove/delete it from the content itself. 

I am trying to launch VM backup via API but the api is not returning anything and there is no log in webserver.log.url = "https://commandcenterhostname/commandcenter/api/v2/vsa/vm/{{GUID}}/backup?backupLevel=FULL" import requestsurl = "https://commandcenterhostname/commandcenter/api/v2/vsa/vm/503RF3C6-03BC-24M9-7MVV-3833433C96AB/backup?backupLevel=FULL"payload={}headers = { 'Accept': 'application/json', 'Authtoken': '**Token**'}response = requests.request("POST", url, headers=headers, data=payload,verify=False)print(response.text)There is no return code or output from running the api. 

  Hi,is it possible to run continuous data replication (CDR) using the Network Topology functionality? The point is that the source and destination servers are in different network segments and do not communicate with each other - but both communicate with MediaAgent. Is it possible to setup such configuration to perform replication using gateway (MediaAgent)?  Regards Dorothy  

Hi,i conosle I can click Discover Instance: But I must do the same from api or cvpysdk ?Perhaps, Can I do the same for agent (host with postgresql (linux)) ?brK

Hi,I have several NDMP jobs that I need to run but due to the hardware having a 16 NDMP connection limit, I need to allow each schedules jobs to complete before initiating the next schedule.I am aware that a workflow may be the solution but wondered if anyone had any templates or guides to create the workflow as I am at a loss with the Workflow designer.The schedule has 15 sub-clients in each and all 15 need to complete before the next schedule should run to ensure the hardware limit is not hit. Appreciate any help or guidance/ Many thanks,Rich. 

Which status we can attempt to retry the job via API. I have gone through the below link but I don't see any retry job for the respective status. Can I know for which status I can send an API request for retrying or re-starting the job?  link https://documentation.commvault.com/2023e/expert/job_status_descriptions.html#changes-on-job-status 

Is there a way to check the last replication time of the CommServe LiveSync? Or any other way to ensure that the CommServe LiveSync works fine via REST API (or Qcommand)?

I have mistakenly added some data that shouldn’t be there and I would like to take down my post. But I don’t see any option to delete my post. Kindly help!

Hi Team, I am trying to prepare a custom report in which i want to have a Dataset which should give the output in horizontal tabular format. below is the sample screenshot which should be in horizontal. Basically i want to have horizontal table for each group showing job history count in similar below format. In single report there wll be multiple table with different groups. We dont want to have input. Something similar to below query for example:Select ABC group from XYZ Commcell showing job history with “xyz” fields for last 1 month. 

Hello everyone,I’m quite new to Commvault and only the “secondary admin” but the API guy in the team. We’re running Commvault 11.32.45 in a local VM and have several media agents across our datacenters (no cloud anywhere).I want to get all the devices which are backed up with any job right now. I don’t care if it’s a VM or a physical machine, a database server or a file server. All I need is the device name and maybe the backup job backing up the device.I want to use this information to request details per device from our central DCIM (Netbox) and create a simple list of devices + details.I managed to get clients and subclients via the api but it’s very confusing. There seem to be several apis and several documentations for them.What’s the currently recommended API in general? webconsole, commandcenter, WebServerCore, CVWebService.svc? Which documentation should I follow? documentation.commvault.com, api-next.commvault.com, one I didn’t find yet? Is there a straight forward way to get

Hi Techies,Greetings !Is there any possibility that we can automate daily/weekly repetitive tasks and reduced manual efforts.Here are the few examples:→ Latest backup status information from client or other team members on tickets.→ Virtual Server removal tasks before decommissions request.→ Agent uninstallation and license removal of clients after site decommission.→ Manual retention extension tasks to retain backup till specific date.Here I want to reduce manual efforts and time, please share some ideas to achieve this. Thak you ! 

Hi Team, I have written a script that would delete the decommissioned VMs from the commvault. I have 2 questions.As of now my script takes the client id manually to delete the VM. I would want Commvault to detect the decommissioned VM and delete it. Please guide me on how can I add auto detect of decommissioned VMs on my script.  I have to integrate Morpheus API and Commvault API and execute the script from the Jump server from where Morpheus is accessible. As of now, Commvault APIs are running only from Commvault server. How to do this ?

Hi Support TeamHas anyone encountered and resolved an issue where, after replacing a MediaAgent using the app, the new MediaAgent does not appear in the Storage Policy's primary copy? I'm unsure how to fix this and add the new MediaAgent to the primary copy. (The Jobs for replace mediagent showing all completed)Best RegardsTai Nguyen

I have a situation here, after migration from 11.28.72 to 11.32.45, VM which were added using VM rules using VM tags appeared in different subclient of a Vcenter virtual server and it is impacting SLA since now the VM tag issue is resolved and backup in running under one subclient. Now i need to disable backup activity for the client for other subclient except the original subclientcurrently the VM is appearing in only ine subclient of the vcenter virtual server which is JPAWP, and the VM is not available or not showing under any other subclient. But when we check individual VM , it shows multiple backupset/subclient and it is impacting the SLA. Now i need to disable the backup activity for the VM, for specifc backupset/subclient. Do not disable backup activity on client level because the VM is curently backing up in its original subclient.Now i need to disable backup activity for the VM for all the subclient except the orignal subclient which is JPAWP here.I am creating workflow to ac

Hey,Which API endpoint to use to get Storage Policy for a client? My requirement is to get Storage Policy for all clients, preferably without querying for each client individually. For VM client, I can use the /VM endpoint which lists all the VM with their Storage Policy. I need help with FS clients. Thank You.

Hey! I am developing automation scrips using Commvault APIs for my team. I know the names of primary commserve which I use, BUT whenever a failover happens my API calls of course don’t work as there is no web service active on the primary commserve.  Is there a way to know which node the failover happened to using just the APIs? And also get the list of all failover nodes?  

via Command Center it is not possible to restore a SQL-database “in place” to an availability group. Does anybody have a workflow or Powershell-Script that can remove the database from the availability group before the restore … and back to the availability group after the restore? Any help is very much appreciated. Best regards. Michael

Hey,I am getting all clients and basic details with /Client endpoint. Is there a way I can also get the client description without making individual API calls for each client?  Thank You.

Hi,I’ve seen that I can get a RestAPI call for a report like it is mentioned in that topic:  How do I use this URL e.g. in a python script?Have I just to run a command like the following after I’ve done a login? payload={}headers = { 'Accept': 'application/json', 'Authtoken': token}url = <API CALL URL>response = requests.request("GET", url, headers=headers, data=payload) Second Question, which permissions are necessary to keep the user rights as secure as possible? BRJan

Hi Team, I have two different lists with names in it. I want to use each value from both the list inside for each how that can be done in workflow? <App_SetClientPropertiesRequest>    <association>        <entity>            <clientName>xpath:{/workflow/ForEach_1/OldName}</clientName>            <newName>xpath:{/workflow/variables/new_name}</newName>        </entity>    </association>    <clientProperties>        <client>            <clientEntity>                <clientName>xpath:{/workflow/ForEach_1/OldName}</clientName>            </clientEntity>        </client>    </clientProperties></App_SetClientPropertiesRequest> xpath:{/workflow/variables/new_name} has a list of names which is not working, everytim it is taking same object it also should work as ForEach value which can be used, any idea or suggestion