Comprehensive data protection for all workloads
Post Reply
sumwu
Expert
Posts: 109
Liked: never
Joined: Apr 02, 2013 7:55 am
Full Name: Sum Wu
Contact:

Veeam Enterprise Manager

Post by 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
Product Manager
Posts: 20415
Liked: 2302 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Veeam Enterprise Manager

Post by 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
Product Manager
Posts: 20415
Liked: 2302 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Veeam Enterprise Manager

Post by veremin » 1 person likes this post

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
Expert
Posts: 109
Liked: never
Joined: Apr 02, 2013 7:55 am
Full Name: Sum Wu
Contact:

Re: Veeam Enterprise Manager

Post by 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
Veeam Software
Posts: 21139
Liked: 2141 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Veeam Enterprise Manager

Post by 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
Product Manager
Posts: 20415
Liked: 2302 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Veeam Enterprise Manager

Post by veremin » 1 person likes this post

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.
Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 88 guests