Developer Tools, Integration and Automation

Hi,I am new to the Python SDK, and quite new to Python, and I would like to know if there is a way to assign and to check the tags of a client.I am able to get the properties of the client, but I can’t see the tags.Does anybody could help me on this?Also, I would like to comment that Arlie hasn’t been really helpful yet…Regards,JC

Hi Everyone. currently we use snmp to send alerts from Commvault to ServiceNow. This Creates Alerts in ServiceNow and the Operations team manually create Incidents from the alerts. I would like to change this and I believe Commvault has the ability to auto create the incidents in ServiceNow. I’ve had a little search but has anyone done this and if so do we need to install any software on the ServiceNow side. Any advice would be welcomed. Thanks in advance,

Hi together,I would like to use REST API calls inside a workflow. Unfortunately, I do only find the opposite information in the documentation (how to use workflows with REST API). Can someone give me a starting point for this topic?Best regards.Michael

When I run the following query in SQL it returns a single value that is an XML representation of the client list.SELECT [Client].[Id] 'ClientId', [Client].[name] 'ClientName', [Client].[net_hostname] 'ClientHostName'FROM [CommServ].[dbo].[APP_Client] AS [Client] WHERE [Client].[status] = 2FOR XML RAW, ROOT('ClientInfo');The goal is to use xpath to do queries against the list rather then doing constant queries. The problem is that when I run it in a workflow it looks like it paginates the results so it returns multiple rows. Is there another way to do this?  

Hi Community, I am trying to figure out how to add the discovered SQL Servers to Subclient content using the API. Does anyone have any experience in how to do this? From what I could get my hands on, the API reference did not really specify this. Let me know. Thanks,Daniel

Hello community,Can anyone tell me if it is possible to create an alert for any commissioned or created commvault to inform that it is his first backupExample:"I created a new client to be backed up, as soon as you run the first job it will inform you that it is your first backup and it was successfully completed"

Hi All,I am not able to open a sandbox on CommServe. Blank page is displayed only.Sandbox URL is https://commserveFQDN/webconsole/sandbox/Dev tools in the browser (F12) writes: “Error with Permissions-Policy header: Parse of permissions policy failed because of errors reported by structured header parser.”Trying to open with Microsoft Edge.Repairing the instance has not solved the issue.The https://commserveFQDN/webconsole/sandbox/apiexlorer URL is working.Any ideas?Thank you,Lubos UPDATE: The REST Webservice API Sandbox page finally showed up after more than half an hour :-O

We have an effort to migrate DDB partition to another local volume on the MA for 200+ servers. Doing this via GUI 200 times will not be fun. I’ve looked but haven’t found a command that I can leverage to automate this task. Can’t imagine there being no cli command or qscript for 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.There is a post already answered, but the URL provided doesn't work. https://community.commvault.com/developer%2Dtools%2Dintegration%2Dand%2Dautomation%2D50/delete%2Dmanually%2Dadded%2Dvms%2Dfrom%2Dcontent%2Dvia%2Dapi%2D8768

Any early adopter program to backup snowflake around here ? or private discussion about it to see if there any initiative on that ?

Hello Guys!!I’m looking to create a workflow to auto submit the failed jobs post performing the basic prechecks like ping the client, check connectivity, CommVault services.Can anyone guide me it’s my first step towards making any workflow. 

Since the Job API does not return the admin jobs, looking for anyone who might know which sql table contains the admin jobs, or aux copies/dr copies, data aging jobs Thanks for any suggestion.

Hi Team,I am currently attempting to build a custom report that consolidates the following individual reports into a single comprehensive report:Last 12 Month Backup Job Trending Disk Library Growth Disk Library Capacity Details Cloud Library Growth Cloud Library Capacity Details Average Q&I Time DDB CapacityUnfortunately, I have encountered difficulties due to the lack of detailed database information. I have explored Commcell views, but none have provided the necessary insights.In my efforts to create this report, I attempted to generate a dataset using HTTP from REST APIs. However, I encountered an error stating, “Illegal character in query at index 483: .”Considering an alternative approach, I explored the possibility of using SQL queries. While I identified the table related to the library, “CNMMMediaInfoView,” I was unable to locate other tables containing the required infor

Would you please add the description field in Command center Virtualization / Hypervisors/ vCenter / subclient ?I would like to track what VM’s I add and remove in Commvault without using the java console.

Hello,I’m planning to use the workflow to migrate the media agent role from Windows 2012 to Windows 2019.The maglib has 4 mount paths, 17TB in total. The mount paths are different sizes (see screenshot below). Do i need to give my new mount paths the same size storage or can i provision 4x4.5TB mount paths? Is Commvault smart enough to distribute the data evenly over the new mount paths?I’ve used the workflow successfully already but always on servers with 1 mount path in the maglib.Thanks in advanceRegardsFergus 

I configured the Kubernetes cluster in the environment to perform the backup and added the namespace to perform the PostgreSQL backup. The job is executed and completed successfully, as is the restoration. However, when we upload the database application with the restored data, the error appears: Reported that the database restoration was unsuccessful due to problems mounting the persistent volumes, which prevented the application from uploading correctly.I checked the configuration and it seems to be configured with a Virtual Machine. Does anyone know if I need to configure it differently for the PostgreSQL database environment in Kubernetes, such as when backing up via an agent, for example?

Hello,i’m trying to create a simple python script that permits to add an {‘excludePath’:  ‘/dir-a/dir-b/’} and {‘includePath’: ‘/dir-c/dir-e/log’ }  to  ‘content’: [{‘path’: ‘/’}]the problem seems to be the  subclient.update_properties( )   that doesn’t save to commvault. I can’t see the changes made in Webconsole or Java UI consoleAny idea ? 

In the MaxDB Workflow properties, what should the Security tab look like?Does ‘master’ user and ‘master’ role need to be added?  Or just the specific commvault service account with master (or custom) role be applied? 

Hi folks,I'm building a custom report using SQL. The final output should look more or less like the “Backup Job Summary” report in Command Center. However, I'm running into issues with the Retention column.I’ve figured out how to pull the standard retention using the following query: SELECT    J.jobId,    AR.retentionDaysFROM JMJobDataStats JINNER JOIN archGroup AG ON J.archGrpId = AG.idINNER JOIN archAgingRule AR ON J.archGrpCopyId = AR.copyId The problem is that this query doesn’t return jobs that have extended retention. I’m aware of the archAgingRuleExtended table and tried selecting from both tables and then taking the greater value — but this approach doesn’t seem to work.I also tried applying the extended retention only when JMJobDataStats.retentionFlags > 0, but that didn’t help either 🙁I’m sure I’m missing something obv

I am looking for stencils that can be imported into draw.io to build backup diagrams and environments for documentation purpose.Is this something Commvault has available to customer? If so, can you send a link for download please?Thank you

I see that  update_subclient_filters_template.xml allows for specific VMs to be added to filters but can it also be used to remove them?  I tried changing  -vmFilterOperationType ADD to DEL or REM but no luck.

Hi folks,I need to amend storage policy copy details (using API), particularly this block:I need to change the value of streams number..The GET request I use to obtain storage policy copy details:<webservice>/V2/StoragePolicy/{storagePolicyId}/Copy/{copyId}However, looks like this parameter is missing in the response 😒

Hello everyone, hope you’re having a good day. I’ve been trying to build an API call that would suspend and then autoresume a job but I’m not being able to figure out how. These have been my attempts so far:1.curl -s -L -k -X POST "${URL}/Job/30409890/action/pause?autoResumeInSec=60" \        -H 'Content-Type: application/json' \        -H 'Accept: application/json' \        -H "Authtoken: $key" \        -H "Content-Length: 0" \        --data '{}' > /dev/null2.curl -s -L -k -X POST "${URL}/Job/$jobid/action/pause" \     -H 'Content-Type: application/json' \     -H 'Accept: application/json' \     -H "Authtoken: $key" \     --data '{       "options": {         "autoResumeInSec": 600       }     }' > /dev/null Request 1. will suspend but never end up resuming. I’m basically stuck first suspending and putting it in a loop finding w

Hello Team, We have Windows 2016 servers in 3DC(active-standby-standby) and CommServe LiveSync for High Availability(link below). We want to upgrade these servers to Windows 2022 with Windows in-place upgrade. As far as I know, Commvault software supports Windows in-place upgrade, but does it support it in HA structure? I couldn't find any information about this in the documentation.If it supports it, would it make sense to upgrade standby first, then do production failover, and then do the other one?Is production failover supported on different Windows versions, does it make sense to do it? Thanks in advance!https://documentation.commvault.com/2024e/expert/commserve_livesync_for_high_availability_disaster_recovery.html 

Hi Team, I am trying to do an automation. As part of this, I want to add a VM that I have pulled as a variable via a form to a subclient first (if the subclient content is full, it will clean it and then add the VM) and I want to trigger the Full backup of the relevant subclient. Which Rest API, qcommand, commvault powershell module etc. can I do this better with and which API or commands can I do it with, can you give me some guidance?Another question is, how can I start the Full backup of a VM that I have pulled as a variable via a form (a VM that I have never backed up before, that Commvault does not know yet)?