I'm playing around with SCCM queries and collection and one thing that I was asked was to see if I can write a query that produces all the websites that are running in our environment, leaving out the default websites. Does anyone know how to do that, I have been looking online for a similar query and I haven't been able to find one, what I am being asked is to find the following, websites, what servers they are on and what IP they are using. This may be a shot in the dark, but I think it would be great if we could identify all of those.

Pulling in the servers and a ipaddress for them should be easy, I am not so sure about the Websites. You might be able to query WMI for it, create an extension in the SMS_def.mof file to pull them in.http://www.sccm-tools.com http://sms-hints-tricks.blogspot.com

ok connect to this WMI repositoryroot\microsoftiisv2look in IISWEbServer (ids but no names) or IISWebService But look down the list and see if one will give you the actual IIS namehttp://www.sccm-tools.com http://sms-hints-tricks.blogspot.com

Thanks, I think that should do it.

Have to be a little careful with that... I found that on Server2008 anyway, you could have IIS running but not have installed the IIS Management tools. Without the tools, you didn't get that namespace. So I couldn't 100% rely on it being there for a particular DCM baseline I needed to run. Now, most of the time the IIS mgmt tools will be installed; so it likely won't be a problem. But just something to keep in mind, in case you find that some machines don't report what you think they should.But if that namespace *is* there, yes, that's perfect. Everything you need to know will be in there.Standardize. Simplify. Automate.