Making IT Happen
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, […]
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 […]
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 […]
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 […]
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 […]
How to write custom SCCM reports using SSRS. This guide will show you exactly how to create your own custom SCCM SSRS report.
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 uninstall Spotify installations using System Center Configuration Manager (SCCM).
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 […]
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 […]
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 […]
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 […]