WebFeb 23, 2012 · SCCM 2010 Collection Query using registry entry. What I want to do create a device collection using a query that scanned all machines in SCCM for a matching … WebSep 18, 2024 · Use the SystemRole column in the System (SMS_G_System_SYSTEM) view. Below is a screenshot of the System Role column in Resource Explorer. Yes, you are seeing it correctly. The column name is one-word in the database and WQL, and two words in Resource Explorer. select.
Sample queries for collections - Configuration Manager
WebYou can create a report to see what values you need to consider in your criteria with the following SQL Query: SELECT Manufacturer0, Model0, Count (Model0) AS 'Count' FROM … WebJun 16, 2014 · With those solutions, here is the process to create a device collection based on user properties. Create a query to select devices based on user properties using SMS_G_system_SYSTEM_CONSOLE_USAGE.TopConsoleUser to join them. Be sure to select the “Not collection limited” option when creating the query. Create a device collection. rock island 0-4-0
SCCM Collection Query for Devices with specific
WebMay 21, 2024 · SCCM: Create a query to find servers with a specific registry entry. Have just been added to the server-side (as opposed to desktop) SCCM team where I work. We … WebJul 1, 2015 · Then I created a collection of devices with a query rule where the criteria was that if the last logged on user of the device was part of the subselected values of the first group query I made, then those devices would be added to the collection. The query rule: select * from SMS_R_System where SMS_R_System.LastLogonUserName in (select … WebOct 17, 2014 · Provide the name of Configuration Baseline , In this case CB – Registry Key Value. Click on Add and select Configuration Item from dropdown. Select the compliance … rock is formed by compressed layers of what