Monitoring and reporting for Veeam Backup & Replication, VMware vSphere and Microsoft Hyper-V
Post Reply
douglas.fernandes
Novice
Posts: 7
Liked: never
Joined: Aug 23, 2017 5:37 pm
Full Name: Douglas Fernandes
Contact:

Tape Report Monthly

Post by douglas.fernandes » Feb 08, 2019 2:08 pm

Scenario

We have a tape job that backup all Vms monthly, this jobs are records at 10 tapes and after this all tapes are send to Iron Mountain to be archieved.

Problem:
The report called “Tape Backup” don’t show all content at the tape.

I don’t have a report that inform the content of Tape Id  Ex.: “Which VMs were backuped at Jully-2018 that are at the TAPE id 0001 or Where is the VM01 of the backuped at Jully-2018 ”

If one day I need make a restore at this VM01 for example, that is a this archived tape at Iron Mountain i cant find this and I need bring all tapes at my site again to find this VM01

Someone can inform me if this report exist?

If no is possible be do trough SQL Query?

Regards

Douglas Fernandes
Banco Original Brasil

Shestakov
Veeam Software
Posts: 6501
Liked: 628 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Tape Report Monthly

Post by Shestakov » Feb 09, 2019 12:10 pm

Hello Douglas and welcome to the community!
Have you checked drill-down report in “Tape Backup”?
Under the monthly job click on number of backed up in "VMs and Computers" column for the desired job.
You can also check which tape jobs backup VM in VMs with no Archive Copy and Custom Backup Data reports.
Thanks!

douglas.fernandes
Novice
Posts: 7
Liked: never
Joined: Aug 23, 2017 5:37 pm
Full Name: Douglas Fernandes
Contact:

Re: Tape Report Monthly

Post by douglas.fernandes » Feb 11, 2019 4:28 pm

Hi Shestakov thanks for your help, but:

These reports do not show the information we need.

The VMS without a file copy has a limitation on programming because it only shows "Monthy or Current Quarter" if you need to filter more than this period as January 2017, and in the media column show only "Media Set Name" not Media ID where the VM was registered.

In the Custom report, we can not merge different types of "Backup type + virtual machine" objects to create all the information needed to provide my reports.

I think that for me the best solution be using Reporting Service "https://helpcenter.veeam.com/docs/one/r ... l?ver=95u4" to create my custom reports.

Best regards again

Douglas Fernandes
Banco Original Brasil

Shestakov
Veeam Software
Posts: 6501
Liked: 628 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Tape Report Monthly

Post by Shestakov » Feb 11, 2019 6:01 pm

And what about the drill-down report in “Tape Backup”?
It should show what you need.
In the Custom report, we can not merge different types of "Backup type + virtual machine" objects to create all the information needed to provide my reports.
You can combine them with the Report builder.
Thanks!

douglas.fernandes
Novice
Posts: 7
Liked: never
Joined: Aug 23, 2017 5:37 pm
Full Name: Douglas Fernandes
Contact:

Re: Tape Report Monthly

Post by douglas.fernandes » Feb 12, 2019 4:12 pm

Below I showed an example how we need this report to created to use at the future or for audit.

I tried to do it at the Report Builds without success


Backup / Date TAPE ID MEDIA SET SEQUENCE # JOB_NAME VM_SERVER_NAME VM_SERVER_FILE
January /2018 O0012 Media Set Mensal $ 01 01/02/2019 1 Job Backup Windows 01 SERVER01 SERVER01.vm-762858_7D1CD2018-02-02T023148.vbk

January /2018 O0012 Media Set Mensal $ 01 01/02/2019 1 Job Backup Windows 01 SERVER02 SERVER02.vm-762858_7D1CD2018-02-02T023148.vbk

January /2018 O0012 Media Set Mensal $ 01 01/02/2019 1 Job Backup Windows 01 SERVER03 SERVER03.vm-762858_7D1CD2018-02-02T023148.vbk

January /2018 O0012 Media Set Mensal $ 01 01/02/2019 1 Job Backup Windows 01 SERVER04 SERVER04.vm-762858_7D1CD2018-02-02T023148.vbk

January /2018 O0013 Media Set Mensal $ 01 01/02/2019 1 Job Backup Windows 01 SERVER05 SERVER05.vm-762858_7D1CD2018-02-02T023148.vbk

January /2018 O0013 Media Set Mensal $ 01 01/02/2019 1 Job Backup Windows 01 SERVER06 SERVER06.vm-762858_7D1CD2018-02-02T023148.vbk

January /2018 O0013 Media Set Mensal $ 01 01/02/2019 1 Job Backup Windows 01 SERVER07 SERVER07.vm-762858_7D1CD2018-02-02T023148.vbk

January /2018 O0013 Media Set Mensal $ 01 01/02/2019 1 Job Backup Windows 01 SERVER08 SERVER08.vm-762858_7D1CD2018-02-02T023148.vbk


Regards again
Douglas Fernandes
Banco Original

Shestakov
Veeam Software
Posts: 6501
Liked: 628 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Tape Report Monthly

Post by Shestakov » Feb 12, 2019 5:10 pm

Thanks for the explanation.
Does "Mensal" mean monthly?

By the way, do you use GFS Media pools? If so, have you checked Tape GFS Backup Files report?

douglas.fernandes
Novice
Posts: 7
Liked: never
Joined: Aug 23, 2017 5:37 pm
Full Name: Douglas Fernandes
Contact:

Re: Tape Report Monthly

Post by douglas.fernandes » Feb 12, 2019 5:16 pm

No I dont use GFS Media Pools at the moment.

Shestakov
Veeam Software
Posts: 6501
Liked: 628 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Tape Report Monthly

Post by Shestakov » Feb 13, 2019 3:33 pm 2 people like this post

I've got your request and it's taken into account for future releases.

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests