Andrew21210
ADSM.ORG Member
- Joined
- Apr 10, 2008
- Messages
- 97
- Reaction score
- 2
- Points
- 0
Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.
select sum(physical_mb) as PHYSICAL, sum(logical_mb) as LOGICAL, sum(reporting_MB) as REPORTING from occupancy where node_name='NODENAME' and filespace_name='HOSTNAME\SystemState\NULL\System State\SystemState'
Oh, you would not get the total though.
You could try:
Code:select sum(physical_mb) as PHYSICAL, sum(logical_mb) as LOGICAL, sum(reporting_MB) as REPORTING from occupancy where node_name='NODENAME' and filespace_name='HOSTNAME\SystemState\NULL\System State\SystemState'
Replace NODENAME with the node name
Replace HOSTNAME with the machine name or hostname
select node_name,sum(physical_mb) as PHYSICAL, sum(logical_mb) as LOGICAL, sum(reporting_MB) as REPORTING from occupancy where filespace_name like '%\SystemState\NULL\System State\SystemState' GROUP BY node_name
select sum(physical_mb) as PHYSICAL, sum(logical_mb) as LOGICAL, sum(reporting_MB) as REPORTING from occupancy where filespace_name like '%\SystemState\NULL\System State\SystemState'
Try this to get a listing for all nodes:
Code:select node_name,sum(physical_mb) as PHYSICAL, sum(logical_mb) as LOGICAL, sum(reporting_MB) as REPORTING from occupancy where filespace_name like '%\SystemState\NULL\System State\SystemState' GROUP BY node_name
Here is the select statement for the grand total:
Code:select sum(physical_mb) as PHYSICAL, sum(logical_mb) as LOGICAL, sum(reporting_MB) as REPORTING from occupancy where filespace_name like '%\SystemState\NULL\System State\SystemState'