SCCM collection by IE version

Could SCCM create collections by IE vesion? (ex:  one collection for clients with IE8 and another collection for clients without IE8 )

Thanks!

May 13th, 2011 10:44am

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.%”)

more Via http://eskonr.com/2010/04/sccm-reportcollection-for-computers-with-internet-explorer-with-different-versions/

May 13th, 2011 12:11pm

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.
Free Windows Admin Tool Kit Click here and download it now
May 21st, 2014 4:40pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics