Downstream WSUS Server Stops Working

A Downstream WSUS server stops working all of a sudden. Getting Error: Database Error. When you click Reset Server Node, it just shows the same error message. The "C:Program Files\Update Services\LogFiles\SoftwareDistribution.log" show an error msg "error CS0016: Could not write to output file 'c:Windows\Microsoft.NET\Framework64v\4.0.30319\Temporary ASP.NET Files\dssauthwebservice\fa6f6f92\482c00eb\App_global.asax.3bwpdosu.dll' -- 'Access is denied. " Simple fix in my... Continue Reading →


Find all Collections with Auto Incremental update

Powershell Script to find all collections with Auto Incremental Updates enabled. SQL Query to find Incremental Updates Select S.Name , S.Comment ,S.CollectionID ,s.CurrentStatus ,s.LastRefreshTime , CASE S.RefreshType WHEN 4 THEN 'Incremental Update ONLY' WHEN 6 THEN 'Incremental AND Full Evaluation' Else 'Unknown' End AS RefreshType From V_Collection as S Where RefreshType = '4' or... 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 →

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 ↑