Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

DPM 2010 Tape List

Posted on 2011-03-22
4
Medium Priority
?
2,812 Views
Last Modified: 2013-06-10
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!
0
Comment
Question by:rhenry-ez
  • 2
  • 2
4 Comments
 
LVL 7

Expert Comment

by:PowerToTheUsers
ID: 35198033
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
 
LVL 1

Author Comment

by:rhenry-ez
ID: 35198248
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
 
LVL 7

Accepted Solution

by:
PowerToTheUsers earned 2000 total points
ID: 35198468
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
 
LVL 1

Author Closing Comment

by:rhenry-ez
ID: 35198659
Knowing the right table to look in gave me my answer. Thanks!
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ready to get certified? Check out some courses that help you prepare for third-party exams.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question