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 node_name,sum(physical_MB) as Space_used_MB from dedupstats group by node_name
Unfortunately those script return nothing, tried to use them a few months ago.
If you want by occupancy, you could use the info from dedupstats - you need to generate them (generate dedupstats) per storage pool or node, and then you could pull the info per node with:
# AMOUNT OF DATA PER NODE
Code:select node_name,sum(physical_MB) as Space_used_MB from dedupstats group by node_name
Those are not scripts, those are SQL queries. There must have been a syntax or logic problem in your WHERE clause because the SUMMARY and OCCUPANCY tables are never empty.Unfortunately those script return nothing, tried to use them a few months ago.