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
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?
Best answer by GseibakView original
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.
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?
yes its possible to add a post process command to a backup or restore job which could trigger a report.
you can also schedule the report to run like once/week as well
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.