Developer Tools, Integration and Automation

Hi All, I am baffled by why I have same API working on commserve and on another I get Internal Server Error (500).. I am trying to launch a backup job, using same api request and get different outcome on 2 commserves… api request Here you can see in red there is the api request if application is Virtual Server - this is failing with 500.outputAnother which is File System - completes ok. For SQL also completes ok..  I’ve tried different backup levels thinking maybe there is some kind of thought behind it.. looked into documentation here: https://documentation.commvault.com/v11/essential/45793_rest_api_post_backup_set_backup.htmlFollowing that I’ve changed headers to application/xml instead of /json - but still the same… Logs from the failing commservs webserver.log:webserver.logAny ideas on this one?

Anyone using CVPySDK and Ansible?  I am unable to get it to function.  I have pip installed and can run the commcell functions from within the python interpreter.When I attempt to use it in a playbook, I get an error… ERROR! couldn’t resolve module/action ‘commvault’ Ansible 2.10.7python 3.6.8. Ken

Hi Guys, Hope everyone is doing good.Is there in windows command to be used on the MA to check if there are any running jobs on that MA ? Kind regards.

Hello!I'm using the cvpysdk in order to restore SQL Server databases, but unfortunately I can't find an option to restore out of place and change the name of the database.Maybe someone here faced this issue and can help me with this?

Friends,I want to use a script to retire/delete VMs from Commvault when the last backup is at a certain age. As we are a tenant customer, we don’t have options like Workflows.So I build a Powershell script to collect data, do different checks and fire Rest calls to Commvault.I can delete via the following command and this works fine:Invoke-RestMethod -Method 'Delete' -Headers $headers -Uri $($url + "/v4/virtualmachines/$UUID") But I can’t find the option to Retire the VM !And important in this case that I only retire the VM backup, not the client, as FS and SQL backups might be still in use. Anyone who knows how to Retire a VM using Rest-API ? Thanks in advance, Maurice

Documentation for Workflows mentions some Functions for Java to interact with or access other Resources during execution https://documentation.commvault.com/commvault/v11_sp20/article?p=49729.htm.But alone from browsing through the other Pages it gets clear there are way more options like activity.exitCode or workflow.setFailed().Dissecting built in Workflows reveals other treasures like csdb.execute(“sqlquery”).Is there a complete list of all available Functions and how/when to use them? Trial-and-Error and Reverse-Engineering by Customers seems error-prone and inefficient.

We do automatic rollouts of Active Directory in Azure for our Customers with Ansible.We want to install the AD iData Agent with the Unattend Package and Custom “install.xml” File.These we are already doing successful for MA, Proxy and Restore Agent.If you do Unattend AD Installation in the XML is PW for AD Agent needed. But it is expected a hash, but i cannot find what hash (for the PW) the Installer expect. Normal PW is not working and sha-256 hash of PW is not working, too.This is the line in XML:<activeDirectory>               <userAccount password="3820c5c6992b6774aced93ecd88e04e35b4398d99e3f0a7d8"          domainName="q1xyz.local" userName="svc-adbackup" /></activeDirectory>So it would be important to know with what the setup when you create the package the PW encryptes, because during automatic rollout we get it from our central key Vault during installation. 

Hello! All good?My name is Filipe Asaph, work in StorageOne.I would like to ask you questions about Commvault's "Workflow" tool. I'm trying to send an email in Workflow, but it always gives an error. The error number is 19:857.Grateful, Filipe Asaph.

I cannot use the client list because we have duplicates with the same hostname. I need a query or even a rest api call that can get this information. thanks.Chris.

The APP_VM table seems to only include information for VM’s that have been backed up.Where is non-backed up VM information held? Thanks.Chris.

I'm trying to automate certain tasks by querying the APIs. I first tried the newly released Powershell SDK which turned out to be broken right now. The development team is aware and they stated they will fix it somewhere next week so I decided to continue without SDK and write the modules myself.I'm trying to achieve the following:In case the client is discovered via VSA I would like to know the hypervisor vendor. In case a client is not part of VSA I would like to know if it runs as a virtual instance and preferably I would like to know what kind of virtualization platform. I know Commvault pulls this information from a client using the agent to make the distinction between OI and VOI and also that they can identify the platform but would like to leverage this myself as well and I would expect this information to be available as a client property that can by pulled over via the API. 1)So I already discovered that in case a client is discovered through the VSA client that the client pr

Can anyone have workflow for below steps ? we would need to run the workflow as the first step and then the workflow would have a box that pops up asking for the name of the Client we want to decommission where we input the client name.Then we want the workflow to remove the client from all the groups it is part of (with the exception of automated client groups).Next we want the workflow to turn off backup activity of the client.Next we want the workflow to add the client to the decommissioned group.

Is it possible to set the Client Monthly Growth Report to update the data not only monthly but daily ?Somewhere there should be a schedule, which is set to monthly transfer of the data.with kind regardsThomas

All,I’m looking for some guidance. There is a report that can be installed from the CV Store that claims to show “Active Jobs” and it does so, but only backup type jobs. Is anyone aware of a report like this but that shows Administrative type jobs as well? Essentially what I’d like to do is create a custom dashboard that would show any jobs that would be running in the job controller plus some other data/metrics. I want all this data to come from the Metrics Server’s CVCloud database. The table is there for the Admin jobs, so I know the data is there. I unfortunately don’t know anything about the report builder and/or MS SQL to build a customer report. It would be nice if this came as a canned report, but I haven’t found one. Thank you in advance for any and all guidance/input. Adam Davenport 

Hello, I’m trying to add an alert to my script, when a scheduler runs to send the output via email to the client.I want to configure this via command line.I searched in the documentation but didn’t seem to find any information about this.Does anyone know how to do this configuration? Kind regards,Jmiamaral

Is there any way we access Rest API without token ? because we just run the script on the local commvault computer and we don't want user + password in the plaintext ?Thank you

What this does is a discovery on a hypervisor sub client and creates a vm pseudo client for any discovered virtual machines.The functionality is outlined here:https://documentation.commvault.com/11.26/expert/104558_creating_vm_clients_before_performing_backup_operations.html In practice it looks like this.   Thanks!Chris

Well here is a good one…Is there a way to hide the inputs of a popup activity using java or javascript?     

Can anyone share the REST API call to update subclient content of virtual sever sub-client  ?Also what does this error means - Func[addVMToSubClient] Line[629]: status=401 content=u'<Api_GenericResp errorMessage="Access denied" errorCode="5" />'INFO:api.v1.services:status=401 content=u'<Api_GenericResp errorMessage="Access denied" errorCode="5" />'

Every now and then (perhaps once a year, usually soon after installing a feature release), I return to the challenge of writing reports in Commvault to report on current status consistent with the way I think. Is there a section of this community that deals with developing custom reports (and dashboards) in more abstract, theoretical ways?I don’t want to be told how to solve a very narrow, specific problem, let alone told of five reports that display similar data; I want to discuss the mechanics of, for example, how to link from one Commvault report, such as one that might sort data by subclient ID, to another Commvault report that displays information relevant to one specific subclient ID. Another time I might want to discuss the various data display widgets in the report writing tools. I try to use Books Online, but I’m almost convinced my brain works differently than the editors of Books Online, so I’m looking for an alternate perspective or resource to address some of those arcane

Hi All, Qscript in the link here started to fail randomly since yesterday for me..in both of our commcells..Could not understand why I have this issue, for fun sake I tried to copy paste from CV’s documentation, from -help section of qcommand - maybe after 5 months of succesfull everyday use somehow script decided for himself to mistype the command...lol - laughing through tears here when example in -help section in itself is faulty :) Same goes for API call, response code is ‘200’ - but in the response is one of CV generic resp codes, which is ‘2’.  def get_commvault_clients(self): """This method returns all servers with backups in past 24 hours from DK1 and DK2 commcells""" job_history = [] for api in self.api_url: jobs_request = api["url"] + "ExecuteQCommand" jobs_response = requests.post( jobs_request, headers=api["headers"], timeout=3600, data="command=qoperation execscript -s

Dear Community,Comcell: 11.24.23i want to created a workflow for the UseCase Mailbox User Offboarding. The Form should be trigger with smtp Mail Variable and create a Backup and Restores the Mailbox as .pst to a UNC Path. My big Problem here is that the Workflow doesnt understand the InstanceTyp → Exchange Mailbox there is no Q_xxx that suits for that in the List , when i try with Q_MSECH_MB the jobs goes in pending state with “Failed to enumarate iDataAgent…..”, there are only Q_MSEXCH for 2003,2k archiv,db available but nothing Office 365.Or he says that the Client has not installed the Module …. When you initiate a backup via GUI he uses as iDataAgent “Exchange Mailbox”. Is there anyone out there who managed to get a running workflow for Office 365 Mailbox Backup. Cheers,Thomas  

Hi Everyone I have been trying to get my head around Commvault’s PowerShell module and it runs so slow, not sure why. Has anyone else has faced the same issue? Below script returned 3676 objects and it took more than two hours: Get-Date$clients = Get-CVClient$subClientObjs = @()foreach ($client in $clients){ $subClients = Get-CVSubclient -ClientName $client.clientName -AllProperties foreach ($subClient in $subClients){ $subClientObj = [PSCustomObject]@{ 'clientName' = $subClient.subClientProperties.subClientEntity.clientName 'subClientName'= $subClient.subClientProperties.subClientEntity.subclientName 'backupSetName' = $subClient.subClientProperties.subClientEntity.backupsetName 'clientType' = $subClient.subClientProperties.subClientEntity.appName 'clientInstanceName' = $subClient.subClientProperties.subClientEntity.instanceName 'vmContents' = $subClient.subClientProperties.vmContent.children.displayName -jo

Would you ask the Commvault if they can increase the number of characters allowed in Commvault VSA subclient description field to 10,000 

We are looking to automate Commvault IDA agents Installation and client settings configuration such as encryption, dedupe , storage policy , filters , schedules , database subclient settings such as oracle home, path etc. .Does anyone has custom workflows deployed for agent installation and client configuration ? if yes please share .Also , what is recommended way of achieving this ?Is it possible to achieve 100% configuration for client through RestAPI ?