Adobe Flash Player MSI Installers Package v29.0.0.140

Adobe Reader DC version 2001

Adobe have released another update to their Adobe Flash Player software, this time taking it up to version As always, you can download the executable file but if you want the MSI files so that you can load it into your Configuration Manager Software Catalog or deploy via Group Policy, then you can download … Read more

KB4093118 & KB4093108 – Another Faulty Windows Update Released by Microsoft

Microsoft Blue Logo

Microsoft have yet again released another Windows Update which has caused corruption and crashing on Windows computers. We have particularly hit with issues on Windows 7 machines. Although there are reported issues with Server 2008 R2 as well. So, having spent a few hours searching for todays culprit, we found that the update causing the … Read more

SCCM – Autodesk 2019 Serial Number MOF Collection Update

Autodesk Transparent Logo

We have now updated our SCCM Autodesk serial number MOF collection script to include the recently released AutoCAD 2019 and AutoCAD LT 2019. The following additions have been made to the script: AutoCAD 2019 – English AutoCAD LT 2019 – English The full instructions on how to use this script can be found below: Instructions … Read more

SCCM – User Experience During Application Installation

System Center Configuration Manager SCCM

If you want your end user experience to show them the progress of an installation from your Software Center, then you will need to ensure that you have your command lines and user experience tab setup correctly. We have seen many people follow the “install in the background and don’t tell anyone the progress” method … Read more

SCCM – 1802 Upgrade Released & How to get it now!

System Center Configuration Manager SCCM

So Microsoft have today released version 1802 of Current Branch for Configuration Manager. This is great and there are some features in this upgrade that we are looking forward to trying out. But, on the slow ring, it could be a few days or weeks until it drops into your Configuration Manager Console. That’s bad. … Read more

SCCM – Active Directory Security Group Query for User Collection

microsoft black logo

If you are looking at setting up a SCCM user collection based on membership of an Active Directory Security Group, then you can use this WQL query for the collection. WQL Script To set this up, create a new collection and copy and paste this as its query: Variables You can add or remove any … Read more

SCCM – SQL Queries for Make, Model and Architectures of Devices

System Center Configuration Manager SCCM

These simple SQL queries can be used to pull data from the Configuration Manager database to provide you with a count of all make, model and architecture devices in your business. Instructions To get this information, open a new query within SQL Server Management Studio and copy and paste the query that you wish to … Read more

How to create correct partitions to deploy a Windows image to a UEFI based device

microsoft black logo

We have recently come across an issue when trying to deploy a test virtual machine using Hyper-V (Generation 2 – UEFI) that once you have selected your task sequence, you get an error and the task sequence bombs out. This is because we had not setup the correct drive partitions to be able to deploy … Read more

Adobe Flash Player MSI Installers Package v28.0.0.161

Adobe Flash Player MSI Package

Adobe have released another update to their Adobe Flash Player software, this time taking it up to version As always, you can download the executable file but if you want the MSI files so that you can load it into your Configuration Manager Software Catalog, then you can download them from our site right … Read more

Java Silent Installation and MSI Extraction Instructions


There are two methods to deploying Java Clients, using MSI or Offline Installation files. This guide will step you through the process of gathering and using both. Offline EXE Silent Installation Instructions You will need to use the Offline Installer that is available from our Java MSI Archive and then add on the parameters that you require for … Read more

SCCM – Create user collections based on Active Directory department attribute with Powershell

sccm logo

We recently built a new Configuration Manager system for a client who wanted user collections for all departments and companies within their corporate group. We were going to set these up manually which is a fairly simple, but time consuming, job to do. But this was a time restricted installation so we had a quick … Read more

SCCM – Create a device collection based on Exchange Server role

sccm logo

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

SCCM – Create a device collection based on Domain Controller role

microsoft black logo

We have another WQL query here for you today to enable you to create a Configuration Manager collection based on whether a device is used as a domain controller. Go ahead and create a new device collection and then use this query: Save the query and you should now see a collection of all your … Read more

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

Java MSI

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


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 SQL Query for Software not in Add Remove Programs

sccm logo 600x400

If you are looking for an SCCM SQL query to create a report to search for machines which do not have a particular software installed, you can use the following: Then you can use the variable @displayname to choose from a drop down of software that is in the SCCM database pulled from client machines. … Read more

SCCM – Differences between Add Remove Programs Database Tables

microsoft black logo

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

microsoft black logo

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

Blue and White Windows 10 Logo

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