You would need to attempt a custom SQL query -
below is one previously attempted-
Applications.FullName AS ApplicationName,
AVG(ApplicationStatistics.Availability) AS AVERAGE_of_Availability
Applications JOIN ApplicationStatistics ON (Applications.AppID = ApplicationStatistics.AppID)
( DateTime > (GetDate()-30) )
(Applications.FullName LIKE '%ECM%')
Applications.AppID, ApplicationStatistics.AppID, ApplicationStatistics.Availability, Applications.FullName
ORDER BY FullName ASC
hope this can help get you in the right direction or perhaps someone else could assist, any takers?
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.