How to extend the MDT 2010 database with custom settings

Add a new column to the settings table (can be done with SQL Management Studio)   Give it a name and specify a datatype   Run the following stored procedure against the MDT database EXECUTE sp_refreshview ‘[dbo].[ComputerSettings]’ EXECUTE sp_refreshview ‘[dbo].[LocationSettings]’ EXECUTE sp_refreshview ‘[dbo].[MakeModelSettings]’ EXECUTE sp_refreshview ‘[dbo].[RoleSettings]’ Edit the customsettings.ini with the new column Under the…


Setup PXE service point on Windows Server 2008 R2

Install Windows Deployment Services (WDS) Start Administrative Tools \ Windows PowerShell Modules (Run as Administrator) > Add-WindowsFeature WDS > WDSUTIL /initialize-server /reminst:<X>:\Remoteinstall If WDS is running on the same box as DHCP: > WDSUTIL /set-server /DHCPoption60:yes > WDSUTIL /set-server /usedhcpports:no Add the PXE service point Distribute both x64 and x86 Boot Images to both SMSPXEIMAGES$…


Enable detect HAL on a 2008 R2 VHD image

To enable detect HAL on a VHD file: Attach the image and assign it a drive letter e.g. R: Run “BCDEDIT /STORE R:\BOOT\BCD /SET {default} DETECTHAL ON” from a command prompt Detach the image Done


Use PowerShell to execute wmi queries (WQL)

By using Get-WmiObject in powershell it’s possible to perform WMI queries in WQL   One example: gwmi -Query “SELECT * from Win32_DiskPartition WHERE Bootable = TRUE”


Configure IIS Response Buffering Limit on ConfigMgr reporting points

 If you get a HTTP 500 error when trying to watch a report e.g “History – Specific task sequence advertisements run on a specific computer” With show friendly HTTP error messages enabled in IE:The website cannot display the page  HTTP 500  This error (HTTP 500 Internal Server Error) means that the website you are visiting…


Collection membership rule to check for clients that are members of multiple AD groups

The following collection query will list all clients that are part of the following AD groups: “APP-1” and “APP-2”.  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 where SMS_R_System.ResourceId in (Select ResourceID from SMS_R_System where SMS_R_System.SystemGroupName LIKE “%\\APP-1”) and SMS_R_System.ResourceId in (Select ResourceID from SMS_R_System where SMS_R_System.SystemGroupName LIKE “%\\APP-2”) The following query does the same and also excludes all…

Some packages will not download from BITS enabled distribution points in ConfigMgr 2007

If a package has folders that contains characters like “+” or “-” there can be problems on BITS-enabled distribution Points. The package will not download and only the folder structure will be created in the client cache.    To troubleshoot on the client from a command prompt run: “bitsadmin /list /allusers”   {92C8E35D-7B11-4B1B-885A-350C7B2AFE32} ‘CCMDTS Job’ ERROR…