Reporting on Windows Services

Products

• IT Management Suite

Issue/Introduction

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

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'