cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Srikanth08
Engaged Sweeper II
Hi,

i need one report query to find what webservers are running in my network like IIS, Apache with its version, hostname and IP details.
Regards, Srikanth08
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
You could build a report to find specific web server services that are running, but you'll need to do some research to find the service names. A sample report for a specific service can be seen below. (Replace what's highlighted.)

The web server version won't be detected unless it's listed in Add/Remove Programs. You could try custom file or registry scanning to detect the version numbers.
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblServicesUni.Caption
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblServices On tblAssets.AssetID = tblServices.AssetID
Inner Join tblServicesUni On tblServicesUni.ServiceuniqueID =
tblServices.ServiceuniqueID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblServicesUni.Caption Like '%service display name%' And tblServices.Started = 1
And tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName

View solution in original post

1 REPLY 1
Susan_A
Lansweeper Alumni
You could build a report to find specific web server services that are running, but you'll need to do some research to find the service names. A sample report for a specific service can be seen below. (Replace what's highlighted.)

The web server version won't be detected unless it's listed in Add/Remove Programs. You could try custom file or registry scanning to detect the version numbers.
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblServicesUni.Caption
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblServices On tblAssets.AssetID = tblServices.AssetID
Inner Join tblServicesUni On tblServicesUni.ServiceuniqueID =
tblServices.ServiceuniqueID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblServicesUni.Caption Like '%service display name%' And tblServices.Started = 1
And tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName