Client Management Suite

I'm sure this is a basic question, but does a canned report exist for run an audit on the security roles and accounts in the Altiris client management console? I haven't found any, but that doesn't mean it doesn't exist. ;)

Try this , it will give you secrity roles and their membership. 

Hi, skhs:

Thanks a lot for providing this little SQL :)

Do you know if is there any way of getting all the users that are members of a security role? I'll try to explain: If I run the query you kindly provided, if a member of a security  role group is another security role...is there a way of getting the users from this nested security role?

The following article provides privileges and permissions assigned to roles:

https://www-secure.symantec.com/connect/articles/how-find-out-security-roles-assigned-permissions-and-privileges

If you wish to learn how the SMP retrieves a roles membership, please review the spGetRoleMembers stored procedure.

Do you need any further help with this request?