sorry, one of these days I'll learn to read...

here is more along the lines of what you are looking for...
(not much data here because this is the test serve....

tsm: TSMSRV08>select
auditocc.node_name,auditocc.total_mb,sum(occupancy.num_files) as file_cnt
from auditocc,occupancy where auditocc.node_name=occupancy.node_name group
by auditocc.node_name,auditocc.total_mb order by total_mb desc

NODE_NAME                 TOTAL_MB        FILE_CNT
------------------     -----------     -----------
TSMSRV01                       975           63983
TSMSRV08                         7            1517
TSMUTL01                         3             717

tsm: TSMSRV08>





                      "Gill, Geoffrey
                      L."                      To:       ADSM-L AT VM.MARIST 
DOT EDU
                      <GEOFFREY.L.GILL@        cc:
                      SAIC.COM>                Subject:  Help Q auditocc or 
other query
                      Sent by: "ADSM:
                      Dist Stor
                      Manager"
                      <[email protected]
                      .EDU>


                      07/16/2003 11:39
                      AM
                      Please respond to
                      "ADSM: Dist Stor
                      Manager"






The information in q auditocc tells me a lot but I wonder if there is a way
to get the same information and order it by megabytes/gigabytes/terabytes
from the heaviest hitter to the least. I would also like to have a column
that includes the number of files each of the nodes TSM is tracking. This
is
something I would like to have for a meeting to explain:

1.      What it is costing the company to keep this data on tape. I might
also use a moc bill and send it to those people and see their reaction.
2.      What kind of a hit the TSM database takes for nodes it has to track
millions of files.
3.      General reasons to keep our number of versions to what are
necessary, not what someone feels like they need.
4.      Growth expectations and what it will do to our current setup and
for
budget considerations next year.



I know I am not kept informed of growth expectations by any of these groups
yet I'm always expected to keep this thing going for nothing. If anyone has
a query that can provide these things could you please share it? You could
say I am the worst at sql statements and I would not argue one bit. I'm
sure
others in the group could also benefit by it.



Thanks for the help,

And if you can think of something else I might include that would be
helpful
please feel free.

Geoff Gill
TSM Administrator
NT Systems Support Engineer
SAIC
E-Mail:   gillg AT saic DOT com
Phone:  (858) 826-4062
Pager:   (877) 905-7154