Build a simple report for % disk utilization

RRT1978

Hello all, although I've used SW for more than 10 years I've never attempted to build a simple report. I've been attempting to build one, but so far I'm unsuccessful. Historical reports are showing an average over one month, I would prefer to see the current status, with no averages.

The report would contain:

1-  % utilization of volumes on servers, in a table.

2- The table would contain the node name, volume(s), and % utilization

3- I need to be able to exclude nodes, as some are static data stores that do not change.

Could anyone perhaps assist? I've gotten close, but still not there yet.

Thanks in advance.

UPDATE 6/23 4:45PM EST

I believe I have it worked out, so for now this thread can be put on hold. My apologies to the community.

stevenstadel

You can add a SWQL query to a report that may get you closer. 

SELECT
  n.Caption AS [Server Name], 
--  n.Vendor,
  v.Caption AS [Volume], 
  ROUND(v.VolumePercentUsed, 0) AS [Percent Used],
  ROUND(v.Size / 1073741824.0, 1) AS [Size (GB)],
  ROUND(v.VolumeSpaceUsed / 1073741824.0, 1) AS [Used (GB)],
  ROUND((v.Size - v.VolumeSpaceUsed) / 1073741824.0, 1) AS [Free (GB)]
FROM Orion.Nodes n
JOIN Orion.Volumes v ON v.NodeID = n.NodeID
-- EXCLUDE specific nodes by name (customize below)
WHERE n.Caption NOT IN ('StaticNode1', 'StaticNode2', 'Archive-Server')
-- Optionally exclude non-fixed disks if needed:
AND v.Caption not like '%Memory%'
-- Optionally include specific vendors if needed:
--AND n.Vendor IN ('Windows', 'net-snmp', 'Linux')
ORDER BY n.Caption, v.Caption