If you are using SCCM to update your Microsoft devices, then you may have noticed the large amount of Products that are available under the Software Update Point (SUP) configuration. I’ve struggled to find good explanations for each of the products so my plan is to find out as much information as I can for […]
System Center
All articles about Microsoft System Center range of products.
Notepad++ MSI Installers
As you may know, there is no native MSI installer for Notepad++ available from the developers. However, MSI installers are excellent for using with deployment systems such as Microsoft Endpoint Configuration Manager (MEMCM), MDT, and Group Policy. We are happy to provide packaged MSI installers for Notepad++ and here you will find all the versions […]
Reporting on Office 365 Channels with SQL Query
If you’re responsible for managing Office 365 deployments within your organization, having visibility into which channels your devices are using is crucial for effective administration and maintenance. With the help of SQL queries, you can extract pertinent information from Configuration Manager data, allowing you to generate insightful reports or visualize data using tools like Power […]
SCCM – SQL Queries for Make, Model and Architectures of Devices
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 […]
30 Useful SCCM SQL Queries
I’ve been creating a lot of collections with our SCCM recently, so I thought I would share the ones we thought were most useful: Show all computers in SCCM: Show all computers with a specific name: Show all computers with a specific operating system: Show all computers with a specific IP address: Show all installed […]
Create an SSRS Report using Configuration Manager Database Data [2023 Updated]
How to write custom SCCM reports using SSRS. This guide will show you exactly how to create your own custom SCCM SSRS report.
SCCM Collection Query for Devices with specific software installed and version or below [2023 Updated]
If you need to identify machines with specific software installed on a device but would also like to know whether they have a certain version of the stated software or below, then you can use the below query. This can help with software upgrades to identify machines that have not yet been upgraded. SCCM Collection […]
SCCM – Add Local User During OSD
If you want to add a local machine user to your deployed machine during your SCCM OSD process then you can do this using a standard “Run Command Line” step. Instructions So, you need to add a “Run Command Line” step in your task sequence towards the end, after the Windows deployment and after the […]
Autodesk 2022 Serial Number MOF Collection Update
Autodesk 2020 serial numbers are now available for collection using SCCM and our guide will walk you through how to do it.
Add or Remove Multiple Application Deployments in SCCM using Powershell
Problem Scenario When using SCCM, you may find that you want to either add or remove application deployments based on what administrative categories each application has assigned. As an example, we had a number of applications for the Marketing department that were only distributed to a Marketing collection we had set up with only Marketing […]
SCCM Collection Query for Virtual Machines
Just a quick post to add to our list of SCCM collection queries. We needed one today for a collection of virtual machines only. This query you can use to create a collection to do this: You can check out our other SCCM collection queries by following this link.
Autodesk 2021 Serial Number MOF Collection Update
Autodesk 2020 serial numbers are now available for collection using SCCM and our guide will walk you through how to do it.