Hello,
i'm looking to build a few dashboards that will provide executive summary type information. In doing so i'm trying to figure out how to aggregate data into widgets mainly for the purposes of counting. A few good examples of this would be:
Total available ports across all switches, total link up, and total link down
Total combined number of active calls across a pool of SIP trunks
Total number of connected access points across a cluster of wireless controllers
It's pretty easy and straight forward to do all of this when working with a single host, i'm just having trouble figuring out how to implement a SUM function that could aggregate data from multiple hosts into a value card or graph on a dashboard. It almost appears like there isn't actually functionality for this directly in the dashboard moule. From what i've been able to gather so far it looks like I need to create a dummy host that won't be connected to anything and would only exist to create/maintain "Calculated Items".
For testing I created a few virtual machines and put them into a host group where i'm trying to use a calculated item to sum the total number of CPUs across the group of VMs. The formula I entered is:
sum(last_foreach(/*/system.cpu.num?[group="Virtual Servers"]))
am I way off track here?