Could SCCM create collections by IE vesion? (ex: one collection for clients with IE8 and another collection for clients without IE8 )
Thanks!
Technology Tips and News
Could SCCM create collections by IE vesion? (ex: one collection for clients with IE8 and another collection for clients without IE8 )
Thanks!
Yes, you may build a collection based on query.
Try those queries based on discussion below:
http://social.technet.microsoft.com/Forums/en-US/configmgrosd/thread/b13a60f4-4053-46a7-a5ee-c7d16c97faec
try this for computers whcih doesnt have IE8:
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 where SMS_R_System.ResourceId
not in (select SMS_R_System.ResourceId from SMS_R_System inner join
SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId
where SMS_G_System_SoftwareFile.FileName = “iexplore.exe” and SMS_G_System_SoftwareFile.FileVersion like “8.%”)
When I try and copy and paste this query statement I get a syntax error.try this for computers whcih doesnt have IE8:
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 where SMS_R_System.ResourceId
not in (select SMS_R_System.ResourceId from SMS_R_System inner join
SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId
where SMS_G_System_SoftwareFile.FileName = iexplore.exe and SMS_G_System_SoftwareFile.FileVersion like 8.%)