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?
![](https://uploads-eu-west-1.insided.com/commvault-eu/attachment/ed3c1bc3-828a-4901-83cd-c3c86d4fba25.png)
![](https://uploads-eu-west-1.insided.com/commvault-eu/attachment/9bc5ae0c-0e4a-4b66-9572-60c48361aa4b.png)
![](https://uploads-eu-west-1.insided.com/commvault-eu/attachment/8ce53cd4-dce6-48be-9899-c6ab087b9aac.png)
Best answer by Jason Duncan
View originalI 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?
Best answer by Jason Duncan
View originalEduardo 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.
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.