ConfigMgr–Creating A Collection For All Systems Not Approved

Saw this past by on the MSSMS list today and thought it was good info.  Thanks to Brandon Linton for contributing it. Collection query: 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_CM_RES_COLL_SMS00001 on SMS_CM_RES_COLL_SMS00001.ResourceId = SMS_R_System.ResourceId where SMS_CM_RES_COLL_SMS00001.IsApproved<>’1′

ConfigMgr Software Updates and OSD (Revisited)

Fellow colleague and MVP Jason Sandy’s has written a great post on Software Updates in ConfigMgr.  Read his post here. Here’s a quick intro: As many folks know, there is a known issue with Software Updates in Windows 7 Task Sequences: There is no official word of a fix for this issue which by…

Changes to Microsoft Core CAL(FEP)

It appears there are going to be some changes to the Microsoft Core CALs.  It appears Microsoft Forefront Endpoint Protection will be included in the Microsoft Core CAL suite planned August of 2011. Notice how the word appears is my disclaimer word since I can’t speak for Microsoft. Screenshot below from: