Configuration Manager PXE boot causes Windows Deployment Services to crash

Symptoms You use a System Center Configuration Manager PXE service point (Configuration Manager 2007) or a Pre-Boot Execution Environment (PXE) distribution point (Configuration Manager 2012) to perform PXE boots. In this situation, the operation first appears to work successfully, but then the process stops running. When you examine the server on which the PXE service... Continue Reading →


SCCM Report to get All Site Server & System with there Roles

select distinct sys1.ServerName, sys5.Caption0 as ‘Operating System’, CASE sys4.SystemType0 WHEN ‘x64-based PC’ THEN ‘x64’ WHEN ‘x86-based PC’ THEN ‘x86’ END as ‘Type’, sys2.SiteCode as ‘Site Code’, sys2.SiteName as ‘Site Name’, sys2.ReportingSiteCode as ‘Parent Site Code’, (select CASE sys3.RoleName WHEN ‘SMS Site Server’ THEN NULL WHEN ‘SMS Component Server’ THEN NULL WHEN ‘AI Update Service Point’... Continue Reading →

Queries for Boundary,Boundary Groups and Devices info

Query Devices,IP Address and IP Subnet per Device select distinct A.Name0 as 'PC Name',c.IPAddress0 as 'IP Address',D.IP_Subnets0 as 'IP Subnet' from v_R_System A inner join v_FullCollectionMembership B on A.ResourceID=B.ResourceID Inner join v_GS_NETWORK_ADAPTER_CONFIGUR C ON A.ResourceID=C.ResourceID Inner Join v_RA_System_IPSubnets D ON A.ResourceID=D.ResourceID where CollectionID='SMS00001' and C.IPEnabled0='1' group by A.Name0,c.IPAddress0 ,D.IP_Subnets0 order by A.Name0,c.IPAddress0 ,D.IP_Subnets0 Get all... Continue Reading →

How to find quick compliance percentage of Patch MS17-010 in your environment?

select catinfo.CategoryInstanceName as Vendor0, ui.ArticleID as ArticleID, ui.BulletinID as BulletinID, ui.Title as Title, NumPresent as Present, NumMissing as Missing, NumNotApplicable as NotApplicable, NumUnknown as Unknown, NumTotal as Total, PCompliant=convert(numeric(5,2), (isnull(NumPresent, 0)+isnull(NumNotApplicable, 0))*100.0 / isnull(nullif(NumTotal, 0), 1)), PNotCompliant=convert(numeric(5,2), (isnull(NumMissing, 0))*100.0 / isnull(nullif(NumTotal, 0), 1)), PUnknown=convert(numeric(5,2), (isnull(NumTotal - (isnull(NumPresent, 0)+isnull(NumMissing, 0)+isnull(NumNotApplicable, 0)), 0))*100.0 / isnull(nullif(NumTotal, 0), 1)),... Continue Reading →

SCCM 1606 – An update is stuck with a state of Downloading in the Updates and Servicing node of the Configuration Manager console

During the automatic download of updates by an on-line service connection point, an update can become stuck with a stat of Downloading. When the download of an update is stuck, entries similar to the following appear in the indicated log files: DMPdownloader log: ERROR: Failed to download redist for 037cd17e-4d7b-40e1-802b-14bb682364c7 with command /RedistUrl /LnManifestUrl... Continue Reading →

Software Update Content Cleanup in System Center 2012 Configuration Manager

In System Center 2012 Configuration Manager, we’ve added the capability to automatically remove software update content from distribution points when that content is related to expired updates. This process helps manage drive space on your distribution points by removing any content you no longer need. It’s particularly helpful for Endpoint Protection definition updates, given their... Continue Reading →


Had an issues where a SCCM 2012 Primary Site did want to install/re-install the SMS_SITE_SQL_BACKUP_[SITESERVER-FQDN] component. Got errors that the Installation path did not exist.This was easy to correct. Change the string named value “Installation Directory” in the key HKEY_LOCAL_MACHINESOFTWAREMicrosoftSMSComponentsSMS_SITE_COMPONENT_MANAGERMultisite Component Servers[DB-SERVER-FQDN] with [DB-SERVER-FQDN] being the placeholder for the FQDN of the database server hosting... Continue Reading →

List of WMIC CSProduct Get Name Results

List of WMIC CSProduct Get Name Results This page (sorted by Vendor and Model number) shows the results of running the WMIC CSProduct Get Name command from a Command Prompt to retrieve the model name from WMI. You can then use this in an Apply Driver Package Task Sequence step to only present the the... Continue Reading →

Procedure to recover GUI in windows 2012 and 2012R2 & .Net Framework feature dependency in windows 2012/2012 R2

Windows Server 2012 includes .NET Framework 4.5 and Windows Server 2012 R2 includes .NET Framework 4.5.1. The .NET Framework provides a comprehensive and consistent programming model to build and run applications (including Roles and Features) that are built for various platforms. Windows Explorer (Graphical Shell), Server Manager, Windows PowerShell, IIS, ASP .NET, Hyper-V, etc, are... Continue Reading →

Replacement for BGInfo during OS Deployment – Works in full OS on later Windows.

OSDBackground.exe is a small, and easy to configure, WPF Application that replaces BGInfo as wallpaper generator during OS deployment with SCCM. It requires Powershell and DotNet as Boot image Optional components. OSDBackground.exe can run in password protected debug mode, making the built-in F8 Command line support less necessary. The downloadable package includes the application itself... Continue Reading →

SQL Report to list Boundary Group with Site System Details

select sys1.Name, sys1.DefaultSiteCode, (select SUBSTRING(sys2.ServerNALPath, CHARINDEX('\\', sys2.ServerNALPath) + 2, CHARINDEX('"]', sys2.ServerNALPath) - CHARINDEX('\\', sys2.ServerNALPath) - 3 ) + CASE sys2.Flags WHEN '1' Then ' (Slow)' WHEN '0' THEN '' END + '; ' as 'data()' from vSMS_BoundaryGroupSiteSystems as sys2 where sys1.GroupID=sys2.GroupID for XML path('')) as 'Site System', (select sys4.Value + '; ' as 'data()' from... Continue Reading →

Blog at

Up ↑