Jack, you might look at our viewacct script -
it would show you which clients had the largest backups last night - then
you can look at the dsmsched.log file on those clients and find the big
file.
For the viewacct script, see "Mining the Accounting Log, at
http://www.servergraph.com/techtipshome.shtml.
When you get around to looking at the dsmsched.log file, here's a script
(not used in a year, but was good the last time I looked) that will find
large files in your dsmsched.log that are getting sent every day. You'll
have to get the dsmsched.log file over to a unix box, or put MKS tools or
something on the windows box.
Good luck!
============================================================================
=============
#!/usr/bin/ksh
# analyze a dsmsched.log file: look for large files that got backed up
if [ $# -ne 1 ]
then echo "usage: $0 <dsmchedlog-file name>"; exit 1
fi
fgrep "Normal File" $1 | awk '{print $1, $5, $6}' | sed 's/,//g' | sort
+0r -1 +1rn -2 >/tmp/$$.1
# that file has all dates, all files.
# just get the largest 10 files from yesterday, and
# then look for them on other dates too. We might see we're backing up
# the same file over and over again.
sed 10q /tmp/$$.1 | awk '{print $3}' >/tmp/$$.2
fgrep -f /tmp/$$.2 /tmp/$$.1 | sort +2 -3 +0r -1
rm /tmp/$$.[12]
---------------------------------
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
> Coats, Jack
> Sent: Friday, December 06, 2002 9:15 AM
> To: [EMAIL PROTECTED]
> Subject: 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?
>
