Thanks for reminding me about this, I had completely forgotten. At the
time, the customers wanted per-directory stats so it wasn't an option for
us.

On Fri, Apr 22, 2016 at 10:11:27AM -0400, Zoltan Forray wrote:
> 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

--
-- 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