Report for Changing Tapes - Library to Vault

[TimLawhead]

Hello All,

I was unable to find any report or method to easily create something that would make changing tapes from the vault to the tape library an easier task.

I have a 24 tape Auto-loader library. I am looking to generate a report that would show the oldest 24 tapes in a specified pool/vault, preferably expired, and sorted by age and then barcode, and then show the current tapes in the library with their pool and capacity information.

If I could print off a quick one page that lets me quickly determine how many tapes I'm changing out of a library and then go to the vault and get the oldest expired tapes from the pool, and then be able to identify the tapes that aren't getting changed out, it'd save some time rather than having to hand write/type up a list to take with me.

Like so:
Expired Free Pool Current Library Capacity Pool
1: 0001111L6 1: CLNU101L0 ? None
2: 0001112L6 2: 0001101L6 0 Standard Media Pool
...
24: 0001124L6 24: MA2345L6 0 GFS Media Pool

TIA
Tim

[veremin]

Not sure whether I got your question, but from what I could understand:

- You need to query a vault: Get-VBRTapeVault
- Get tapes stored in it: $Vault.Medium
- Get tapes that are expired, using IsExpired property as a filter
- Sort them based on the ExpirationDate property
- Get tapes stored in the library
- etc.

Thanks!

[TimLawhead]

How do you get a list of the tapes and what slots they are in of a tape library?

Pretty sure I'm missing something.

I can see the Medium using Get-VBRTapeMedium but I'm not seeing how to get what slot they are in the library.
I can see the Tape Library using Get-VBRTapeLibrary but I'm not seeing how to list out what is in its slots.

[jhoughes]

Use it as the input for the library parameter in the Get-VBRTapeMedium cmdlet, the tape medium should have those properties listed out (as far as I can remember - I don't have a tape library in my lab currently to confirm).

[TimLawhead]

Made some headway using Select -ExpandProperty Location
Get-VBRTapeMedium -Library "LibraryName" | select barcode,location -ExpandProperty location | FT -AutoSize

This returned:
Barcode Location DriveId DriveAddress LibraryId SlotAddress VaultId Type

SlotAddress is what I needed. A search for that comes up with another forum post that helps:
powershell-f26/v8-tape-media-locations-t28031.html

From that I've got an initial pull from the Library that will give me the data I need to work with to determine what tapes need to be pulled:
Get-VBRTapeMedium -Library "LIBRARY-NAME-HERE"| Where-Object {$_.Location -like "Slot"} | Sort-Object {$_.Location.SlotAddress} | Select-Object -Property @{N="SlotNo";E={$_.Location.SlotAddress +1}}, @{N="Barcode";E={$_.Barcode}},Free,IsExpired,MediaSet | FT -AutoSize

Now to work out the rest.