gamehead200
Oct 23 2008, 10:45 AM
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,
gamehead200
Oct 25 2008, 07:48 PM
In case anyone wants to know what the query was, here it is:
CODE
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