Case Study: The updates returned from the Windows update are less than what is returned from the Reports they are using in ConfigMgr.

Hi Folks, This post is about a case study that illustrates the troubleshooting steps taken to modify an existing custom ConfigMgr report to return the correct results when compared to Windows update when checked on Internet. I have included the details and the path taken to achieve the same.  Issue: The updates returned from the…

2

WSUS: Using change.log to track updates that were declined (with scenarios)

  Hello Folks, Many a times we do get some issues where we need to find why an update was installed, or Update that were declined soon after an incorrect deployment. The below blog post illustrates the different scenarios recorded in the change.log when an update is declined. The good thing to notice here is it…

1

ConfigMgr: Troubleshooting High CPU utilization on the SQL server and Parallelism

  Hello Folks, This post is about troubleshooting CPU utilization of SQL Server hosting the ConfigMgr database. It talks about the general queries to find out the causes and talks specifically about parallelism.   To check which query is taking the Max CPU time run the following query     SELECT TOP 50 ObjectName =…

7