Video Screencast Help
Search Video Help Close Back
to help

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

Created: 18 Jun 2012 | 3 comments
seguidor1's picture
seguidor1
0 0 Votes
Login to vote

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.

Discussion Filed Under:
, , ,

Comments 3 Comments • Jump to latest comment

mclemson's picture
mclemson Trusted Advisor Partner Accredited
List of "Account Names", "Status" report in the Account Management. Needed - Comment:19 Jun 2012 : Link

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

+1
Login to vote
seguidor1's picture
seguidor1
List of "Account Names", "Status" report in the Account Management. Needed - Comment:19 Jun 2012 : Link

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

Thank you, it works perfectly!

V.

0
Login to vote
seguidor1's picture
seguidor1
List of "Account Names", "Status" report in the Account Management. Needed - Comment:11 Dec 2012 : Link

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

0
Login to vote