The most popular open-source DBMS are MySQL and PostgreSQL, both have wide community of users, a wealth of administration tools and programming APIs. Despite the […]
Tag: SQL
SCCM WQL Collection Query for All WinRAR Installations
To automate the process of identifying all systems with WinRAR installed, you can create a custom collection in SCCM using a WQL (WMI Query Language) […]
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 […]
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 […]
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 […]
Create an SSRS Report using Configuration Manager Database Data
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
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 […]
How to Automatically Remove Spotify using SCCM
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 […]
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, […]
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 […]
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 […]