Daniel,
Absolutely no offence taken...

Looking at the second command it seems to be trying to do something slightly
different, something clever which my command doesnt !!!

Can someone please explain !!

Many thanks,

Brian Johnson





> -----Original Message-----
> From: Daniel Swan/TM [SMTP:Daniel.Swan AT TELUS DOT COM]
> Sent: Wednesday, September 20, 2000 2:45 PM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: Another ADSM capacity question
>
> 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?