List all EntraID uses in Azure SQL database

list-users.sql

SELECT dp.name, dp.type_desc, STRING_AGG(r.name, ', ') WITHIN GROUP (ORDER BY r.name) AS roles
FROM sys.database_principals dp
LEFT JOIN sys.database_role_members rm ON rm.member_principal_id = dp.principal_id
LEFT JOIN sys.database_principals r    ON r.principal_id = rm.role_principal_id
WHERE dp.type IN ('E', 'X')
GROUP BY dp.name, dp.type_desc
ORDER BY dp.name;