SQL Server: sys.login_token

select
   p.principal_id,
   p.sid           principal_sid,
   l.sid           login_sid,
   p.name          principal_name,
   l.name          login_name,
   p.type_desc     principal_type,
   l.type          login_type,
   l.usage         login_usage,
   p.is_disabled,
   p.create_date,
   p.modify_date,
   p.default_database_name,
   p.default_language_name,
   p.credential_id
from
   sys.server_principals p left join
   sys.login_token       l on p.sid = l.sid