Developer Tools, Integration and Automation

Hello All We take adhoc backups every day for patching activities and we search for each and every client in Command Center and trigger incremental backups for those clients(more than 100 every day). Is there a way that we can trigger the backup for these clients using RESTAPI. Foreach through these clients and trigger the incremental backup. I was able to authenticate and generate the authentication token but cannot trigger the backups for those clients. Its my first time with RESTAPIs. Would be grateful if someone can point in the right direction. I am using PoweShell. Thanks

I’ve started to integrate the api within Databricks. With common script and managed to extract all client / sub Clients using the documentation provided from customer Support.I asked internally to our SysAdmin that manage CommVault,  to give me an extraction of the data from CommVault (All Clients).The list given from sysAdmin does not match with what I extract from API ( Like 4000+ hostname in mismatch).My Question is :Has someone encountered this issue? Shouldn’t route /Client return ALL  and I Mean ALL clients that I see on CommVault application? Why do we encounter a mismatch between API and commVault Extraction?

Hi everyone,I’m using powershell to automate the send logs file for a specific job in commvault.  I want send these logs to a specific local path in the server, but according to the this documents Send-CVLogFile (commvault.com) the available option is to email. So my question is, there’s another way using powershell or other api to do this?  Thanks. 

Hi, is there a way to monitor the Status of the Commserve Activy Control. We are using PRTG to Monitor our Systems and want to get notfied about the Status of the Activity Control in the Commserve.  I checked the API but did not find anything which is related to this case. Maybe there is a way to trigger a SQL Statement to the Database or SNMP. Kind RegardsFlorian

Hello,I’m curious if anyone has encountered the issue of decoding the status codes for vms and other api endpoints for protection status.  For example:"vmStatus": 1 I know these typically are 1-6 but could commvault support provide a mapping for each of these to help us determine what this means for protection status? Also, if it differs for vm clients to db clients, what should I expect from those as well? PS - I did see this topic /webconsole/api/v2/MediaAgents status and offlineReason codes and it was close to what I was looking for but this was for MediaAgents where I’m specifically concerned with VMs and DBs

Here is the form activity.  Now here is the logs…SetActivityInputs: starting activity with inputs [<inputs><request><method>POST</method><postType>Form</postType><postContent /><postContentType>application/json; charset=UTF-8</postContentType><headers><name>Accept</name><value>application/json</value></headers><headers><name>Authorization</name><value /></headers></request></inputs>]As you can see the value for authorization is empty. The variable is set, but no matter what I do it refuses to honor it.

Hi,This is my first attempt to resolve some problem using Workflows.I have a default subclient that backup all DBs on Windows SQL using SQL agent.The attached schedule policy runs full daily at 9 PM and then tlogs every 2 hours.The problem is that a pre and post script has to be run on the client before every full backup, but not during tlogs backup, so I cannot use the pre/post script tab in the subclient properties. Is it possible to create a workflow that will monitor this subclient activity and if the CommCell is trying to run the full backup, the workflow will pause it, run the script, wait until is finished and resume the backup, and run the post script at the end, but when is backing up tlogs, will bypass both scripts? Sorry if I am overcomplicating things, if there is a simpler solution, all welcome to share it :) Thanks,Marcin

HiDoes anyone know if there are any restrictions in the workflow engine regarding the use of temporary tables in the CommservDBQuery activity? In the SSMS the query works fine.  When I run the above SQL query in the debug mode, I don’t get any output: I also tried to use a table as variable, which did not work either.The workflow engine runs on a dedicated server. Could this cause the issue? Thanks for your inputsMichael

We have a scenario where the following occurs, managed by a popular scheduling application on a server somewhere1 - Scheduling app logs in to the application server (VM) active node and stops <application_service>2 - Scheduling app kicks off maintenance tasks take place on the Active Node  with the application stopped3 - Scheduling app runs PS Script to tell Commvault via our CV “API Server” home brew with Web Console and other components installed to take VM backup of the app Active node with services stopped4 - once backup done, sends result back to PS script and if 0 (success) then the script restarts the application service on the active nodeProblem - This is all unnecessarily complicated by the presence of the ‘homebrew CV API server’ which was built and has no docs.I need a better, aka simpler, way. If the VM subclient cold run pre-post scripts, perfect, but it cannot.  Any suggestions please? With details. Thanks

I would like use these commandEnable-CVSchedulePolicy -ClientName <String> -SubclientName <String>Disable-CVSchedulePolicy -ClientName <String> -SubclientName <String>But i have a small problem with thatThe primary function sought is to deactivate or dissociate a client's policy.In each policy I have several clients.I therefore need to do that only on one or a list of clients and not on the entire policyis it possible to refine the powershell command in this direction ??

I was wondering if anyone out there may have ever tried to configure a Netbackup server as a Data Source for Metrics Reporting?Could it be possible to make this work so that we could report on other backup tools from within Commvault?We’re an MSP and looking for a way to report on all of our backup products from one place without having to fully build a solution in-house.

Hello,I’m looking a manner to get the IndexCache status using Command Line or RestAPI or qscript, qcommand … in order to automate  some maintenance tasksCommvault version is 11.28.

Hi community. I would like to create a dynamic WizardBlock that iterates over a list and displays PopupInputs for all the entries in the list. I tried it already like in the picture below. Unfortunately this just puts every PopupInput after the other but without the “back” and “next” buttons. It is completely ignoring the WizardBlock. The same apllies to a modified version where I put the WizardBlock inside the ForEach loop.  Any ideas if and how I could achieve my goal? I would even go with a solution created dynamically by java code if there is no other option. But I also cannot figure out how I would do that. Best regardsPasqual

Hello,I need to create a workflow that performs push network configuration to the client. Do any of you have such a workflow and could share it with me, or is anyone able to direct me how to do this? Thank you very much in advance for your help! 

Bonjour à toutes et à tous,Ayant des copy allant sur bandes, je dois prouver à certains client que les données ne sont plus accessibles à la fin des rétentions, pour moi un simple delete contents / delete ne suffit pas à rendre les données inaccessible sur la bande mais permet juste à commvault de ne plus y avoir acces.Donc nous ne rentrons pas dans le cadre legal de la règlementation sur la gestion des données. Tant que la bande n est pas formater ou qu’un nouveau label n’est pas positionné, il est toujours possible d’accéder aux données sur cette dernière via des outils tierce.  Quelqu’un a-t-il un ptit tips pour effectuer ces actions via une qcommande ou via l’API.Merci d avance

The GET V2 MediaAgents API has some numeral codes for offlineReason and Status which seem to reflect some different senarios.  I have seen 0, 1, 2, and 5.  Usually there is documentation coving these things but I not finding it in the online documentation.  Do we have a link to this info?{            "offlineReason": 0,            "description": "",            "status": 1,            "mediaAgent": {                "mediaAgentId": 2,                "_type_": 11,                "displayName": "dm2perf3",                "mediaAgentName": "dm2perf3"            },            "osInfo": {                "osId": 210,                "OsDisplayInfo": {                    "OSName": "Windows Server 2016 Datacenter"                }            },            "versionInfo": {                "UpdateStatus": 0,                "GalaxyBuildNumber": "11",                "GalaxyRelease": {                    "ReleaseString": "11 SP17",                    "_type_": 58,                    "ReleaseID": 16    

Hello Community, im wondering how to work with list(string) together with for each.My customer needs to fill in a form with all the clients he needs into a multiline field like this. how does the foreach activity goes to every line from the list?Thats not how it works:  thanks a lot and regardsJacob

Hi,I am trying to to explorer automating our Commcell environment. Unfortunately I encountered and error connecting to commcell. I would like to inquiry the error when connecting to commserve using cvpysdk python library. Below is the error.   Error when connecting to commserv using hostname. but i can ping the hostname from the server.  If something is blocking, is there a required port to open to be able to connect successfully?

Hello, I need your help to understand how to do a browse through files with python. The ArchiveSet=MyArchiveSet1A have 14day retention period.We want to preserve diferent versions of the same file. When we run backup on a file the previous version is replaced by the new one...When browsing the Backupset = MyArchiveSet1A we only get the last versions of the files.How to preserve multiple versions of the same file in the Archiveset ? We are using Commvault 11.30 #### _f2bk - full path of the file to backup# _d2bk - path to browsectx = Commcell('spfpt01cmv01','USER','PASSWD')client = ctx.clients.get(_client)agent = client.agents.get('File System')yn = agent.backupsets.has_backupset('MyArchiveSet1A')if yn:  print("### Exist ###")  backupset = agent.backupsets.get('MyArchiveSet1A')subclient = backupset.subclients.get('default')subclient.content = [_f2bk]subclient.enable_backup()job_backup = subclient.backup(backup_level='Full')stt=job_backup.statuswhile stt == 'Running':  print("Backup stat

Friends, I try to find a way to automate the sql61props via Rest API or Powershell modules. Does anyone has experience with this? My goal is to remove the MSSQL Credentials (Impersonate Users) or replace by dummy and to disable overrideHigherLevelSettings per Client as this is now managed at Server Group. I tried to use Get-CVClient, update $_.pseudoClientInfo.idaInfo.sql61Prop as how I want to have it and post this via Set-CVClient. The answer is that it is successful, but nothing is changed. I also tried to update the settings directly via Submit-CVRESTRequest with the result; answer like succesful, but nothing done. I was looking at sending an XML to send the update, but I can’t find the parameters. Can anyone help me with this?Thanks in advance,Maurice

I would like to know if there is any qcommand/ API to power on the Media agent   

Hello,I am trying to create workflow for VM backup and restore.I have used predefined workflow Demo_FileSystemBackupRestore and tried to modify it for VM.Everything goes fine until it gets to restore phase where I get Error 0x303: Q_VIRTUAL_SERVER iDataAgent is not supported by this command.Thanks for any suggestions,Michal

I am monitoring the subclients. I see the “enableBackup” in the api for the subclients but notice the job does not run when the instance is not enabled which I can detect visually from the UI but do not see an attribute in the Instance or InstanceProperties API. Is there attribute for the instance enabledBackup?  

I would like having a workflow for backing up Postgresql databases and restore a subset to another Postgresql client and instance by using DumpBasedBackupSet.So I started editing a clone of the “Demo_FileSystemBackupRestore”-workflow.I was able to change the “Backup” and “Restore” task to Postgres in ‘dataAgent’ and giving the instances.What I wonder: the field “instance” is of type String - isn’t there a way to fill this field automatically with all the instances of a given client? For we have Postgresql-clusters with several instances running …But where I am definitely stuck is at selecting the database to restore, neither Backup nor Restore include a field for specifying subsets of backuped data.Any hint to put me on the right track is very welcomed.Markus

Hello,I’m trying to find a way to apply backup set level filters for VSA Agents via API.I’m unable to find the XML or JSON on BOL that include the filter section. I can apply the filters at the subclient level via API, but the end goal with the backup set filters is to ensure that VMs that meet the filtered criteria no matter which subclient they are associated to are not backed up.  Backup Set Properties:https://documentation.commvault.com/2022e/essential/45813_rest_api_post_backup_set_properties.html????????????????????????? Subclient Filters:https://documentation.commvault.com/2022e/essential/49184_rest_api_post_subclient_properties.html$apiBodyAddVMFilter ="<App_UpdateSubClientPropertiesRequest>                <association>                    <entity>                        <appName>Virtual Server</appName>                        <backupsetName>AWS-$region</backupsetName>                        <clientName>AWS-$AccountId</clientNam