Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

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?

Find more posts tagged with

Accepted answers

dgsmith80

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.

All comments

KMSigma.SWI

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.

ankitaja

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.

dc4networks

All in the Meantime…

Applet View for Currently Unmanaged Nodes.

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

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

Applet View for Currently Unmanaged Nodes.

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

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

This Property is at the Top of the List.
Filter Nodes (SQL)
Enter status='9'
SUBMIT
Any Node that is currently unmanaged will be shown within this new addition to the SolarWinds View.

ankitaja

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,

dgsmith80

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.

dgsmith80

Like this?

ankitaja

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

user has put the devices in maintainance in this dashboard.

dc4networks

Ankitaja, No Worries...

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

I trust that "In The Meantime" helped thought.

ankitaja

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

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

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

UNION

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

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

dan_jagnow

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

ankitaja

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.

dgsmith80

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