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_AvailabilityFROM 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.FullNameORDER BY FullName ASC
hope this can help get you in the right direction or perhaps someone else could assist, any takers?