Symantec Management Platform (Notification Server)

 View Only
  • 1.  List of "Account Names", "Status" report in the Account Management. Needed

    Posted Jun 18, 2012 10:30 AM

    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.



  • 2.  RE: List of "Account Names", "Status" report in the Account Management. Needed

    Posted Jun 19, 2012 01:44 PM

    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
     
     


  • 3.  RE: List of "Account Names", "Status" report in the Account Management. Needed

    Posted Jun 19, 2012 02:23 PM

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

    Thank you, it works perfectly!

    V.



  • 4.  RE: List of "Account Names", "Status" report in the Account Management. Needed

    Posted Dec 11, 2012 11:58 AM

    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