System Center

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 […]

System Center

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 […]

System Center

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 […]

System Center

Windows 10 Language Packs

We manage a number of businesses across the world and we very often have to ensure that end-users in different countries have their required Windows languages available to them. We do this in two ways, one is that when Windows devices get built for a user in, let’s say France, the System Center Configuration Manager […]

System Center

How to migrate a SCSM database

We recently had a situation where we needed to upgrade our SQL server that had the System Center Service Manager (SCSM) databases on it. This meant that we would need to migrate the databases from the old server to the new server. We thought that this would be a fairly straight forward task and it […]