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 […]
SQL
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 […]
How to Automatically Remove Spotify using SCCM [2022 Updated]
How to automatically uninstall Spotify installations using System Center Configuration Manager (SCCM).
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 […]
Migrate a System Center Orchestrator database to a different SQL Server
We were running through our list of servers and looking at what each one was doing in terms of Domain Controllers, Exchange servers, SQL servers, System Center servers etc when we noticed that we had quite a few servers that were using pretty small databases but had a large amount of host resource allocated to […]
SQL Query to find members of an Active Directory Security Group
We recently helped out with a data migration which included creating a completely new set of Active Directory security groups. They wanted all the members to have the same level of access but wanted all the new security groups to have a matching standard. So we needed to create all the new security groups and […]
Service Manager Database Using High RAM
We recently had a problem with our Service Manager database server using massively high RAM usage. It was using up all the RAM we gave it no matter how much extra we allocated to it. So we needed to try and figure out why it was doing this, like all good IT people, we started […]
SCCM – Report on PST File Locations
Users love to keep their email for as long as they possibly can, but when IT Admins start telling them to archive their email because their mailbox is too big, sometimes things get worse and PST files end up being created all over your corporate Filestores. Even worse than that, users will create their PST […]
SCCM – Active Directory Security Group Query for User Collection
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 […]
