Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*SQL\s+for\s+Node\s+Total\/Used\s+space\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*SQL\s+for\s+Node\s+Total\/Used\s+space\s*$/: 3 ]

Total 3 documents matching your query.

1. SQL for Node Total/Used space (score: 1): Author: John Naylor <john.naylor AT SCOTTISH-SOUTHERN.CO DOT UK>; Date: Wed, 23 Jul 2003 12:19:17 +0100; People, I have been playing aroung with some sql to extract for a particular platform, the total capacity /used per filespace for recently accessed clients. What I have below does this . I would also; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2003-07/msg00644.html (11,648 bytes)
2. Re: SQL for Node Total/Used space (score: 1): Author: P Baines <paul.baines AT ECB DOT INT>; Date: Wed, 23 Jul 2003 14:17:20 +0200; Maybe this: SELECT nodes.NODE_NAME, sum(filespaces.CAPACITY) as capacity, sum(filespaces.CAPACITY*filespaces.PCT_UTIL/100) AS "MB USED" FROM NODES,FILESPACES WHERE NODES.NODE_NAME=FILESPACES.NODE_NAM; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2003-07/msg00647.html (12,701 bytes)
3. Re: SQL for Node Total/Used space (score: 1): Author: John Naylor <john.naylor AT SCOTTISH-SOUTHERN.CO DOT UK>; Date: Wed, 23 Jul 2003 13:37:19 +0100; Excellent Thanks Paul P Baines <paul.baines AT ecb DOT int> on 07/23/2003 01:17:20 PM Please respond to "ADSM: Dist Stor Manager" <adsm-l AT vm.marist DOT edu> Maybe this: SELECT nodes.NODE_NAME, sum; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2003-07/msg00650.html (13,056 bytes)

Current List: 1 - 3
Page: [1]