How do you setup and run reports for Application Monitor? I would like to be able to run availability reports for applications, the same way you can for network nodes.
thanks
You would need to attempt a custom SQL query -
below is one previously attempted-
SELECT
Applications.FullName AS ApplicationName,
AVG(ApplicationStatistics.Availability) AS AVERAGE_of_Availability
FROM
Applications JOIN ApplicationStatistics ON (Applications.AppID = ApplicationStatistics.AppID)
WHERE
( DateTime > (GetDate()-30) )
AND
(
(Applications.FullName LIKE '%ECM%')
)
AND
(ApplicationStatistics.Availability<>0)
GROUP BY
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 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.