I debated keeping it to same thread. Only I will use it to produce a list and ultimately a report. Whether someone will ask me to run it all the time, remains to be heard, and doubtful. Do you know a way other than

SELECT name, type, type_desc FROM sys.database_principals