Report of unmanaged nodes and their return date?

Has anyone developed a report which will list unmanaged nodes and have it include the date the node will return to managed status?

Find more posts tagged with

Report Writer

File, New, Advanced SQL

Name it Unmanaged Until Report

SQL Tab (cut and paste this)

SELECT
Nodes.Caption AS NodeName, Nodes.IP_Address AS IP_Address, Nodes.UnmanageUntil
FROM
Nodes
WHERE
(
(Nodes.Status = '9')
)

ORDER BY 1 ASC, 3 ASC

Better yet just download it from the Content Sharing Zone

enjoy...

Thanks! That did the trick.