Device Collection by Internet Explorer version

Microsoft often release security bulletins that are specific to certain versions of Internet Explorer, or you may want to target machines running a specific version for a software update such as upgrading from that well loved favourite, IE6. SCCM allows you to arrange your machines into device collection automatically according to which Internet Explorer version they have installed. Please be aware when copy and pasting this code you may need to replace the quote marks, as this can cause a syntax error. You need to create a device collection that describes how you want the machines arranged. For instance, if you want to target machines that are not running Internet […]

Continue reading »

Separating Windows 7 machines by platform

If you need to separate your Windows 7 machines into device collections separating them into 64-bit and 32-bit collections, this can be done using the following rules. First, create two collections, one for each platform. Please be aware when copy and pasting this code you may need to replace the quote marks, as this can cause a syntax error. For the x64 collection use the following incremental query rule: 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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.SystemType = “x64-based PC” and SMS_G_System_OPERATING_SYSTEM.Caption like “Microsoft Windows 7%” For the x86 collection use the following incremental query rule: 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 […]

Continue reading »