Query to return list of Bad Orphaned Media

  • 12 September 2022
  • 2 replies

Userlevel 2
Badge +9

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? 





Best answer by Jason Duncan 12 September 2022, 21:38

View original

2 replies

Userlevel 7
Badge +23

There’s a CommCell view that contains this:

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.

Userlevel 1
Badge +6

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.