Webservers in Linux and Windows

[SHib11]

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.

[Esben_D]

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.