Brian, in no way did I mean to imply your statement was faulty... I guess
what I was hoping for is a better understanding of the output it generates.
From my limited understanding, the two commands below should generate
identical #'s.  Ie, Total occupancy of a client should equal the sum of all
filespaces of a client.

Obviously I've made a faulty assumption, and am hoping someone can point out
to me where, and how.

Best regards,
Dan.


Daniel Swan
HP Unix Team
ISM-BC
3030 2nd Ave SE
Calgary, AB, T2A 5N7
ph. 403-530-1726
fax: 403-530-1066




> -----Original Message-----
> From: Johnson, Brian [SMTP:BrJohnson AT EXCHANGE.ML DOT COM]
> Sent: Wednesday, September 20, 2000 12:30 PM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: Another ADSM capacity question
>
> Daniel,
> My command only sums up the number of files backed up and the total MB per
> client. It doesnt do any percentages and so on - so just for a set of
> totals
> my command works ok and the figures are ok
>
> Regards,
>
> Brian Johnson
> 212 647 3557
>
> > -----Original Message-----
> > From: Daniel Swan/TM [SMTP:Daniel.Swan AT TELUS DOT COM]
> > Sent: Wednesday, September 20, 2000 2:13 PM
> > To:   ADSM-L AT VM.MARIST DOT EDU
> > Subject:      Re: Another ADSM capacity question
> >
> > Brian, your SQL statement worked like a charm, however, I am having
> > trouble
> > reconciling the difference between the following outputs, which I think
> > should be the same:
> >
> > adsm> select total_MB from auditocc where node_name='U1_APPS'
> >
> > TOTAL_MB
> > -----------
> > 7396917
> >
> > ---AND---
> >
> > adsm> select node_name, cast(sum(capacity * (PCT_UTIL/100))as decimal
> > (9,0))
> > as percent_utilized from filespaces group by node_name order by
> > percent_utilized
> >
> > <SNIP>
> > U1_APPS                          473461
> >
> > How do I reconcile these differences, and which is a more accurate
> picture
> > of how much space is being taken up on my ADSM server?