Great to see you back, Richard.

Not to quibble with the guru, but --
a: how do you know the volume name?
b: query content? Won't that take a long time and maybe adversely impact the
TSM server's performance?

---------------------------------
Mr. Lindsay Morris
Lead Architect, Servergraph
www.servergraph.com <http://www.servergraph.com>
859-253-8000 ofc
425-988-8478 fax


> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> Richard Sims
> Sent: Friday, December 06, 2002 9:22 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Ned a SQL QUERY - Where did my big files come from?
>
>
> >I have some big files (10+G and one 31+Gig file) that is being backed up.
> >Is there a query that I can use to find what the big files are and what
> >client they belong to?
>
> The TSM administrator sometimes has to determine what files a current or
> recent backup has sent.  The simplest way is, knowing the volume they went
> to:
>
>    query content Volname count=-20 format=detailed
>
> for example, where some reasonable negative number will show you
> the latest
> files on the volume, listed most recent first.  This is easiest with large
> backup files, like yours, where they will very likely show up
> within a limited
> count value.
>
>   Richard Sims, BU
>