Hello and thank you for the response -
The following query works - I may have already found a resolution in changing up the way I was calculating this. In a previous query if I used "(Value / 1.0)" this would cause the error that I had mentioned. Instead I used ( 300 * 1.0 / Value ) which avoids that error.
Example Query:
SELECT
Count(c.ComponentID) as SAM_Elements,
((300 * 1.0) / Value) as PollingWeight,
Count(c.ComponentID) * ((300 * 1.0) / Value) as Weighted_SAM_Elements,
n.NodeID,
n.EngineID
FROM Orion.APM.Component c
JOIN Orion.APM.Application a ON c.ApplicationID = a.ApplicationID
JOIN Orion.APM.ApplicationTemplateSettings ats ON a.ApplicationTemplateID = ats.ApplicationTemplateID
JOIN Orion.Nodes n ON a.NodeID = n.NodeID
WHERE Key = '__Frequency'
GROUP BY n.NodeID, n.EngineID, ats.Value
Thank you,
=swql
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK
®
online community.
More than 195,000 members are here to solve problems, share technology and best practices, and directly
contribute to our product development process.