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

Display nodes in maintenance mode in a modern dashboard widget

Is it possible to display a list of nodes in maintenance mode in a modern dashboard table widget?

If possible what is the SWQL to get that data ?

0 Kudos
1 Reply
Product Manager
Product Manager

Yes this is possible, the SWQL you need for a table widget would look something like this.

SELECT
n.caption,
n.DetailsUrl,
n.Status,
unmanaged, 
tolocal(UnManageFrom) as Unmanage, 
daydiff(getutcdate(), UnManagefrom)as [Days till Unmanage],
tolocal(UnManageUntil) as Remanage,
daydiff(getutcdate(), UnManageuntil)as [Days until Remanage]
FROM Orion.Nodes n
where
unmanaged = 'true'

 

0 Kudos