All,
Thought I would share this.... I had the above resource on our EOC page with the filter of Volume.Type like '%disk%' but I had no way to share the data with those who needed to know. I found I could use this query run from SQL Studio to gather the data from the EOC database so I could put into a spreadsheet.
Hope it helps others....
select c.Name as Site, b.Caption as Server, a.Caption as Volume,
a.PercentUsed
from EOC_Volume a
left outer join EOC_Node b on
a.OrionID = b.OrionID
and a.NodeID = b.NodeID
left outer join EOC_Orion c on
b.OrionID = c.OrionID
where a.type like '%disk%' and a.percentused > 80
