Hey everyone,

I'm having some trouble putting together a report in SCCM 2007. What I want to do is basically generate a list of all servers that currently have IIS installed and I need the proper SQL statement to pull this information. Note, this is my first time attempting to create a new report, so I'm pretty new to this.

Any help will be appreciated.

Thanks,

In case anyone wants to know what the query was, here it is:

select v_R_System.Name0
from v_R_System
join v_GS_SERVICE on v_GS_SERVICE.ResourceID = v_R_System.ResourceID
where v_GS_SERVICE.DisplayName0 like 'World Wide Web Publishing%' and v_R_System.Operating_System_Name_and0 like '%Server%'
Order by v_R_System.Name0