cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 7

Maintainance nodes Dashboard

Jump to solution

Hi All,

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

0 Kudos
1 Solution

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.

- David Smith

View solution in original post

16 Replies
Level 7

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.

0 Kudos

To get the account name, take a look at queries in the previously-mentioned post:

Report on Muted and Unmanaged Entities

The important parts are these:

...
CASE
WHEN ae.accountID IS NULL THEN 'Audit Log Not Found'
ELSE ae.AccountID
END AS [Account]
...
JOIN (
    SELECT ae.NetObjectID, ae.AccountID, ae.timeloggedutc
    FROM Orion.AuditingEvents ae
    WHERE ae.auditingactiontype.actiontype = 'Orion.NodeUnmanaged') ae ON ae.NetObjectID = n.NodeID and ae.timeloggedutc=mostrecent.recent
...

There are additional references in the WHERE clause and in the next SELECT statement after the UNION ALL, but the point is that the account name you're looking for is in the AccountID property of the Orion.AuditingEvents entity.  You can see more details about it here:

Orion.AuditingEvents | Orion SDK Schemas

0 Kudos

Thanks.

I also wanted to know the SQL query to get the report for interfaces are in maintenance along with the account which created that maintenance.

0 Kudos

Just scroll down through the same post there is a post by whomademesme​ detailing how they updated the script to include Interfaces

Re: Report on Muted and Unmanaged Entities

- David Smith
0 Kudos

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.

- David Smith

View solution in original post

Thanks David. I just missed your above reply. I will check with this query and update

0 Kudos
Level 12

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.
    pastedImage_2.png
  2. Select Customise Page.
  3. Select Page Settings.
  4. Select Web Page Column for the Applet.
    pastedImage_3.png
    Please Note; This Image shows the ‘All Nodes - Table’ Resource already added.
  5. Select the +
    pastedImage_5.png
  6. Click ‘ADD SELECTED RESOURCE’
  7. Select ‘Edit’ at the Top Right of the All Nodes – Table Resource.
    pastedImage_6.png
  8. Rename the Title to ‘Unmanaged Nodes’
    pastedImage_7.png
  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'
    pastedImage_8.png
  13. SUBMIT
  14. Any Node that is currently unmanaged will be shown within this new addition to the SolarWinds View.
0 Kudos

In this dashboard, i want to have the user name as well who changed the

maintainance status of device i.e from manage to unmanage,mute alerts or

created schedule maintenance.

On Mon, 8 Jul 2019, 5:32 pm dc4networks,

0 Kudos

Ankitaja, No Worries...

It looks like David got you the answer that you were looking for.

I trust that "In The Meantime" helped thought.

0 Kudos
Community Manager
Community Manager

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.

"Shoot for the stars to reach the moon"
0 Kudos

For both. i want the report which have coloumns node name,alerts

muted/unmanaged, from and to dates, and by which user nodes are put into

maintainance mode.

0 Kudos

Like this?

pastedImage_0.png

- David Smith
0 Kudos

This dashboard i already configured in my env. I need username also..which

user has put the devices in maintainance in this dashboard.

0 Kudos

The dashboard I am referencing does include the Account which made the changes as the last row. the name is blacked out on the image to protect the innocent, but it does work.

- David Smith
0 Kudos

What I need to modify to include account name?

0 Kudos

Can you show us what you have so far as the default widget created by mesverrum​ included the Account field so you must have either created your own or modified it in some way.

Report on Muted and Unmanaged Entities

- David Smith
0 Kudos