I am very bad at SQL statements, but I do it this way:

select sum(total_mb) from auditocc where node_name='node1' or node_name='
node2' or node_name...

Just select which nodes you want to add to the total.


Etienne Brodeur
Coordonnateur Technique - Technical Coordinator
Serti Informatique Inc.
Tel.:  (514) 493-1909 Fax: (514) 493-3575
http://www.serti.com




Luc Beaudoin <lbeaudoi AT IS.JGH.MCGILL DOT CA>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
26/10/2004 11:52 AM
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
space utilization






Hi all

I need to create reports for space utilization

I need to know how many space use all my sql databases .. do I need to add
all of them one by one.. node by node ???

I need to know how many space use all my windows nodes ,, Domino nodes ...
Sql nodes ... is there a easier way than add them one by one

thanks
Luc