Thwack » SolarWinds » Application Performance Monitor » Legacy Application Monitor » Reports

in More Search Options

Reports

Last post 07-17-2007 3:46 PM by Mark Wiggans. 1 replies.
Page 1 of 1 (2 items)
Sort Posts:

  • 07-17-2007 2:30 PM

    • soxfan
    • Not Ranked
      •
    • Joined on 05-24-2007
    • Posts 11
    • Points 21

    Reports

    Reply

    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
     
    • Post Points: 3

  • 07-17-2007 3:46 PM In reply to

    Re: Reports

    Reply

    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

     

     

    http://thwack.com/forums/p/1472/5851.aspx#5851
     

    hope this can help get you in the right direction or perhaps someone else could assist, any takers?

     

    Mark Wiggans
    Thwack Moderator
    • Post Points: 1
Page 1 of 1 (2 items)