1 of 1 people found this helpful
Ok so one portion solved. I created two custom sql reports in report writer to list nodes that are unmanaged.
I used the posted sql query and also created one for interfaces with the same settings.
I then just created a new view on the website to list the custom report.
I have a similar report that runs weekly that shows everything that will "remanage" that upcoming week to prevent any surprises.