Symantec Management Platform (Notification Server)

Hello all,

I have a strange request and so far I have been unsuccessful.  I need to find a query that will show me group membership for the Altiris Console (7.1).  I'm not too picky about formatting but I need to include

1. username

2. security group

3. date created

4. date modified

Anything more would be great but is not totally necessary

I see a couple of antique reports under Notification Server>Security but unfortunately, these no longer seem to work...

Here is one example from the old days...

SELECT DISTINCT sperm.[Name] AS Permission,sperm.[Description],i.[Name] AS Solution   
FROM SecurityPermission sperm   
JOIN Item i ON i.Guid = sperm.Solution   
JOIN SecurityTrusteePermission stp ON stp.PermissionGuid = sperm.Guid   
JOIN temp_trustee tt ON tt.Guid = stp.TrusteeGuid   

DROP TABLE temp_trustee

Thanks so much!

Paul

Please let me know if this helps:-

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

Please mark as resolved if you no longer require assistance.

Did that help?  If so, please mark as resolved.