List default database for SQL logins

If you want list all SQL login with default DB you can use this query:

select name,
       loginname,
       dbname as DefaultDB,
       DATABASEPROPERTYEX(dbname, 'Status') as DBStatus
from sys.syslogins
order by DBstatus;

Result