A query content with a restricted count, like count=-20  is quick
Another way of finding out where your big files are is to query your activity
log
q ac begind=today-1 begint=18:00 endd=today endt=08:00 originator=client
The  lines showing "Total number of bytes transferred:" should give you the
clients that have sent the large amounts of data




"Mr. Lindsay Morris" <lmorris AT servergraph DOT com> on 12/06/2002 02:32:30 PM

Please respond to lmorris AT servergraph DOT com

To:   adsm-l AT vm.marist DOT edu
cc:    (bcc: John Naylor/HAV/SSE)
Subject:  Re: Ned a SQL QUERY - Where did my big files come from?



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
>











**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric, Southern Electric, SWALEC and S+S
are trading names of the Scottish and Southern Energy Group.
**********************************************************************