So you want a SQL for just applications that have been Unmanaged DIRECTLY, not those that become Unmanaged as teh result of the entire NODE getting Unmanaged, right? If so, here you go.
from APM_Applications INNER JOIN Nodes
ON APM_Applications.NodeID = Nodes.NodeID
where APM_Applications.Unmanaged = 1
AND APM_Applications.UnmanageFrom IS NOT NULL
That will give you all of the Node and Application details for all applications that have been directly Unmanaged. It will exclude those that happen to be on Nodes that became Unmanaged. i leave it to you to pick which Node and Applications columns you need for your report.
Thanks mate, much appreciated.