Case # 03514913 Report: tape barcode and .vbk files on tape

[maryindc]

Case # 03514913 Report: tape barcode and .vbk files on tape

I'm the Sys Admin I at a local university who takes care of the weekly tape jobs. We do production and non-production disk-to-tape of synthetic backups on Sundays.

Currently, If I want a list of what .vbks got written to a tape (to make sure no jobs got missed) or to make a report, I perform this task
- Go to the Veeam Console | Tape Infrastructure | Libraries | Media | Online | double-click tape | select the files tab | expand servername | expand backup repository | expand backup-to-disk job | view .vbks on this individual tape | type them into a spreadsheet.

I'm trying to get a report listing
- the barcode of a tape
- Name of .vbk files on this barcoded tape

Initially, I assumed it could just query the tape catalog using Powershell, but the command is deprecated. I opened Case # 03514913 with veeam and they suggested I post to the forum.

Here are my efforts so far to get this report, so far

Veeam Powershell
- I found some posts on the forum, but the posts are from 2014 and refer to a powershell command that is now defunct - get-VBRTapeCatalog
o tape-f29/tape-inventory-job-t18560.html
- If I look at the current powershell commands for Veeam, I can't find a command that queries the tape catalog.
- Is there some other way to query the tape catalog using Powershell?

Veeam One Reporter
- The report “Tape Backups” the “vms/Computers” column has a “1” in it but not the host names of our VMs. This isn’t useful since it doesn’t list the vm backups on each tape

Veeam Management Enterprise Manager
- Haven’t found any reports here that list tape barcodes and .vbks on that tape


Logs
- I also tried finding the tape barcode and associated .vbk files in the logs
- I checked the log files in
- C:\ProgramData\Veeam\Backup
- but couldn’t find what I was looking for.

Thanks Mary

[veremin]

The report “Tape Backups” the “vms/Computers” column has a “1” in it but not the host names of our VMs. This isn’t useful since it doesn’t list the vm backups on each tape

The referred number is hyperlink, can you try to click on it to drill down to the list of VMs and computers archived to the tape? Thanks!

[maryindc]

Vladimir:

Thanks for your comment, I found a report that works for me!

While the Veeam ONE "Tape Backups" report was very time consuming for me to click the hyperlinks, the Veeam ONE "Tape GFS Backup Files" worked for me.

With the "Tape GFS Backup Files" I can run a preview | Go to Page 2 | look for the tape barcode used in our weekend "disk-to-tape" backups under the "Tape ID" column | locate the past weekend's date in the "Restore Point Date" column | click on the hyperlink | download the resulting report in Excel | sort by date | grab the last weekends dates | copy and paste this info into a spreadsheet.

The output looks similar to this and gives me what I wanted - .vbk server name and tape barcode.

Virtual Machine/Computer Weekly media set 5/26/2019 12:12 AM
SERVER-1 000277L6
SERVER-2 000277L6
APPPROD-1 000278L6
APPPROD-2 000277L6

Still, if Veeam could create a PowerShell Cmdlet that outputs the above or revive the deprecated Find-VBRTapeCatalog, that would be awesome.

Thanks Mary

[veremin]

I cannot promise you anything at the moment, but consider your voice for PS tape enhancements counted. Thanks!

[dussan]

Hello

Is there a report of files which are saved on tape. On “properties” of tape there is a tab “Files” where files on tape are listed. Is there a way to get this list?

lp, Dussan

[Natalia Lupacheva]

Hi Dušan,

moved your post to the existing thread.
Does the suggested report meet your requirements?

Thanks!

[dussan]

In Veeam One I try all the »tape« records but none list files of »File to Tape Backup« to »normal« Media Pool (not GFS media pool).

I looked into reports in menu "Reports --> Backup Jobs" and "Reports -->Tape". In “Reports --> Tape” is “Tape GFS Backup Files” but it works only on GFS media pools. In this report you really get files when open hyperlink.

But like I said – it is not working with “normal” media pools which I use.

[Dima P.]

Hello Dušan,

VeeamOne does not have a detailed report for files on tape, only for backups. Sorry for the confusion!

[dussan]

OK, but is there any way to get list of files on tape...

[Dima P.]

Dušan,

From the top of my head only via PowerShell script. I've asked PS team to check if that's possible and share their feedback with you. Cheers!

[veremin]

You can try the SQL queries mentioned here. Thanks!