-
- Expert
- Posts: 109
- Liked: never
- Joined: Apr 02, 2013 7:55 am
- Full Name: Sum Wu
- Contact:
Veeam Enterprise Manager
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?
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?
-
- Product Manager
- Posts: 20415
- Liked: 2302 times
- Joined: Oct 26, 2012 3:28 pm
- Full Name: Vladimir Eremin
- Contact:
Re: Veeam Enterprise Manager
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.
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.
-
- Product Manager
- Posts: 20415
- Liked: 2302 times
- Joined: Oct 26, 2012 3:28 pm
- Full Name: Vladimir Eremin
- Contact:
Re: Veeam Enterprise Manager
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.
Thanks.
-
- Expert
- Posts: 109
- Liked: never
- Joined: Apr 02, 2013 7:55 am
- Full Name: Sum Wu
- Contact:
Re: Veeam Enterprise Manager
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?
-
- Veeam Software
- Posts: 21139
- Liked: 2141 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: Veeam Enterprise Manager
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.
-
- Product Manager
- Posts: 20415
- Liked: 2302 times
- Joined: Oct 26, 2012 3:28 pm
- Full Name: Vladimir Eremin
- Contact:
Re: Veeam Enterprise Manager
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:
Hope this helps.
Thanks.
• 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;
Thanks.
Who is online
Users browsing this forum: Bing [Bot] and 88 guests