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: [EMAIL PROTECTED]
<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: [EMAIL PROTECTED]
Phone: (858) 826-4062
Pager: (877) 905-7154
