Developer Tools, Integration and Automation

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?

ÜbersetzenHello,I want to automatically write data from reports into a Word document. For example, the number of failed jobs from the backup-job-summary report should be written to a Word document. Is there already a workflow for this or does anyone have an idea how to implement it?

I am sending a  get call from POSTMAN Client to get the backup job summery report for last 24 hrs. it retiring a error with Status: 400 bad request.Followed the below procedure to get the REST API linkLogged in into webconsole→ Report → backup summery report → removed some unwanted fields → click on REST API & copy the link. On Postman client generate the token, create a new HTTP request -pest the link, & pest the token → hit send  I am getting 400 bad request  I can able execute all Commvault REST API - Public -SP24 Commands.

Hi guys! I’m completely new to REST API.I just downloaded the Postman CommVault Rest API Workspace and now I’m trying to start with the basic: authentication. But let’s get one step back to the Swagger UI. Just to exclude any wrong configuration inside Postman. I created a new test user inside the CommCell. This user is member of “master” group, so permissions should not be a problem. If I visit the Swagger UI (https://<webserver>/webconsole/sandbox/apiexplorer) and try the POST Login with this test user I get the message: errLogMessage": "Username/Password are incorrect"Well I’m pretty sure the username and the password is correct. I also tried to encode the password with Base64, but get the same error message. Other users also didn’t work. Also I can see a “Authorize” button on the top right corner. When I click on this button I can provide a Authtoken. But where I get this from? Obviously I’m doing something wrong here. Please tell me what. 

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

I was trying to google some of the internal workflow entity information and I started to realize that Java itself provides a way of implementing workflows and that there are several third party workflow activity engines. That is to say a way to work on the workflows at a slightly lower level where the XML of the workflow is edited directly. The reason I ask is that I am looking for a way to manage not only the workflows but different reusable bits of the workflows like common SQL queries and custom bits of code for building java objects.If there is a third party engine in use then it becomes much easier to manager these elements. Thanks.Chris.

Hi Team,For trigerring of the File Anomaly alerts is there a specific threshold value for that. Or do we have any additional setting or setting that  we can mention a threshold value to trigger the alerts.Ex: Only when files modified or created or any activity are more then 10000, then only I should receive File Anomaly alert. Please let me know if we have any setting that we can limit this.

Activate users, Assemble!!I noticed that I typically add 1 or 2 systems to projects in activate at a time. IS there a way to batch add or use grouping to complete a mass entry?

Full job runs, I want to start transaction log job schedule or job to run only if and when job finishes. Job can run between 8 and 24 hrs.

Hi Gurus,I am looking for a solution that would allow us to use our sandbox Commcell to act as a repository for our Custom workflows. The idea is we would develop all workflows in the sandbox and when complete deploy them to the production Commcells.Is anyone aware of any out of the box software that would do this, or are we better off writing a custom workflow to do the job? I am interested in what other people are using to accomplish this, if at all.Regards

Is there any way to get the loop index and counter in any of the for loop activities?I have been setting a counter variable prior to the loop starting and incrementing it at the end of every loop, but surely this already exists.  Also I get wonky results when I allow loops to run multiple processes at once.   

Hi,I have create a dayly restore workflow.For documentation I need the Restore Report.But this Value seems not available in the Workflowengine.can I get it?I only recieve the JobID from the Workflow itselfe(xpath:{/workflow/system/jobId})How do I get the jobID from the initiated Job?ThanksregardsEckehard

I find that workflows become incomprehensible due to the logging of “starts” and “loops” when in reality the changes in phase don’t capture useful information.Is there a way to manually add and update phases in the workflow? Thanks.Chris.

I am trying to determine the correct REST API “get” to list all VM clients (guests) being protected. Maybe I am missing it or it’s more difficult than I think. I can list all VM hosts, VSAs, datastores, etc, but I just need a list of VMs being backed up. Any help would be greatly appreciated!Thanks!

Hello,I use the REST API to read via Python the protection report (XML).Now the output of this report describes first the columns and in the next session the records.  I use normally xml.etree.ElementTree, to read xml contend, but for this looks not useful, what is the easiest way to get this formatted output in dict or in a list. sorry i am new in python scripting.regards Jürgen 

Hi,We are gradually automating our infrastructure (IaC) and need to automate the installation and configuration of CommVault Media Agents. Any good resources on that subject here or elsewhere? We also want to deploy a Media Agent on a Windows device in Azure order to backup a datalake (ADLS Gen2). So, the Media Agent needs to be configured with an ADLS Gen2 for it’s library. Any automation/scripting tips on that?

This is simple but working trick to maintain Commvault.Via Workflow built-in activity "ExecuteScript", you can call arbitrary shells (both on Windows/Linux) remotely.If you have full access to the remote server and able to place scripts, or if the script can be called via Workflow, no issues.But if you'd like to modify the script remotely for OS-side schedule jobs (Task Scheduler or crontab), it's slightly difficult to control this process remotely, since Commvault can restore the script but not so easy to modify the content itself.If the script contains only text data, you can utilize echo command to put contents remotely, one trick required though since arbitraryTo achieve this,First, prepare any scripts you want to put remotely (this is modified version of .bat file generated via Save as Script):Next, pass the generated script to the following logic, which "escapes" all strings per OS type:String text = <original script>;String osType = <Windows or Linux>;// Generate ech

This is simple but working trick to maintain Commvault.Backup jobs might fail at night and you'd like to find out the cause of errors, you need to collect log bundles in the first place.But when you realize the errors after a while (say couple of days later), job logs might be rolled over, important information which would contain the error messages gone.To avoid this situation, you can setup various alerts, collect logs immediately after you receive any.This also cumbersome so you can introduce simple workflow which can be called at the same timing of alert, also collect logs automatically.Rough process as follows: Generate an answer file for "Send Log Files". This procedure is utilizing Save as Script, which can be saved most of user operations with parameters, generates .bat file and XML file. The latter is called Answer file which contains the actual operaiton parameters in single file. To export this, you can start "Send Log Files" process from CommCell Console: Then you're getti

I need to access a some information at the beginning of the workflow, specifically I need to do a query on the fly in order to populate some dynamic form fields. In order to do this I think there are two options. The first is option is to instantiate the CommserveDBquery class and use the output, I was able to find the class definition but a few things are not clear. The following screenshots will hopefully make it clear. This a is screenshot of the class definition, the assumption being that the fields that needs to be populated are “CommCell” , and sql.  This is the code I came up with to do it.  You can see that the things I don’t know how to define is “resultset” and “activitycontext”, this makes since typically within the workflow “activity” is contextual so executing an activity that is not connected to the workflow would need to be populated.   The second option is to have an activity defined with the fields pre-populated. Like this: The issue in this instance is I have absolu

When running the Load Balance Index Servers workflow, are there any precautions to take into consideration? Should any of the services on the main CommCell be suspended?  Should this be done when there is a window where there are no jobs running? What is the best practice before running this workflow?

Hi team,BY any way can i get an consolidated audit trail report from all my Commserver ? I don't want to run and download audit trail report from each Commserver.Regards, Mohit

Hi, I’m trying to record answer file for Commserve Active and Passive unattended installation. Unfortunately when I create custom package for CS with Failover it doesn’t ask whether it’s for Active or Standby Commserve, so the answer file I got allows me only to install Active Commserve. Is it possible to create answer file for Stanby Commserve installation? 

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

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 All, I s there any automation that can be done to delete retired clients after say 28 days.