DPM 2010 Tape List

I have a DPM 2010 server that i have recently recreated almost all of the protection groups on. The issue I am having is that there is not a report that gives me a list of all tapes and their expiry dates. Basically the problem i have is that many of the tapes that are currently in my offsite are good working tapes that have expired data but DPM will never tell me to bring those back because i deleted their protection groups.

In short, i need a list of all the tapes that DPM is currently using for my current protection group, that way i can take any tapes its NOT currently using back to be used again. Im hoping this can be done using an SQL query or Powershell script

Thanks!
LVL 1
rhenry-ezAsked:
Who is Participating?
 
PowerToTheUsersCommented:
Ah, to get the question right:
"many of the tapes that are currently in my offsite are good working tapes that have expired data but DPM will never tell me to bring those back because i deleted their protection groups."

So off-site you have a bunch of old, expired tapes from the old protection groups, mixed with a bunch of (expired and non-expired) tapes of the current protection groups? And you want a list of the first ones?
In the DPMDB, take a look at table tbl_MM_Media, I guess that will be part of your solution: in tht table are all tapes.
0
 
PowerToTheUsersCommented:
When you deleted the protection groups, did you select to expire the recovery points on tape? If so those tapes should be "over due", and you can list them: On the reporting tab, go to Tape management report and let it generate. On the first page(s) there's the list with off-site ready tapes, but on the next pages you should see a list with "over due tapes": those tapes contain expired backups.

If you didn't check the option to delete the recovery points on tape, you have two options:
* Retain those recovery points on tape. Tapes that still contain recovery points won't be listed in the Over Due-list.
* Expire them now: go to the protection tab, at the bottom is the list with "recovery points for previously protected data". Righclick on the items to delete recovery points and select expire recovery points on tape.
0
 
rhenry-ezAuthor Commented:
PowerToTheUsers,
I did expire the recovery points when i deleted the protection group. However, my Tape Management Report shows no overdue tapes at all, it is only showing the ready for offsite tapes and tapes due in the next 1 week (as expected of the current protection groups).
0
 
rhenry-ezAuthor Commented:
Knowing the right table to look in gave me my answer. Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.