I believe you can also use the TSM ODBC to create a spreadsheet
query for this among other queries if I am not mistaken.

Richard Sims wrote:

> On Jan 10, 2006, at 1:29 PM, Vats.Ashok wrote:
>
> > We have primary pool and offsite pool. We run backup from primary
> > to offsite pool everyday using cron. I was wondering what is the
> > best practice to copy primary to offsite pool ? Also how do I
> > compare the two pools to see if offsite is caught up with primary.
> > Typically I use q * * stg=primarypool & q * * stg=offsitepool but
> > it takes a long time to run these commands & compare the output.
>
> If the primary pool is backed up only to that offsite copy storage
> pool (and not also an on-site copy storage pool), you can do 'select
> * from auditocc', which is nearly instantaneous.
>
>    Richard Sims     http://people.bu.edu/rbs