An actual SQL guru could probably make the code look better, but here's something Google didn't seem to be able to answer. Hope it helps someone.
Who UnManaged the Node...
SELECT Audit.[AuditEventID]
,Audit.[TimeLoggedUtc]
,Audit.[AccountID]
,Audit.[ActionTypeID]
,ActionType.[ActionTypeDisplayName]
,Audit.[AuditEventMessage]
,Audit.[NetworkNode]
,Audit.[NetObjectID]
,Node.[DNS]
,Node.[IP_Address]
,Node.[UnManaged]
,Node.[UnManageFrom]
,Node.[UnManageUntil]
FROM [NetPerfMon].[dbo].[AuditingEvents] Audit
LEFT JOIN [NetPerfMon].[dbo].[AuditingActionTypes] As ActionType
ON Audit.[ActionTypeID] = ActionType.[ActionTypeID]
RIGHT JOIN [NetPerfMon].[dbo].[NodesData] AS Node
ON Audit.[NetworkNode] = Node.[NodeID]
WHERE
Node.[UnManaged] = '1' AND Audit.[ActionTypeID] = '27' /* Only UnManaged Nodes */
/* UnManaged Until: A look into the future */
-- UnManageUntil >= DateAdd(dd, 0, Getdate()) /* Adjust dates to review. */
-- AND (Audit.[ActionTypeID] = '26' OR Audit.[ActionTypeID] = '27') /* Managed: 26 - Unmanaged: 27 */
/* UnManaged From: A look at the past. */
-- UnManageFrom >= DateAdd(dd, -7, Getdate()) /* Adjust dates to review. */
ORDER BY Node.[UnManaged] DESC, Node.[UnManageUntil] DESC
Who UnManaged the Application...
,App.[Name]
,App.[Unmanaged]
,App.[UnmanageFrom]
,App.[UnmanageUntil]
RIGHT JOIN [NetPerfMon].[dbo].[APM_Application] AS App
ON Node.[NodeID] = App.[NodeID]
App.[UnManaged] = '1'
AND Audit.[ActionTypeID] = '42' /* Only UnManaged Nodes */
AND App.[UnmanageFrom] IS NOT NULL
ORDER BY App.[UnManaged] DESC,App.[UnManageUntil] DESC
