Top_XX_Routing_Flaps.OrionReport

Version 1

    Report showing Top XX Routing Flaps per destination over the past XX days

     

    Defaults:

    Top 50

    Past 1 day

     

    To change these values, edit the BOLDED SQL statements in report writer:

     

    SELECT TOP 50
        N.NODEID,
        N.CAPTION AS "DEVICE",
        RF.ROUTEDESTINATION AS "ROUTE DESTINATION",
        COUNT(1) AS "TIMES FLAPPED"
    FROM
        NPM_ROUTINGTABLE_FLAP RF
    JOIN
        NODES N ON N.NODEID = RF.NODEID
    WHERE
        ( DATETIME > (GETDATE()-1))
    GROUP BY N.CAPTION, RF.ROUTEDESTINATION, N.NODEID
    ORDER BY "TIMES FLAPPED" DESC

     

     

    To use this report:

     

    Save the file to your Orion reports directory:

    C:\Program Files (x86)\SolarWinds\Orion\Reports (default on Server 2008 R2)

     

    Edit the web view you want to add this to, use 'Report from Report Writer" resource. Enjoy!