Gets users who have been orphaned

Get-OrphanedSIDS.sql

SELECT dp.name AS [user_name],
       dp.type_desc AS [user_type],
       ISNULL(sp.name, 'Orphaned!') AS [login_name],
       sp.type_desc AS [login_type]
FROM sys.database_principals AS dp
    LEFT JOIN sys.server_principals AS sp
        ON (dp.sid = sp.sid)
WHERE dp.type IN ( 'S', 'U', 'G' )
      AND dp.principal_id > 4
ORDER BY sp.name;