Migrating the SCCM database to a new SQL Server

One of the challenges as an SCCM Architect is to fix environments and bring them in line with best practices. This week’s challenges was the migration of the SCCM site database...

Gathering BIOS Version through SCCM

Scanning for BIOS information across the environment comes in handy when you realize you either have non stable versions or you have not updated the BIOS in a while. The following...

SCCM Stale Object Cleanup – Applications and Collections

Everyone knows that performing SCCM maintenance frequently is the key to a healthy SCCM experience. A lot of authors refer to tuning up the SCCM maintenance within the SCCM console but...

Understanding SQL Connections to your SCCM Database to improve performance

There are times when you may see degraded experience on loading your console and with the values refresh. The first few pointers that come to mind are: Configuration Network SQL If the...

SCCM Build Versions

Last update: 2018 February 28 System Center Configuration Manager Current Branch builds Build Number Description Release Date Description 5.0.8325.1000 2015 December 8 SCCM 1511 5.0.8325.1005 KB3125905 2015 December 30 FIX: “Browse Windows App Packages” dialog box is missing from SCCM version 1511 5.0.8325.1010 KB3122677 2016 February 4 FIX: Task...

SCCM Boundary Group to Boundary and Distribution Point Reporting

I have always found the need of good reports especially while upgrading or migrating environments. One of those is while upgrading the OS on all the Site Servers pre SCCM upgrade....

SCCM Duplicate CI cleanup

From time to time SCCM generates duplicate CI's and a SCCM Duplicate CI cleanup is recommended. I put together a WQL query to find all the duplicates within SCCM so I...

Office 32 vs 64 bit SQL Reporting

When performing Office 365 upgrades it usually becomes necessary to inventory your current environment for installed Office 32 vs 64 bit installations to verify you upgrade them to their respective architectures....

SCCM Monthly Patching Scheduling Practice

Over the years, I have seen plenty of organizations with multiple variations of patching schedules. During this period, I have found a schedule that adheres to security requirements while simultaneously incorporating...

SCCM Query Collection

Here are some useful queries for System Center Configuration Manager that you can use to create collections. These collections demonstrate different queries you can use to create all the collection you...