This SQL query will list all of the machines that have the World Wide Web Publishing Service, the FTP Publishing Service or the Telnet server services installed by their Service name.
SQL Query:
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'
No Comments