gamehead200 Posted October 23, 2008 Share Posted October 23, 2008 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, Link to comment Share on other sites More sharing options...
gamehead200 Posted October 26, 2008 Author Share Posted October 26, 2008 In case anyone wants to know what the query was, here it is:select v_R_System.Name0from v_R_Systemjoin v_GS_SERVICE on v_GS_SERVICE.ResourceID = v_R_System.ResourceIDwhere 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now