Query to check whether database has any externally authenticated SSL users

Please use the below query.

SELECT name FROM sys.user$
WHERE ext_username IS NOT NULL
AND password = ‘GLOBAL’;