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

Widget with Maitnenance Mode for Node

Jump to solution

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.

Labels (2)
0 Kudos
1 Solution
Level 9

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

View solution in original post

4 Replies
Level 9

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

View solution in original post

Great. It may useful for others as well.

I Would like to customized the management widget in node detail summary view.

I want to allow user for poll now option not for others. Looking for the solution.  Appreciate you help.

0 Kudos

Use SWQL/SQL query for customization.

0 Kudos

I tried, seems SWQL query has only Node. properties and in SQL I cant use current node only as I want this widget for each node I have.

0 Kudos