Developer Tools, Integration and Automation

Hi, We are trying to add mysql instance, but both cvpysdk and API failed to do so.  For cvpysdk i opened github issue, but not sure it’s actively maintained?  For API, using this page and example values: curl -k -L -X POST 'https://commsrv/commandcenter/api/Instance' \-H 'Content-Type: application/json' \-H 'Accept: application/json' \-H 'Authorization: Bearer [...]' \--data-raw '{  "instanceProperties": {    "instance": {      "instanceName": "aymasterr_3306",      "applicationId": 104,      "clientId": 461,      "clientName": "a-o0"    },    "mySqlInstance": {      "BinaryDirectory": "/usr/bin",      "LogDataDirectory": "/var/lib/mysql",      "ConfigFile": "/etc/my.cnf",      "port": "/var/lib/mysql/mysql.sock",      "EnableAutoDiscovery": true,      "SAUser": {        "userName": "root",        "password": "cm9vdAo"      },      "proxySettings": {        "isProxyEnabled": false,        "proxyInstance": {          "instanceId": 0        },        "isUseSSL": false,        "runBackupO

I need an API endpoint to fetch the subclient id. For testing purpose I copied the ID from the url: https://win-igicqf1affn/commandcenter/#/collectionDetails/content/3/10 In the above mentioned URL 10 is the subclient id. I have used it in other API endpoints. But when I use the api in order to fetch the subclient id it gives me 14 instead of 10. Below are the links to APIs I have been manipulating.https://api.commvault.com/docs/SP34/api/cv/VirtualizationOperations/update-subclient-virtual-machine-contenthttps://api.commvault.com/docs/SP34/api/cv/SubclientOperations/get-subclient-propertiesThe api that is giving me a different subclient id:https://api.commvault.com/docs/SP34/api/cv/SubclientOperations/get-subclient-idimport requestsimport jsonurl = "https://win-igicqf1affn/commandcenter/api/subclient?clientId=8"payload={}headers = { 'Accept': 'application/json', 'Authtoken': 'token'}response = requests.request("GET", url, headers=headers, data=payload, verify=False)pretty_json = json

Hello all, I search to create a SQL alert in order to notify me if an agent have no schedule policy associated.I found an sql query…. but not sure of it. Can you help me ? Thank you ! use commservselect distinct CommCellSubClientConfig.clientname, CommCellBkScheduleForSubclients.scheduePolicy, CommCellBkScheduleForSubclients.scheduleName, CommCellBkScheduleForSubclients.schedbackuptypefrom CommCellSubClientConfigjoin CommCellBkScheduleForSubclientson CommCellSubClientConfig.appid = CommCellBkScheduleForSubclients.appid

Can you please provide API to Fetch "Reason for job delay" message (error/Failure message of job)    

Hello,I have many backup database to enable / disable and some times we forgot to renable it. Is there a report to view schedule policy checked and unckecked ? Or how can i create it ? Thank you for your help. 

Hello,does anyone know how to delete Disk Filters on a Hyper-V Subclient via qcommand? Add works, modify works but delete doestn do anything to the filters. Im Using this XML: documentation.commvault.com/2023e/expert/files/products/vs_vmware/command_line_xml/update_disk_filters_template.xmlAnd the job is running (any spelling error results in pending jobs) but nothing happens to the filters.XML Parameters for Microsoft Hyper-V Backup Set Configuration (commvault.com)In the xml i’m just swapping “ADD” to “DELETE” and this entry should have been removed. Thanks for help and regardsJacob

I can't find any url that I can attack to return these values.

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. 

BMC - Entuity IntegrationHas anyone had any experience of integrating CommVault with BMC - Entuity for network infrastructure monitoring, Looking at monitoring CommVault jobs within Entuity as a ‘one pane glass’ SIEM.

  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 ?