Posts

Showing posts from November, 2012

Collection of computers that don't have software X installed

Code : 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 where SMS_G_System_COMPUTER_SYSTEM.Name not in (select distinct SMS_G_System_COMPUTER_SYSTEM.Name 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_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Adobe Reader 8%") Documentation Sometimes you want to create a collection that will find all the computers that don't have a particular software installed and push it to it. This is a good dynamic way to create a collection instead of direct computer addition. Assuming

SCCM OSD Task sequence fails installing Windows updates.OSD Hangs on “Installing Updates” Step

Image
Issue:     SCCM OSD Task sequence fails installing Windows updates.OSD Hangs on “Installing Updates” Step Error:   When this happens, the task sequence Installation Progress dialog displays "Downloading 1 of x Updates (0% complete) ..." with no change in the progress bar. If you look at the smsts.log file during this time, you'll see the following entries and the last entry repeats: // Installing all updates targetted for this computer Installation of updates started Waiting for installation job to complete Waiting for job status notification ... Waiting for job status notification ... Waiting for job status notification ...  Resolution: Step 1. Download the correct Hotfix from http://support.microsoft.com/kb/2509007?wa=wsignin1.0 Step 2. Install the hotfix on the Site Server Close the Configuration Manager Console if it is open. Start an administrative command prompt by right clicking on it and choose Run as Administrator . Browse to where the fil