Hello world,
I'm using APM to monitor McAfee Web Gateway devices and i'm building some cool custom dashboards.
I'm trying to build an internet traffic graph that joins two MWG application metrics (highlighted in yellow below)
Problem is, I can't seem to find any option to do this with a dynamic query.
So i figured out the solution would be using SQL to fetch the data and use the SQL SUM function to do the trick
But now I'm struggling to find a query that sums the two values and filter that up for nodes with a custom propertie set to a certain value...
I'd really appreciate if anyone could share on something similar. 
Here's what I know:
Table: NodesCustomProperties: Application: Component: CurrentComponentStatus:
Column: NodeID NodeID ApplicationID ApplicationID
node_Zone ID Name StatisticalData
Statistical data is what I want to select
Node related JOIN
Application related JOIN
FILTER ON custom propertie node_zone = 'one particular zone' & component name like 'HTTP%: Bytes Transferred Between Proxy and Servers''
And on top of that I'd have to SUM statistical data with the same Application ID
That's one hell of a query ! Please tell me there's another way ! 
Where are the SQL MVPs ? 
