Tag: SQL

close up photo of mining rig

Migrate from MySQL to PostgreSQL

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 fact that both are highly competitive, many businesses long to migrate from MySQL to PostgreSQL for a variety of reasons. These include compatibility with a large range of indexing models,
Continue reading
sccm wql collection query for all winrar installations

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) query. This will allow SCCM to dynamically populate the collection with any machines that have WinRAR installed, making it easier to manage and deploy your uninstall script. WQL Collection Query
Continue reading
Reporting on Office 365 Channels with SQL Query

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
Continue reading
30 Useful SCCM SQL Queries

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
Continue reading
SCCM Collection Query for Devices with specific software installed and version or below

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 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
Continue reading
How-to-migrate-a-scsm-database

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
Continue reading