Reporting on Windows Services

book

Article ID: 171715

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

You have a need to report on Windows Services from Symantec Endpoint Management Platform (SEM).

Environment

Symantec Management Platform 7.x, 8.x

Resolution

Altiris reports on Windows services when basic inventory is gathered and sent. The data is kept in the Inv_AeX_AC_NT_Services table.

Here is a basic example of using this table in a query

select v.[Name] as [Computer Name], v.Domain, s.[Name], s.Description, s.StartupType
from Inv_AeX_AC_NT_Services as s
 join vComputer as v
  on s._ResourceGuid = v.Guid
where Description = 'windows update'