sp_helpmaplogin displays mapping information:
sp_helpmaplogin [ (authentication_mech | null), (client_username | null) ]
where authentication_mech is one of the valid values specified for authenticate with option in sp_modifylogin, and client_username is an external user name.
If you do not include any parameters, sp_helpmaplogin displays login information about all users currently logged in to Adaptive Server. You can restrict the output to specific sets of client user names or authentication mechanists by using the parameters listed above.
This displays information about all logins:
sp_helpmaplogin authentication client name login name -------------- ----------- ------------------ NULL jsmith guest LDAP NULL create login
