Re: Another ADSM capacity question
2000-09-20 14:14:17
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
7396917
---AND---
adsm> select node_name, cast(sum(capacity * (PCT_UTIL/100))as decimal (9,0))
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
|
|
|