Video Screencast Help

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