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
Order by a.Name0,c.FileVersion
Where do you run the report from?
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 .
It throws an error no such system v_R_System ?
Is there a way you can correct the query?
can you post the screenshot of the error code? did you select the right database to run the query?