I am trying to clean up our org chart in Admin, and am running into a problem.  There are several former managers who I can't retire due to them still having reports.  However, I can't find those reports so that I can put them under the proper manager.  Is there any kind of Admin report that shows who reports to a certain manager?

Execute the following SQL statement within Tools - Execute SQL: SELECT sysdba.USERINFO.USERNAME, USERINFO_1.USERNAME AS MANAGER FROM sysdba.USERINFO INNER JOIN sysdba.USERSECURITY ON sysdba.USERINFO.USERID = sysdba.USERSECURITY.USERID INNER JOIN sysdba.USERINFO AS USERINFO_1 ON sysdba.USERSECURITY.MANAGERID = USERINFO_1.USERID

Execute the following SQL statement within Tools - Execute SQL: SELECT sysdba.USERINFO.USERNAME, USERINFO_1.USERNAME AS MANAGER FROM sysdba.USERINFO INNER JOIN sysdba.USERSECURITY ON sysdba.USERINFO.USERID = sysdba.USERSECURITY.USERID INNER JOIN sysdba.USERINFO AS USERINFO_1 ON sysdba.USERSECURITY.MANAGERID = USERINFO_1.USERID