I need help to produce a query to return a list of Orphaned Media (LTO tapes) with condition equals to Bad/Good. Which database and which table should I use?
Answer
Query to return list of Bad Orphaned Media
Best answer by Jason Duncan
Eduardo Braga it should be in the MMMedia table. I would have to check further for the flags, but if you run select * from mmmedia and look for the orphaned barcodes you have, and some of properties columns, it should be clear.
+23- Vaulter
There’s a CommCell view that contains this:
https://documentation.commvault.com/2022e/expert/5540_commcellmediainfo_01.html
I’m not sure which table contains it, though you’d need to join a few to get all of the details whereas this view gives you everything in a detailed package.
- Vaulter
- Answer
Eduardo Braga it should be in the MMMedia table. I would have to check further for the flags, but if you run select * from mmmedia and look for the orphaned barcodes you have, and some of properties columns, it should be clear.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.