6 Replies Latest reply on Jan 29, 2020 5:46 AM by Prineel

    Widget for Warning & Critical Components

    Prineel

      Hi all, looking to create a widget that lists all warning/critical components within templates.  Specifically those within AppInsight Templates but not limited to.

       

      Any easy way to do this without scripting?

       

      Thanks

        • Re: Widget for Warning & Critical Components
          jrouviere

          I would definitely do this as a report, I've done something pretty close in the past:

           

          I used a Custom Table resource and the below SQL code:

           

          SELECT

          c.Application.Node.Caption as [Node],

          c.Application.Node.DetailsUrl as [_LinkFor_Node],

          c.Application.Node.Status as [_StatusFor_Node],

          c.Application.Node.ChildStatus as [_ChildStatus],

          c.Application.Name as [Application],

          c.Application.DetailsUrl as [_LinkFor_Application],

          c.Application.Status as [_StatusFor_Application],

          ComponentName as [Component],

          DetailsUrl as [_LinkFor_Component],

          c.CurrentStatistics.ComponentResponseTime as [Response Time],

          Status as [_StatusFor_Component],

          c.CurrentStatistics.ComponentStatisticData as [Data],

          c.CurrentStatistics.ErrorMessage as [Message]

          FROM Orion.APM.Component c

          WHERE c.Application.Node.Caption = '<specific node>'

          and Disabled = False

          and c.StatusDescription != 'Up'

           

           

          I'm including the query as is, but you don't have to limit it to the specific node if there aren't a lot of applications on the node, additionally you can add or change the status description portion as this will show unmanaged applications as is.

           

          From here, there's some configuration you'll want to do to the Custom Table resource to let through all of the pretty and the links:

           

          My columns are in this order:

           

          Node, Application, Component, Response Time, Data, Message

           

          Node, Application and Component columns need "Add display settings" for Details Page Link (check enable tooltips) and Status Icon (Watermark).

           

          Data and Message need the box checked for Allow HTML Tags.

           

          Additionally I group the results by Node then Application, here are some screenshots to hopefully help:

           

           

           

          2 of 2 people found this helpful
          • Re: Widget for Warning & Critical Components
            Prineel

            Report works great.  Is it possible to list all nodes as opposed to specifying a node?

             

            Also it shows disabled/unplugged components, anyway to hide that and only show warning/critical.

             

            Thanks

            • Re: Widget for Warning & Critical Components
              tjkru

              Selecting Add Widget to a view and then selecting a Custom Table will allow you to add a report as a widget.  Great if it does not display to much data and consume the complete UI.  I was able to make a Agent Version widget to monitor the deployment of the new Solarwinds Agent after the upgrade.  This avoids the need to open a report each time.  If the report does get to large break it up sos that you have two reports displaying the results from two different monitors.  Or place it on a different tab.

               

              2 of 2 people found this helpful