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 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 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 MoreJust a quick post to add to our list of SCCM collection queries. We needed one today for a collection of virtual machines only. This query you can use to create a collection to do this: You can check out our other SCCM collection queries by following this link.
SCCM Collection Query for Virtual Machines Read MoreWe have another WQL query here for you today to enable you to create a Configuration Manager collection based on whether a device is used as a domain controller. Go ahead and create a new device collection and then use this query: Save the query and you should now see a collection of all your domain controllers. Just be careful …
SCCM – Create a device collection based on Domain Controller role Read MoreIf you are looking for a SQL query to pull back hardware inventory information and the SCCM client version, then you can use the below to pull all this information together. SELECT S.Name0 as Name, S.Client_Version0 as [Cient Version], OS.Caption0 as [Operating System], CS.Manufacturer0 as Manufacturer, CS.Model0 as Model, PB.SMBIOSBIOSVersion0 as BIOS, PR.Name0 as CPU, SUM(PM.Capacity0) as Memory, SUM(LD.Size0)as [Disc …
SCCM – Hardware and Client Version SQL Query Read MoreIf you are looking for a SCCM collection query for virtual machines in your environment, then you can use this query below:
SCCM Collection Query – Virtual Machines Read MoreYou may want to create a Configuration Manager Collection based upon an Active Directory Organisation Unit. To do this you can use the following WQL code and then simply amend the last part to be the Organisation Unit that you want to base the Collection on: SELECT SMS_R_USER.ResourceID, SMS_R_USER.ResourceType, SMS_R_USER.Name, SMS_R_USER.UniqueUserName, SMS_R_USER.WindowsNTDomain FROM SMS_R_User WHERE SMS_R_User.UserOUName = “LOCALDOMAIN.COM/COMPANYNAME/TECHYGEEKSHOME” More Queries …
SCCM Collection based on Active Directory Organisation Unit (OU) Membership Read More
