Step-by-step guide to install Configuration Manager 2012 SP1 R2

Steps to perform on primary domain controller (DC) Extend AD schema Log in using a domain admin account Insert ConfigMgr 2012 SP1 DVD Open a command prompt window Type D:\SMSSETUP\BIN\X64\EXTADSCH.EXE and press Enter. Wait for a confirmation message in CMD window and then check for the existence of ExtADSch.log file in the root of C: … Continue reading Step-by-step guide to install Configuration Manager 2012 SP1 R2

Despooler failed to merge delta to the compressed package. Error 112.

Symptoms You make changes to a package and update your distribution points. Shortly you receive error messages in Component Status for SMS_DESPOOLER component. Status message details is similar to the following: Cause The destination drive where site server is uncompressing the package is full. Resolution If you don’t know the drive where the package is … Continue reading Despooler failed to merge delta to the compressed package. Error 112.

Uncheck “Install new versions automatically” in Internet Explorer 10 during deployment

IF you during deployment you want to easily uncheck “Install new versions automatically” feature, there is a registry setting you can configure prior to actual IE setup.exe or msi, whatever you use. Copy the following text to a notepad and save it as a REG file. Then use REG IMPORT “Disable_AutoUpdate.reg” before you deploy your … Continue reading Uncheck “Install new versions automatically” in Internet Explorer 10 during deployment

Find computer name for a remote computer using PSExec

Let’s say you know the IP address of a computer but you don’t know the hostname. Seems to be an easy task with ping –a, if you have a working DNS If not, you can try the following approach: Create a cmd on client’s computer. Say in \\IP\C$\Windows\Temp\FindHostname.cmd Edit FindHostname.cmd. Type in: echo %computername% >> … Continue reading Find computer name for a remote computer using PSExec

Collection with Windows 7 computers without SP1

First, if you want your query to display the right information, you must have a collection with all Windows 7 computers, regardless of the service pack version installed. Here is the simplest query to create “All Windows 7 computers” collection (please make this collection “Not collection limited”): 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 … Continue reading Collection with Windows 7 computers without SP1

Create a report to count all computer models and manufacturer for computers inside a specific collection

SELECT dbo.v_GS_COMPUTER_SYSTEM.Manufacturer0 AS Manufacturer, dbo.v_GS_COMPUTER_SYSTEM.Model0 AS Model, COUNT(dbo.v_GS_COMPUTER_SYSTEM.Model0) AS Total FROM dbo.v_GS_COMPUTER_SYSTEM INNER JOIN dbo.v_FullCollectionMembership ON dbo.v_GS_COMPUTER_SYSTEM.ResourceID = dbo.v_FullCollectionMembership.ResourceID GROUP BY dbo.v_GS_COMPUTER_SYSTEM.Model0, dbo.v_GS_COMPUTER_SYSTEM.Manufacturer0, dbo.v_FullCollectionMembership.CollectionID HAVING (dbo.v_FullCollectionMembership.CollectionID = ‘CollectionID’) ORDER BY Total DESC, Manufacturer, Model