I've seen multiple answers to this question but I don't think the answers are what he is looking for.
Correct me if I am wrong, but I think he wants to know what *FILES* were backed up, not just total bytes transfered. I am having this issue, as well. For instance, I have a node that all of a sudden is sending 100+GB. Well, looking at the occupancy info just tells me he has a 350GB /home filespace. I need to know what *FILES* have been backed up for the /home directory and their sizes, not a total. I know the size for the filespace. I need to know the details. Also, if they are running QUIET, the dsmsched.log won't show what files were backed-up ! John Naylor <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 12/06/2002 12:26 PM Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject: Re: Ned a SQL QUERY - Where did my big files come from? 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" <[EMAIL PROTECTED]> on 12/06/2002 02:32:30 PM Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] 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:[EMAIL PROTECTED]]On Behalf Of > Richard Sims > Sent: Friday, December 06, 2002 9:22 AM > To: [EMAIL PROTECTED] > 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. **********************************************************************