Per this document, IBM's suggestion/recommendation is to perform EXPORT
NODE <node_name or *> FILED=BACKUPActive PREVIEW=YES

http://www-01.ibm.com/support/docview.wss?uid=swg21267260

On Fri, Apr 22, 2016 at 10:00 AM, Skylar Thompson <skylar2 AT u.washington DOT 
edu>
wrote:

> If you have access to the clients, you can use QUERY BACKUP and parse the
> A/I column.
>
> Honestly, though, when we've gotten this query, I've managed to push this
> back on the customers; it's not TSM's problem what's active or inactive,
> it's the customers' applications that are actually responsible for it.
> Obviously you need a pretty good relationship with your customers to make
> that case, but in the end it's caused our customers to think more carefully
> about workflow in general.
>
> On Fri, Apr 22, 2016 at 01:51:20PM +0000, Lee, Gary wrote:
> > Just got a request for the amount of active versus inactive data on our
> tsm servers.
> >
> > Is there a better way than traversing the backups table and summing?
> > That would be a mighty long query.
> >
> > We have three servers, and approximately 300 clients about 200 tB total
> data.
> >
> > Thanks for any suggestions.
>
> --
> -- Skylar Thompson (skylar2 AT u.washington DOT edu)
> -- Genome Sciences Department, System Administrator
> -- Foege Building S046, (206)-685-7354
> -- University of Washington School of Medicine
>



--
*Zoltan Forray*
TSM Software & Hardware Administrator
Xymon Monitor Administrator
VMware Administrator (in training)
Virginia Commonwealth University
UCC/Office of Technology Services
www.ucc.vcu.edu
zforray AT vcu DOT edu - 804-828-4807
Don't be a phishing victim - VCU and other reputable organizations will
never use email to request that you reply with your password, social
security number or confidential personal information. For more details
visit http://infosecurity.vcu.edu/phishing.html