IIS Report

[Ron]

I would like to create a report that will show ALL servers that are running IIS, IIS version, server name, OS Version, and IP. I am new to Lansweeper so if it already has this report please forgive me.

[Cam]

You guys are awesome! This is helping me with a report that I need. However, I have several servers that do not have the inetinfo.exe file. I instead have it Custom Scan for %windir%\system32\inetsrv\inetmgr.exe and edited the script above to reflect:

Where tblFileVersions.FilePathfull Like '%inetmgr%') SubQuery1


I also had a few exceptions to this where only inetmgr6.exe existed, but I just know that those are IIS6 for now.

[Daniel_B]

One the post above there is a comment about IIS. You need to set up custom file scanning for %windir%\system32\inetsrv\inetinfo.exe. For details on how to use custom file scanning, please refer to this KB article. After setting this up and rescanning your hosts, the IIS version will be displayed in the report.

[sandwind]

Hello,

WOW! I really looking for this. This is work and save my a lot of time!

BTW, IIs version not show... Can u please update?

Thanks,
-Haksun

[Susan_A · Accepted solution]

IIS version numbers aren't listed in Add/Remove Programs, so will not be retrieved by software scanning. This discussion seems to suggest that you can scan the file properties of inetinfo.exe to retrieve the IIS version number. General instructions for scanning file properties with Lansweeper can be found here.

When you've scanned the file properties of the aforementioned file, you can run the report below to list the information you are after. Instructions for running reports can be found here.

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.IPAddress,
  tsysOS.OSname,
  tblOperatingsystem.Caption As FullOSname,
  tblAssets.SP,
  SubQuery1.FileVersion As IISversion,
  tblAssets.Firstseen,
  tblAssets.Lastseen
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tblOperatingsystem
    On tblAssets.AssetID = tblOperatingsystem.AssetID
  Left Join (Select tblFileVersions.AssetID,
    tblFileVersions.FileVersion
  From tblFileVersions
  Where tblFileVersions.FilePathfull Like '%inetinfo%') SubQuery1
    On SubQuery1.AssetID = tblAssets.AssetID
  Inner Join tblServices On tblAssets.AssetID = tblServices.AssetID
  Inner Join tblServicesUni On tblServicesUni.ServiceuniqueID =
    tblServices.ServiceuniqueID
Where tblServices.Started = 1 And tblAssetCustom.State = 1 And
  tblComputersystem.Domainrole > 1 And tblServicesUni.Name Like '%W3SVC%'
Order By tblAssets.Domain,
  tblAssets.AssetName