Widget with Maitnenance Mode for Node

Question

Hello,

I would like to create widget in Node summary page with information about maintenance. Last Event widget doesn't have all the information I need as I would like to get information when Node has been unmanaged when it will end who did that, same for managed again and alerts muted or unmuted for specific time.

I have widget already with custom report based on SQL query showing this information but it is for all nodes and I don't know how to use that just for current node as data source.

fursel · Accepted Answer

Okay thanks I made it with SWQL

Here is query if someone would like to use that too.

SELECT Audit.TimeLoggedUtc as "Time_Logged"

,ActionType.ActionTypeDisplayName as "Action"

,Audit.AccountID as "User"

,node.Caption as "Node"

,Node.IP_Address as "IP"

,Node.UnManageFrom as "FromTime"

,Node.UnManageUntil as "UntilTime"

FROM Orion.AuditingEvents as Audit

LEFT JOIN Orion.AuditingActionTypes As ActionType

ON Audit.ActionTypeID = ActionType.ActionTypeID

RIGHT JOIN Orion.Nodes AS Node

ON Audit.NetworkNode = Node.NodeID

WHERE

(ActionTypeID =27

or ActionTypeID = 28

or ActionTypeID = 78

or ActionTypeID = 80)

AND Node.NodeID = ${NodeID}

ORDER BY Audit.TimeLoggedUtc desc

Widget with Maitnenance Mode for Node

Top Replies