To get Mapped Logins & User Info

--DB User-DB SID - Login - Server SID

use Master
SELECT d.[name] AS 'DB User', d.sid AS 'DB SID',
 s.[name] AS 'Login', s.sid AS 'Server SID'
FROM sys.database_principals d
 JOIN sys.server_principals s
 ON d.sid = s.sid