Making IT Happen
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 Here’s a sample WQL query …
SCCM WQL Collection Query for All WinRAR Installations Read MoreIf 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 BI. In this blog post, …
Reporting on Office 365 Channels with SQL Query Read MoreThese 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 run from the options below: …
SCCM – SQL Queries for Make, Model and Architectures of Devices Read MoreI’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 applications on a specific computer: …
30 Useful SCCM SQL Queries Read MoreHow to write custom SCCM reports using SSRS. This guide will show you exactly how to create your own custom SCCM SSRS report.
Create an SSRS Report using Configuration Manager Database Data Read MoreIf 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 Query You can change the …
SCCM Collection Query for Devices with specific software installed and version or below Read MoreHow to automatically uninstall Spotify installations using System Center Configuration Manager (SCCM).
How to Automatically Remove Spotify using SCCM Read MoreWe 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 is, although we had to …
How to migrate a SCSM database Read MoreWe 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 it. We also noticed that …
Migrate a System Center Orchestrator database to a different SQL Server Read MoreWe 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 then add all the existing …
SQL Query to find members of an Active Directory Security Group Read MoreWe 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 Googling! All the usual tricks …
Service Manager Database Using High RAM Read MoreUsers 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 files and keep them locally …
SCCM – Report on PST File Locations Read More
