Video Screencast Help

Altiris security roles - Audit report?

Created: 02 Aug 2013 | 5 comments

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. ;)

Operating Systems:

Comments 5 CommentsJump to latest comment

skhs's picture

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

select vi.Name as [Group] , v2.Name as Member from [ResourceAssociation] ra
join vitem vi on vi.guid = ra.ParentResourceGuid
join vitem v2 on v2.guid = ra.ChildResourceGuid
where ra.ResourceAssociationTypeGuid = '63468F04-6751-448D-891C-B59906360A27'
Falquian's picture

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?

Kind regards:

     Falquian

If this post is useful to you, remember to mark it as a solution ;)

SK's picture

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

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.

SK's picture

The following article provides privileges and permissions assigned to roles:

https://www-secure.symantec.com/connect/articles/h...

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.

SK's picture

Do you need any further help with this request?

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.