Reports

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?