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.

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.