Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

List of "Account Names", "Status" report in the Account Management. Needed

Created: 18 Jun 2012 | 3 comments

Anyone has a report that will provide a list of ALL 'account names' and 'status' ?

And, if it has the Roles 'Member Of' information, it will be real helpful

Using version: 7.1 SP2

Thanks.

Comments 3 CommentsJump to latest comment

mclemson's picture

I ran Altiris Profiler and found that it pulls the status of SecurityTrustee from ItemActive:

SELECT vi.Name,
CASE WHEN ia.Enabled=0 THEN 'Disabled'
WHEN ia.Enabled=1 THEN 'Enabled'
END AS 'Status'
FROM SecurityTrustee st
JOIN vItem vi ON vi.Guid=st.Guid
JOIN ItemActive ia ON ia.Guid=st.Guid
WHERE vi.ClassGuid='C41F55B8-8CEB-484A-8EDD-1F9F5515F661'
ORDER BY vi.Name DESC
 
 

Mike Clemson, Senior Systems Engineer, ASC
Intuitive Technology Group -- Symantec Platinum Partner
intuitivetech.com

seguidor1's picture

You are awesome McLemson!  Altiris Profiler is something that I still have to master.

Thank you, it works perfectly!

V.

seguidor1's picture

McLemson,

How you modify the report to give you a list of ALL the roles that a user account belongs to?  and also the reverse ... Given a 'Role Name' show me all the User Accounts that are members of that role.

Thanks,

S1