Report on unmanaged node duration

thad

Hello folks, we have a report created where it runs and tells us what nodes are currently unmanaged and then which have their alerts suppressed. Is there a way to include the time that a node is unmanaged for in the report? I'm not finding a way to do this yet... Any help is appreciated- thank you.

EDIT

All, here is some code that I found and messed with to make as simple as possible:

SELECT Caption AS Name, UnManageFrom AS UnManageFromUTC, UnManageUntil AS UnManageUntilUTC

FROM

Orion.Nodes

Where

UnManaged = 'True' AND NodeID = ${NodeID}

EDIT 2:

Is there a way to edit this to show nodes that are currently managed, but scheduled to be unmanaged?

EDIT 3:

I found an old sql script from 2009 on here and formatted it to work with our current version of SW. This script shows all current + future unmanaged nodes

SELECT Caption AS Name, Nodes.UnmanageFrom, Nodes.UnmanageUntil, Nodes.StatusDescription

FROM Orion.Nodes

where Unmanaged = 1 or unmanagefrom >= getdate()

ORDER BY 1 ASC, 2 DESC

cabotski

Hi thad

I'm after something similar and would be interested to see the entire code you have created.

I'd like to be able to input a time period e.g. 01Dec2016 - 31Dec2016 and have the report detail which nodes where unmanaged/managed in the selected period.

My SQL isn't great so any assitance would be appreciated.

I have the 'unmanaged nodes' report from Thwack you mention in your post.

Kind regards

Cabotski