NPM: 12.2
For those of you who want to know which nodes have been unmanaged in your environment, this is how I found nodes that have been unmanaged using Microsoft Access. The table names and columns should be the same across SQL server, MS Acess SQL, and SWQL. To use it in the different areas, you will just need to modify the syntax.
The following table will need to be mapped in MS Access:
SELECT dbo_Nodes.NodeID, dbo_Nodes.IP_Address, dbo_Nodes.Caption, dbo_Nodes.StatusDescription, dbo_Nodes.Vendor, dbo_Nodes.MachineType, dbo_Nodes.UnManaged, dbo_Nodes.UnManageFrom, dbo_Nodes.UnManageUntil
FROM dbo_Nodes
WHERE (((dbo_Nodes.UnManaged)=True))
ORDER BY dbo_Nodes.UnManageFrom DESC;
