Skip to main content
Solved

Wanted report for database restores


Hello Commvault Community,

 

I am looking for a report that will help me extract information in an easy and comfortable way (for example during the audit), where I can see what, when and where was restored database, similar to those virtual machines (VM Restore Details Report). If it matters, I mainly care about reports that include SQL Server databases.

 

VM Restore Details
https://cloud.commvault.com/webconsole/softwarestore/#!/135/661/16848

 

Is such a report available somewhere? I searched all available at cloud.commvault.com/reports and unfortunately I didn’t find and now I don’t know if I need to create a ticket in Commvault support with CMR or maybe I can find something similar somewhere?

 

Thanks&Regards,
Kamil

Best answer by Gseibak

Hi @Kamil 

yes its possible to add a post process command to a backup or restore job which could trigger a report.

https://documentation.commvault.com/11.24/expert/12761_pre_processes_and_post_processes_advanced.html

 

you can also schedule the report to run like once/week as well 

https://documentation.commvault.com/11.24/essential/39297_scheduling_reports_on_web_console.html

and save that as a script to use later in a post process but would need to pass in the variables. - https://documentation.commvault.com/11.24/expert/45335_generating_reports_using_command_line_interface.html

 

it might be better to create a client group with the clients that are used for restore and then run a report against that client group. not sure how often you run these restores. 

View original
Did this answer your question?

3 replies

Forum|alt.badge.img+11
  • Vaulter
  • 118 replies
  • June 23, 2022

Hi Kamil,

this report should suffice. Its a metrics server report so you will need the metrics reporting server if you don’t already have one. 

You can filter the report based on Agent.

https://cloud.commvault.com/webconsole/softwarestore/#!/135/660/10412


  • Author
  • 143 replies
  • June 29, 2022

Hello @Gseibak ,

 

I checked the report you proposed again and it didn’t fully reflect what I expected.

 

However, I was able to get most of the information from the Job Summary Report for the Restore jobs.

 

Now I have a question for you, are we able to create a schedule that will automatically generate a Job Summary Report after each Restore task performed in the environment? Can it be done using the schedule?

 

Rgrds,
Kamil


Forum|alt.badge.img+11
  • Vaulter
  • 118 replies
  • Answer
  • June 29, 2022

Hi @Kamil 

yes its possible to add a post process command to a backup or restore job which could trigger a report.

https://documentation.commvault.com/11.24/expert/12761_pre_processes_and_post_processes_advanced.html

 

you can also schedule the report to run like once/week as well 

https://documentation.commvault.com/11.24/essential/39297_scheduling_reports_on_web_console.html

and save that as a script to use later in a post process but would need to pass in the variables. - https://documentation.commvault.com/11.24/expert/45335_generating_reports_using_command_line_interface.html

 

it might be better to create a client group with the clients that are used for restore and then run a report against that client group. not sure how often you run these restores. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings