Discussions related to exporting backups to tape and backing up directly to tape.
Post Reply
maryindc
Lurker
Posts: 2
Liked: never
Joined: Jun 03, 2019 3:46 pm
Contact:

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

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

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

Post by 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
Lurker
Posts: 2
Liked: never
Joined: Jun 03, 2019 3:46 pm
Contact:

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

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

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

Post by veremin »

I cannot promise you anything at the moment, but consider your voice for PS tape enhancements counted. Thanks!
dussan
Novice
Posts: 5
Liked: never
Joined: Apr 23, 2020 6:51 pm
Full Name: Dušan Pirc
Contact:

[MERGED] List files on tape

Post by 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
Veteran
Posts: 1143
Liked: 302 times
Joined: Apr 27, 2020 12:46 pm
Full Name: Natalia Lupacheva
Contact:

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

Post by Natalia Lupacheva »

Hi Dušan,

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

Thanks!
dussan
Novice
Posts: 5
Liked: never
Joined: Apr 23, 2020 6:51 pm
Full Name: Dušan Pirc
Contact:

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

Post by 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.
Product Manager
Posts: 14396
Liked: 1568 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

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

Post by Dima P. »

Hello Dušan,

VeeamOne does not have a detailed report for files on tape, only for backups. Sorry for the confusion!
dussan
Novice
Posts: 5
Liked: never
Joined: Apr 23, 2020 6:51 pm
Full Name: Dušan Pirc
Contact:

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

Post by dussan »

OK, but is there any way to get list of files on tape...
Dima P.
Product Manager
Posts: 14396
Liked: 1568 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

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

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

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

Post by veremin »

You can try the SQL queries mentioned here. Thanks!
Post Reply

Who is online

Users browsing this forum: No registered users and 23 guests