Try,
select  sum(bytes) from summary where entity='SuspectedAbuser' and activity
='BACKUP' and start_time between '2002-01-13 00:00' and '2002-01-14 00:00'

This will give you in bytes the amount of data  a particular node sent to
the server in a 24 hour period.
Adjust the start_time and entity as required.

You can also do a
select entity, sum(bytes) blah blah blah blah group by entity
This will give you the bytes for all nodes.

Hope this helps.

Regards,

Denis L. L'Huiller
973-360-7739
dlhuillier AT pershing DOT com
Enterprise Storage Forms ->
http://admpwb01/misc/misc/storage_forms_main.html



                    Zoltan
                    Forray/AC/VCU        To:     ADSM-L AT VM.MARIST DOT EDU
                    <zforray@VCU.        cc:
                    EDU>                 Subject:     Re: Handling spikes in 
storage transfer
                    Sent by:
                    "ADSM: Dist
                    Stor Manager"
                    <ADSM-L AT VM DOT MA
                    RIST.EDU>


                    01/14/2002
                    11:02 AM
                    Please
                    respond to
                    "ADSM: Dist
                    Stor Manager"






I already tried that. The information it gives isn't detailed enough. It
just tells me about the filespaces.

I need to know specifics, such as the names/sizes of the files/objects in
the file spaces.

Anybody have any sql to do such ?

Thanks, anyway !
----------------------------------------------------------------------------------------------------
Zoltan Forray
Zoltan Forray
Virginia Commonwealth University - University Computing Center
e-mail: zforray AT vcu DOT edu  -  voice: 804-828-4807




"Cook, Dwight E (SAIC)" <cookde AT BP DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
01/14/2002 10:29 AM
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: Handling spikes in storage transfer


Do a "q occ <nodename>" and look for what file systems are out on your
diskpool in great quantity.
That is, if you send all data first to a diskpool and then bleed it off to
tape (daily).
That will give you an idea of what file systems are sending the most data,
currently.
Then you may perform something like a "show version <nodename>
<filespacename> to see each specific item.
        you might note the "filecount" in the "q occ" listing to see how
much will be displayed in the "show version" command.

hope this helps...
        later,
                Dwight