Veeam Enterprise Manager

[sumwu]

Hi;

My customer want to have a consolidation view for the restore history. Do we have such report on the VeeamOne or Enterprise Manager or can I extract the data by SQL query?

[veremin]

Restores session can’t be tracked neither by Enterprise Manager nor by VeeamOne.

Custom PS script will also be only a part of solution, since only FullVMRestores can be captured by it, as mentioned here.

So, it seems that SQL query is the only option you have.

Hope this helps.
Thanks.

[veremin]

Additionally, it has been just confirmed that Veeam ONE v7 will have the report called “Restore Operator activity”, that will cover Full VM Restores, File Level Restores, and also Application-Item restores. So, stay tuned.

Thanks.

[sumwu]

Thanks for infomation for the Veeam One v7. If the customer want to use the SQL query, in the SQL database, which table and data field(name) can I get the following?

[foggy]

We do not generally support direct intrusion into our database as the schema tends to change from version to version. However, you can find some information on these forums, for example in this thread.

[veremin]

As far as I know, you can get all restore sessions from [VeeamBackup].[dbo].[ReportFilteredSessionsView]. The only thing that needs to be specified is [job_type]:

• 4 - FullVMRestore
• 10 - FileLevelRestore
• 11 - LinuxFLR
• 12 - InstantVMRecovery

So, the following example is likely to meet your expectations. It's responsible for catching those sessions which type equal to the abovementioned numbers:

Code: Select all

SELECT TOP 1000 [id]
 ,[job_name]
 ,[state]
 ,[creation_time]
 ,[end_time]
 ,[job_type]
 FROM [VeeamBackup].[dbo].[ReportFilteredSessionsView] 
 where [job_type] = '4'
 or [job_type] = '10'
 or [job_type] = '11'
 or [job_type] = '12'
 order by [creation_time] desc;

Hope this helps.
Thanks.