So expanding on this myself, it doesn't look like it's possible to create reports that sum the total CPU, Disk, Traffic/bandwidth, and Memory usage for a group. This would be helpful since I have groups that reflect the status of a line of business or unit. It would be great to be able to show how much of these resources each LOB is using. If this isn't viable maybe it's a good idea for a feature request. I'm still toying with things in Report Writer but if anyone has any tips ....
Very close here but I feel I'm missing something. I'd like to sum the values in the CPU Load, Total Memory, and Space Used in this screen shot;
Currently if I set the CPU Load field to SUM, this is the result:
Obviously it is summing something other than the values in the CPU Load column from the first screen. If it truly added those, then I would expect the Sum to be 24%, because only one node in that column has any CPU usage.
Ideally it would be even better if I could get the CPU in total Ghz, but haven't been able to figure out how to convert the field to the right unit or even if that's possible. I have a feeling this will likely take some custom SQL queries to really work, but I'm not an Orion SQL guru so I'm hoping someone else has dealt with this before or can point me in the right direction.