Re: Another ADSM capacity question
2000-09-20 14:30:47
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?
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Another ADSM capacity question, Daniel Swan/TM
- Re: Another ADSM capacity question, Richard Sims
- Re: Another ADSM capacity question, Crump, Adam (CC-MIS Open Sys)
- Re: Another ADSM capacity question, Johnson, Brian
- Re: Another ADSM capacity question, Daniel Swan/TM
- Re: Another ADSM capacity question, Daniel Swan/TM
- Re: Another ADSM capacity question,
Johnson, Brian <=
- Re: Another ADSM capacity question, Daniel Swan/TM
- Re: Another ADSM capacity question, Johnson, Brian
- Re: Another ADSM capacity question, Alex Paschal
- Another ADSM capacity question, Daniel Swan/TM [mailto:Daniel.Swan
- Re: Another ADSM capacity question, Johnson , Brian [mailto:BrJohnson
|
|
|