SCCM SQL Query : To List Machines With IIS , FTP Or Telnet Installed

Select

SD.Name0 ‘Machine Name’,

SD.Operating_System_Name_and0 NOS,

SS.Name0 ‘Service Name’,

SS.DisplayName0 ‘Display Name’,

SS.StartMode0 ‘Start Type’,

SS.Started0 Started,

SS.State0 State,

SS.Status0 Status

From System_DISC SD

Join Services_DATA SS

on SS.MachineID = SD.ItemKey

Where SS.Name0 In (‘W3SVC’, ‘MsFtpSvc’, ‘TlntSvr’)

Order By ‘Machine Name’