A solution would be to display in a view two reports. The first one could display the details of each volume and the second one the combined statistics of multiple volumes.
Start > All Programs > Solarwinds Orion > Alerting, Reporting and Mapping > Report Writer.
File > New. Select "Historical - Volume Usage (Disk Space)"
In the Select Fields tab,
add the "Volume Space Available" field and select the SUM function.
Then you have multiple solution to better report per group of volumes the results. One could add e.g. the Volume Type field or a Node/Volume Custom Property or both. Using the Filter Results tab can as well help to filter out/in nodes. It is possible to group category in the Report Grouping tab.
Once you are satistified of your report(s), go to the webconsole.
In Admin > Manage Views, create a new view if required.
Add the "Report From Orion Report Writer" resource to your view. It is under the "Report Writer - Turn a Report from Report Writer into a Web Resource" section.
Doing this will avoid polling twice your devices for the same information.
That was just what I needed! I was making things much harder than they needed be.
Thank you very much.
I want to follow up and say how much we love NPM. It is a great application.
Apparently, my query will not SUM space available if the values are mixed GB and TB. For example, VOLUME 1 = 36 GB available, VOLUME 2 = 89 GB available, VOLUME 3 = 4.6 TB available. I get results with function None but nothing with function SUM.
Is there a way around this that you know of?
Your suggestion is very valuable even with this limitation because it is working for all of our systems but one.
Could you post the SQL Query run by the Report? This will give more information about what it try to do.
Open the Report in Report Writer.
Click on Report > Show SQL. Select the SQL Tab.
SELECT TOP 10000 SUM((NullIf(VolumeSize,-2)-NullIf(VolumeSpaceUsed,-2))) AS SUM_of_VolumeSpaceAvailable
Nodes INNER JOIN Volumes ON (Nodes.NodeID = Volumes.NodeID)
(Nodes.Caption = 'PACS-LTA-NAS')
I am not sure why it is not working. I would advise you to open a support ticket to have a support representative work with you on this report. This will allow to have a better overview of the volume statistics entries.
- To Open a Ticket: http://www.solarwinds.com/support/ticket