IT Management Suite

 View Only
  • 1.  Report on service accounts?

    Posted Jun 08, 2015 02:00 PM

    I'm hoping someone can provide some assistance.  I need to run a report to help determine which accounts we have running as a service on our servers.  Has anyone done something similar before?  Any ideas on the best way to create this type of report?  Any help would be appricated.

    Thank you!



  • 2.  RE: Report on service accounts?
    Best Answer

    Posted Jun 08, 2015 02:44 PM

    hope this help

    https://www-secure.symantec.com/connect/forums/report-show-services-being-started-specific-accout

    see WDRAIN1 comments

    Try this....

    copy and paste in a Altiris report

    select

    vc.Name [Computer Name]

    ,vc.[OS Name]

    ,svc.Name [Service Name]

    ,svc.Description

    ,svc.StartupType

    ,svc.LogonAs

    from vComputer vc

    join Inv_AeX_AC_NT_Services svc on svc._ResourceGuid = vc.Guid

    where vc.[OS Name] like '%server%'

    and svc.LogonAs not in

    ('LocalSystem',

    'NT AUTHORITY\LocalService',

    'NT AUTHORITY\NetworkService',

    'NT AUTHORITY\NETWORK SERVICE',

    'NT AUTHORITY\LOCAL SERVICE'



  • 3.  RE: Report on service accounts?

    Broadcom Employee
    Posted Jun 08, 2015 02:45 PM

    You can see under which account is running appropriate service on client computer, using "Resource Manager" page

    NTServices_User.jpg

    All this information is available in SQL table [dbo].[Inv_AeX_AC_NT_Services] so you can use it for report creation.

     

    Also there is a report which shows information about your accounts within SMP Console logon:

    SMPAccount.jpg

    Thanks,

    IP.