In my MEMCM primary site I had several distribution points that were still running Windows Server 2012 R2, so I decided to run an in-place OS upgrade on them to bring them up to Server 2019. After reading the MS Docs, I concluded this is a supported scenario and things would go smoothly. I was … Continue reading Real world notes: In-place OS upgrade on Server 2012 R2 ConfigMgr distribution points
Category: Windows Server
Find the Full Windows Build Number with PowerShell
Much to my surprise I discovered that the full build number for a Windows OS is not stored in WMI in the usual Win32_OperatingSystem class. In Windows 10 at least, the full build number containing the "UBR", or essentially the CU patch level of the build, is a useful piece of information. Open Settings > … Continue reading Find the Full Windows Build Number with PowerShell
Automatically Set SQL MaxServerMemory on Cluster Failover with PowerShell
On a two-node Windows Failover Cluster, I have two SQL instances installed. Each instance runs on its own node in the cluster, so that it can make maximum use of the available memory on that server. However, when a failover occurs, it is necessary to reduce the maximum server memory setting for both instances, so … Continue reading Automatically Set SQL MaxServerMemory on Cluster Failover with PowerShell
Finding the ‘LastLogon’ Date from all Domain Controllers with PowerShell
In an Active Directory environment, probably the most reliable way to query the last logon time of a computer is to use the Last-Logon attribute. The Last-Logon-Timestamp attribute could be used, but this will not likely be up-to-date due to the replication lag. If you are using PowerShell, the LastLogonDate attribute can also be used, however … Continue reading Finding the ‘LastLogon’ Date from all Domain Controllers with PowerShell
Translating Error Codes for Windows and Configuration Manager
As a Windows and Configuration Manager administrator, I often come across error codes that need translating into their more friendly descriptions. In Configuration Manager, sometimes these codes are translated for you in the log files, reports and the ConfigMgr console, but sometimes they are not. Sometimes they will be in decimal format, and sometimes hexadecimal. … Continue reading Translating Error Codes for Windows and Configuration Manager
Creating Dynamic Reports for Configuration Manager with Microsoft Excel
Today I reached 10,000 hits on my blog, very cool, and what better way to celebrate than with a new post 🙂 Thanks to everyone who has stopped by, I hope that you have found something helpful and continue to do so! In today's post, I want to look at how to create dynamic reports for … Continue reading Creating Dynamic Reports for Configuration Manager with Microsoft Excel
Monitoring Disk Space and Content Directories on ConfigMgr Distribution Points
Recently I noticed that the available disk space on my ConfigMgr distribution points was getting low. Since they are mostly VMs using SAN storage it’s fairly easy to increase the disk space, but it got me thinking about how I could monitor the DPs for available free space, as well as the sizes of the … Continue reading Monitoring Disk Space and Content Directories on ConfigMgr Distribution Points
Installing and Configuring WSUS with Powershell
In setting up our SCCM 2012 infrastructure, I decided to patch our OS deployments using WSUS instead of SCCM Software Updates. Since we have multiple distribution points in different geographical areas, I decided to install a WSUS server in each location where we do deployments. Granted, installing and configuring WSUS is not the most technically … Continue reading Installing and Configuring WSUS with Powershell