How many people have what roles?
I'm trying to determine how many people have a given role. For example, how many people have the SDAdmin role in my instance of SDP.
So far I've built this:
SELECT *
FROM AaaAuthorizedRole aar LEFT JOIN AaaRole ON aar.ROLE_ID=aaarole.ROLE_ID
LEFT JOIN AaaUser aau on aar.ACCOUNT_ID=aau.USER_ID
WHERE AaaRole.NAME='SDAdmin'
But the problem is, the results don't list my user account which I know for sure has SDAdmin rights. Am I looking at the wrong table? Is there another table that deals with Technician accounts?
Thanks for your help.
So far I've built this:
SELECT *
FROM AaaAuthorizedRole aar LEFT JOIN AaaRole ON aar.ROLE_ID=aaarole.ROLE_ID
LEFT JOIN AaaUser aau on aar.ACCOUNT_ID=aau.USER_ID
WHERE AaaRole.NAME='SDAdmin'
But the problem is, the results don't list my user account which I know for sure has SDAdmin rights. Am I looking at the wrong table? Is there another table that deals with Technician accounts?
Thanks for your help.