• State Not Answered
  • Locked Locked
  • Replies 1 reply
  • Subscribers 32 subscribers
  • Views 280 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Reports

soxfan

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

    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.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.