I have been painstakingly providing a couple of our customers with media forecasts for the next twelve months, based on the usual suspects ..... tapes written to fulls, number of fulls required according to extended retention settings etc etc.
One of many pain-in-the-*** tasks if weeding out tapes with the longest retention, usually seven years or even indefinite.
The trouble I have, is that there is no easy way of identifying this, as 'extended retention' groups, weekly, monthly and half-yearly\yearly all together.
I am not interested in weekly or monthly, coz those tapes return to scratch, but the seven year and infinite are effectively lost to the world of scratch tapes for good.
As the reports can't help me on this (I have pored over them), and nothing in the GUI that I have seen can help either, I was wondering if anyone knew any SQL commands and on which tabels that could weed this information out.
Once I can identify these tapes, I can exclude from numbers returning to scratch and finally provide an accurate figure on estimated tape shortfalls for the coming 12 months.
I know that under the bonnet, all the fancy stuff can be acheived at SQL level ..... but I'm not familiar enough on how to code the SQL query myself.
Help appreciated as usual ...an interesting issue indeed.