Oh yeah, just in case you're interested. This is what I have so far:
Use MicrosoftDynamicsAX
SELECT DISTINCT userinfo.NAME as "Full Name",
sysuserinfo.EMAIL as "Email Address",
userinfo.ID as "User ID",
sysuserprofiles.PROFILEID as "User Profile ID",
usergroupinfo.NAME as "User Group ID",
userinfo.LANGUAGE as "Language",
HELPLANGUAGE as "Alternate Help Language",
sysuserinfo.DEFAULTCOUNTRYREGION as "Default Country/Region",
userinfo.COMPANY as "Start Company Accounts"
FROM USERINFO
LEFT JOIN sysuserinfo
ON userinfo.ID = sysuserinfo.ID LEFT JOIN sysuserprofiles
ON sysuserprofiles.USERID = userinfo.ID LEFT JOIN usergrouplist
ON usergrouplist.USERID = userinfo.ID LEFT JOIN usergroupinfo
ON usergroupinfo.ID = usergrouplist.GROUPID
WHERE userinfo.NAME != ''
ORDER BY userinfo.NAME, usergroupinfo.NAME
I can JOIN SECURITYUSERROLE easily enough but that's not a lot of good if I can't also use SECURITYUSER.
This is how it looks in situ:
