Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

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


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'

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

seguidor1's picture

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

Thank you, it works perfectly!


seguidor1's picture


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.