→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper II
I'm very sorry I'm not familiar with SQL.

I am hoping someone would be able to point me in the right direction.
Ideally I would like to create a report which will shows all servers (windows or linux) running webservers.

if not then 2 reports, one showing all Windows with IIS and the second with Linux servers running Apache (httpd)

The report should have:
Server Name, Domain, IPAddress, OS name, Full OSname, SP,IIS or Apache Version, Service started (yes/no), First Seen, Last Seen.

Thank you in advance.
Lansweeper Employee
Lansweeper Employee
For the services, you'll need the following tables:
  • tblServices
  • tblServiceState
  • tblServiceUni
To simply detect if the IIS feature is enabled, you can take a look at the features which are stored in the following tables:
  • tblFeature
  • tblFeatureUni
As for Apache, you'll have to check if it is scanned on your Linux assets. I can't really test that since I don't have a Linux machine. I do know that service statuses on Linux are not scanned.