Comprehensive data protection for all workloads
Post Reply
rdixon01
Influencer
Posts: 24
Liked: 2 times
Joined: Oct 09, 2013 2:30 pm
Full Name: Rick
Contact:

Veeam SQL Database Schema

Post by rdixon01 » 1 person likes this post

Does anyone know where I can get a list of Veeams SQL Database schema. Looking for a schema map that tells you what is in each table.
What to build our own custom reports but need a list (Schema Map) that would list what you is in each table.

Thanks
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Veeam SQL Database Schema

Post by foggy » 1 person likes this post

Hi Rick, we do not publish Veeam B&R internal database schema. One of the reasons is that it changes from version to version, so should you come up with such a report, you'd need to update it with every new release.
veremin
Product Manager
Posts: 20271
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Veeam SQL Database Schema

Post by veremin » 1 person likes this post

If you're after custom reporting, take a look at PowerShell and capabilities it can propose; just one example. Thanks.
Zew
Veteran
Posts: 365
Liked: 80 times
Joined: Mar 17, 2015 9:50 pm
Full Name: Aemilianus Kehler
Contact:

Re: Veeam SQL Database Schema

Post by Zew »

I thought VeeamONE did reporting?
Mike Resseler
Product Manager
Posts: 8044
Liked: 1263 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Veeam SQL Database Schema

Post by Mike Resseler »

Zew,

VeeamONE does indeed do reporting and dashboards (and grows with each version :-)) but sometimes people want to create custom reporting.
@Rick: custom reporting/ dashboards can also be created with Veeam ONE but night be a bit more limited compared to what can be done with PowerShell as Vladimir mentioned

Cheers
Mike
Regnor
VeeaMVP
Posts: 934
Liked: 287 times
Joined: Jan 31, 2011 11:17 am
Full Name: Max
Contact:

Re: Veeam SQL Database Schema

Post by Regnor »

Hi everyone,

I'm also looking for a way to find/match the Veeam version from the SQL database.
The following KB contains a hint for the table "Version" but stops at 9.5U3a: https://www.veeam.com/kb1845
Would it be possible to publish the internal database schema or is there any other (SQL) way to find out the version/build number?
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Veeam SQL Database Schema

Post by foggy »

Hi Max, as mentioned above, we do not publish Veeam B&R internal database schema. Could you please clarify whether you're looking for the configuration database version number or the Veeam B&R build number?
Regnor
VeeaMVP
Posts: 934
Liked: 287 times
Joined: Jan 31, 2011 11:17 am
Full Name: Max
Contact:

Re: Veeam SQL Database Schema

Post by Regnor »

Hi Alexander, the goal would be to find out the Veeam B&R build number.
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Veeam SQL Database Schema

Post by foggy »

Then the mentioned KB is anyway irrelevant. You can get the Veeam B&R version/build number from the DLL properties using PowerShell, for example - would it be applicable?
Regnor
VeeaMVP
Posts: 934
Liked: 287 times
Joined: Jan 31, 2011 11:17 am
Full Name: Max
Contact:

Re: Veeam SQL Database Schema

Post by Regnor »

Is there no way to read the B&R Version from the database? I know that we could use Powershell for such tasks but in our case we need to query the database.
PetrM
Veeam Software
Posts: 3229
Liked: 520 times
Joined: Aug 28, 2013 8:23 am
Full Name: Petr Makarov
Location: Prague, Czech Republic
Contact:

Re: Veeam SQL Database Schema

Post by PetrM »

Hi Max,

Could you please clarify why do you need to use the database as a source of data? Normally, all necessary information can be obtained via PowerShell or REST API.

Thanks!
zaicnupagadi
Novice
Posts: 9
Liked: 1 time
Joined: Nov 03, 2017 6:02 am
Full Name: Pawel Jarpsz
Contact:

Re: Veeam SQL Database Schema

Post by zaicnupagadi »

Refreshing the subject - the thing is we for instance got like multiple VeeamZIP files. Some of them might have expiration applied, but some might not. We would like to list these where expiration hasn't been applied and ask relevant people whether we can remove the ZIP files as we are slowly getting out of space on VeezmZIP partition. Here I saw that it can be visible only in the DB veeam-backup-replication-f2/veeamzip-vi ... 58986.html any idead how to find information we are looking for?
zaicnupagadi
Novice
Posts: 9
Liked: 1 time
Joined: Nov 03, 2017 6:02 am
Full Name: Pawel Jarpsz
Contact:

Re: Veeam SQL Database Schema

Post by zaicnupagadi » 1 person likes this post

Image
PetrM
Veeam Software
Posts: 3229
Liked: 520 times
Joined: Aug 28, 2013 8:23 am
Full Name: Petr Makarov
Location: Prague, Czech Republic
Contact:

Re: Veeam SQL Database Schema

Post by PetrM »

Hi Pawel,

My apologies, I overlooked your question:) If you go to Backups - Disk (VeeamZip) - right click on backup - Properties and the last column "Retention" in the table will show the expiration date.

Thanks!
zaicnupagadi
Novice
Posts: 9
Liked: 1 time
Joined: Nov 03, 2017 6:02 am
Full Name: Pawel Jarpsz
Contact:

Re: Veeam SQL Database Schema

Post by zaicnupagadi »

Hi @PetrM ok I can see it!

I do not see it for some backups though - I understand that if I do not see retention for them - there is no retention applied?

Cheers,
Pawel
wishr
Veteran
Posts: 3077
Liked: 453 times
Joined: Aug 07, 2018 3:11 pm
Full Name: Fedor Maslov
Contact:

Re: Veeam SQL Database Schema

Post by wishr »

Hello Pawel,

Yes, if the column is not there, that means there is no retention applied to this VeeamZip backup.

@Regnor, you can obtain VBR version from VONE v11 ;).

Thanks
Post Reply

Who is online

Users browsing this forum: Baidu [Spider] and 187 guests