Execute the following Microsoft SQL Server T-SQL administration script in SSMS Query Editor to obtain all logins:

USE AdventureWorks

SELECT   'Server[@Name=' + quotename(CAST(serverproperty(N'Servername') AS SYSNAME),

                                     '''') AS [Server],

         prin.name                         AS [Name],

         prin.TYPE                         AS [LoginType],

         prin.is_disabled                  AS [IsDisabled],

         prin.create_date                  AS [CreateDate]

FROM     sys.server_principals AS prin

WHERE    (prin.TYPE IN ('U','G','S','C',

                        'K')

          AND prin.principal_id NOT BETWEEN 101 AND 255

          AND prin.name <> N'##MS_AgentSigningCertificate##')

ORDER BY [Name] ASC