Solved

Wanted report for database restores


Userlevel 4

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

icon

Best answer by Gseibak 29 June 2022, 18:48

View original

3 replies

Userlevel 4
Badge +10

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

Userlevel 4

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

Userlevel 4
Badge +10

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