16 Replies Latest reply on Jul 18, 2019 10:28 AM by David Smith

    Maintainance nodes Dashboard

    ankitaja

      Hi All,

       

      Is it possible to have by which user device is put in maintenance mode. Can I show this on dashboard?

        • Re: Maintainance nodes Dashboard
          KMSigma

          What specifically do you mean by "Maintenance Nodes?"  Do you mean, nodes that have alerts muted or those that are in an "Unmanaged" status?  You can build reports for both of them.

          • Re: Maintainance nodes Dashboard
            dc4networks

            All in the Meantime…

             

            Applet View for Currently Unmanaged Nodes.

            1. Select the Pencil Icon at the Top Left of the SolarWinds View Webpage to be edited.
            2. Select Customise Page.
            3. Select Page Settings.
            4. Select Web Page Column for the Applet.
            5. Select the +
            6. Click ‘ADD SELECTED RESOURCE’
            7. Select ‘Edit’ at the Topp Right of the All Nodes – Table Resource.
            8. Rename the Title to ‘Unmanaged Nodes’
            9. Add a Subtitle Optional. [Left Blank].
            10. Filter Text Optional. [Left Blank].
            11. Node Property; No Change to the Node Name
              This Property is at the Top of the List.
            12. Filter Nodes (SQL)
              Enter status='9'
            13. SUBMIT
            14. Any Nodes
              that are currently unmanaged will be shown within this new addition to the SolarWinds View.
            15. With Screen shots as shown below.

            =======================================================================================

               Applet View for Currently Unmanaged Nodes.

            1. Select the
              Pencil Icon at the Top Left of the SolarWinds View Webpage to be edited.
            2. Select Customise Page.
            3. Select Page Settings.
            4. Select Web Page Column for the Applet.

              Please Note; This Image shows the ‘All Nodes - Table’ Resource already added.
            5. Select the +
            6. Click ‘ADD SELECTED RESOURCE’
            7. Select ‘Edit’ at the Top Right of the All Nodes – Table Resource.
            8. Rename the Title to ‘Unmanaged Nodes’
            9. Add a Subtitle Optional. [Left Blank].
            10. Filter Text Optional. [Left Blank].
            11. Node Property; No Change to the Node Name

              This Property is at the Top of the List.
            12. Filter Nodes (SQL)
              Enter status='9'
            13. SUBMIT
            14. Any Node that is currently unmanaged will be shown within this new addition to the SolarWinds View.
            • Re: Maintainance nodes Dashboard
              David Smith

              If you look at this post by mesverrum he has a good Dashboard Widget that shows Muted & Unmanaged Node using SWQL Query

               

              Report on Muted and Unmanaged Entities

               

              There are other variations on this as well including a Entities version that can potentially include Interfaces, Volumes, Applications etc.

              • Re: Maintainance nodes Dashboard
                ankitaja

                Hi,

                 

                I am using below queries :-\

                 

                FIRST BOX

                 

                 

                SELECT [N].Caption as [Element]
                     , [N].DetailsURL as [_LinkFor_Element]
                     , '/Orion/images/StatusIcons/Small-' + [N].StatusIcon AS [_IconFor_Element]
                     -- , [N].IP_Address as [IP]
                     -- , [N].DetailsURL as [_LinkFor_IP]
                     , [Alerts].SuppressFrom as [Mute From]
                     , [Alerts].SuppressUntil as [Mute Until]
                FROM Orion.AlertSuppression AS [Alerts]
                JOIN Orion.Nodes AS [N]
                  ON [N].Uri = [Alerts].EntityURI

                UNION

                ( SELECT [I].FullName as [Element]
                     , [I].DetailsURL as [_LinkFor_Element]
                     , '/Orion/images/StatusIcons/Small-' + [I].StatusIcon AS [_IconFor_Element]
                     -- , [I].IP_Address as [IP]
                     -- , [I].DetailsURL as [_LinkFor_IP]
                     , [Alerts].SuppressFrom as [Mute from]
                     , [Alerts].SuppressUntil as [Mute Until]
                FROM Orion.AlertSuppression AS [Alerts]
                JOIN Orion.NPM.Interfaces AS [I]
                  ON [I].Uri = [Alerts].EntityURI

                )

                 

                 

                SECOND BOX

                SELECT [N].Caption as [Element]
                     , [N].DetailsURL as [_LinkFor_Element]
                     , '/Orion/images/StatusIcons/Small-' + [N].StatusIcon AS [_IconFor_Element]
                     -- , [N].IP_Address as [IP]
                     -- , [N].DetailsURL as [_LinkFor_IP]
                     , [Alerts].SuppressFrom as [Mute From]
                     , [Alerts].SuppressUntil as [Mute Until]
                FROM Orion.AlertSuppression AS [Alerts]
                JOIN Orion.Nodes AS [N]
                  ON [N].Uri = [Alerts].EntityURI

                WHERE [Element] LIKE '%${SEARCH_STRING}%'

                UNION

                ( SELECT [I].FullName as [Element]
                     , [I].DetailsURL as [_LinkFor_Element]
                     , '/Orion/images/StatusIcons/Small-' + [I].StatusIcon AS [_IconFor_Element]
                     -- , [I].IP_Address as [IP]
                     -- , [I].DetailsURL as [_LinkFor_IP]
                     , [Alerts].SuppressFrom as [Mute from]
                     , [Alerts].SuppressUntil as [Mute Until]
                FROM Orion.AlertSuppression AS [Alerts]
                JOIN Orion.NPM.Interfaces AS [I]
                  ON [I].Uri = [Alerts].EntityURI

                WHERE [Element] LIKE '%${SEARCH_STRING}%'
                )

                 

                What modification I need to do in this query to have account name also in Dashboard.