Category Archives: System Center

All articles about Microsoft System Center range of products.

SCCM – Create a device collection based on Exchange Server role

By | April 17, 2023

Following on from our recent posts for Configuration Manager collection queries, we have another one here for all devices that are Microsoft Exchange servers. Go ahead and create a new device collection and then use this query: select * from SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SERVICE.Name like “Microsoft Exchange%” Save the… Read More »

Java 8 Update 161 MSI Installers and Offline Installers for x86 and x64 Browsers Released

By | April 17, 2023

We have now uploaded to our Filestore microsite the MSI installers and Offline Installers for the latest Java version release. The versions that have been added are: Java 8 Update 161 x86 MSI Installer Java 8 Update 161 x64 MSI Installer Java 8 Update 161 x86 Offline Installer Java 8 Update 161 x64 Offline Installer… Read More »

SCCM – Hardware and Client Version SQL Query

By | April 17, 2023

If you are looking for a SQL query to pull back hardware inventory information and the SCCM client version, then you can use the below to pull all this information together. SELECT S.Name0 as Name, S.Client_Version0 as [Cient Version], OS.Caption0 as [Operating System], CS.Manufacturer0 as Manufacturer, CS.Model0 as Model, PB.SMBIOSBIOSVersion0 as BIOS, PR.Name0 as CPU,… Read More »

SCCM – Differences between Add Remove Programs Database Tables

By | March 30, 2023

We had seen a few posts around the internet where people are asking the differences between the various Add_Remove_Programs data within the System Center Configuration Manager database. So we thought we would post a quick reference here to confirm which table of data means what. There are five different tables of data available to you… Read More »

Updates fail or time out when WSUS is used during an MDT or SCCM capture

By | April 1, 2023

This guide assumes that you use Microsoft Deployment Toolkit (MDT build 8443) or Microsoft System Center Configuration Manager (SCCM) capturing Windows 10. You capture a task sequence, and the capture computer does not have Internet access. When the task sequence is running and the computer is checking for updates (pre-application installation), the installation freezes for… Read More »

Windows 10 1709 Fall Creators Update – SCCM Build and Capture Task Sequence Failing

By | April 1, 2023

We recently had put together a SCCM Build and Capture task sequence to update our images up to Windows 10 version 1709. We copied the install.wim from the sources folder of the Windows 10 v1709 ISO and added this as our operating system capture image. We took our existing task sequence (which has lots of… Read More »