Trevor Sullivan's Tech Room

Minding the gap between administration and development

SCCM Inventory – Group Policy Preferences

Posted by Trevor Sullivan on 2009/09/10

Update (2009-10-14): I’ve included a WQL query to use in creating a collection to identify systems without the GPP CSE installed.

If you want to discover which systems have the group policy preferences client-side extensions installed, you can add gpprefcl.dll to your software inventory policy on your ConfigMgr site server. This file resides in the System32 folder on a 32-bit OS, and in the SysWow64 folder on a 64-bit OS. The file description is “Group Policy Preference Client“.

Here is the WQL collection query I am using to identify Windows XP systems that do not have the GPP CSE installed:

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_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId 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 = “gpprefcl.dll”) and SMS_G_System_OPERATING_SYSTEM.Caption = “Microsoft Windows XP Professional” and SMS_R_System.Obsolete = 0


3 Responses to “SCCM Inventory – Group Policy Preferences”

  1. […] SCCM Inventory – Group Policy Preferences « Trevor Sullivan's Tech … […]

  2. […] Read the blog post here. […]

  3. ConfigMgr Inventory–Group Policy Preferences…

    Trevor Sullivan has a nice post over on his blog talking abo ……

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: