cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 7

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
 

0 Kudos
1 Reply
Level 17

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?

0 Kudos