SCCM report for Computers with IIS installed on servers

Hi all ,Another report to find out the servers where IIS is installed with the version of it.this assumes that ,you have enabled the inventory agent and set the properties for .exe to not exclude windows folder.If you select exclude files from windows directory,you will not see any results in the report because inetmgr.exe will be located in windows folder.

select distinct a.Name0,c.FileVersion from v_R_System a inner join
v_GS_SERVICE b on b.ResourceID = a. ResourceID inner join
v_GS_SoftwareFile c on c.ResourceID=a.ResourceID
where b.DisplayName0 like 'World Wide Web%' and
a.Operating_System_Name_and0 like '%Server%'  and
c.FileName ='inetmgr.exe'
Order by a.Name0,c.FileVersion 

4 Responses to "SCCM report for Computers with IIS installed on servers"

    1. I know the post is very old and was create in SCCM 2007 and software inventory works great there (filename) and faster but in CM12 and above, software inventory is very slow and takes hours to completed which is not good.
      You can make use of compliance baseline to create one CI to detect IIS .



Leave a Reply