SOLVED Create a device collection with IIS enabled

[e771ca]

Hi Everyone,

I tried to create a device collection with IIS enabled, I tried a few things but no luck. Any help is much appreciated.

Thanks

 

[Garth]

Hi Everyone,

I tried to create a device collection with IIS enabled, I tried a few things but no luck. Any help is much appreciated.

Thanks

What have you tried? Try looking for the devices with the service name.

 

[e771ca]

What have you tried? Try looking for the devices with the service name.

I tried below but keep getting a warning about syntax error. I ended up being able to use the building report to pull the report, so I think I am good, but if you are free, can you let me know what I did wrong with below?

select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SERVICE.Name = “W3SVC”

Thanks

 

[Prajwal Desai]

I am going to test this in my lab and confirm the correct IIS WQL query.

 

[Prajwal Desai]

Here is a post on creating a device collection for IIS enabled servers: https://www.prajwaldesai.com/device-collection-for-iis-servers-sccm/