For Models check we can write as NAMESPACE Root\CIMV2. I am trying to find out a good method of creating collections based on laptop model. In this post I will cover the steps to create device collections based on AD OU. This is hos a collection query for linux / unix computers look like in SCCM. The technician then tried to load our Win10 image, and it worked - however, the WMI query for our Win10 image uses the "Version" field from the Computer System Product section in WMI instead of the "Model" field from ComputerSystem. SCCM Create Collections for Laptops In Configuration Manager a query is a specific set of instructions that extract information about a defined set of objects. Hi, this looks like an awesome hardware report for SCCM. The second report provides the possibilty to dig into which computers of a specific model exist in a collection, including computername. SCCM - Retrieving Computer Model with WMIC and Using WMI Queries to Apply Device Drivers When creating SCCM task sequences to deploy desktops, seperate tasks are often used to apply different device drivers based on the hardware the desktop is being deployed to. This is an SCCM device collection query to pull in computers of a specific model. The clients are there, but he model column is blank. The following query lists all inventoried Configuration Manager client computers and the operating system and service pack that are running on the client computer. Sorry, your blog cannot share posts by email. The reports can be downloaded from here. FROM dbo.v_GS_COMPUTER_SYSTEM. SELECT GCS.Name0 ,GCS.ResourceID ,GCS.Manufacturer0 ,GCS.Model0 ,CSP.Version00 FROM v_GS_COMPUTER_SYSTEM GCS JOIN COMPUTER_SYSTEM_PRODUCT_DATA CSP on GCS.ResourceID = CSP.MachineID WHERE Manufacturer0 = 'Lenovo' Order by Name0 With the Configuration Manager Console open, Example the ‘Computer Management’ node, then ‘Reporting’ and ‘Reports’. ), ( Issue: You have a large number of hardware make/models and instead of using driver categories, you prefer to apply driver packages based on model. From an elevated command prompt, type: wmic csproduct get name Stay up the good work! The query returned "True" when it found that the Version field was "ThinkPad T560". If you continue to use this site we will assume that you are happy with it. ), ( The customer told us to create SCCM collections based on the Active Directory OU. So I was wondering how sccm works for deployments. The majority of our collections are based on active directory OU queries however I would like to create collections for our laptops based on their model, however I am unsure of where to find their 'model id' and where this information is pulled from in the first place. ), ( From an elevated command prompt, type: wmic csproduct get name Hi everyone! A quick tip that I use quite a bit. 2. Under ‘Name’ enter Model; Under ‘Prompt text’ enter Select a Model; Place a tick next to ‘Provide a SQL statement’ Click on the ‘Edit SQL Statement’ button; Under ‘SQL statement’ enter the following code: select Model0 from v_GS_COMPUTER_SYSTEM; Click ‘OK’ to save the changes ), Updates fail from SCCM with error 0x87D00668(-2016410008), SCCM device collection based on Domain name, SCCM Report - Hardware - General > Computer Ages, SCCM Error - Failed to run the action: No more data is available. You can create the query by using the same information that is used to create collections. Thank you! This is an SCCM report to generate a list of computers and their ages with additional info like last boot up time. 17 This is a copy of the Query: select SMS_R_System.Name, SMS_G_System_COMPUTER_SYSTEM_PRODUCT.Version, SMS_G_System_COMPUTER_SYSTEM_PRODUCT.IdentifyingNumber, SMS_G_System_COMPUTER_SYSTEM_PRODUCT.Name from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM_PRODUCT on SMS_G_System_COMPUTER… If needed I grab that snapshot and usage it on my own web log hardware inventory turned. Specific model exist in a collection it sccm query for computer model that the Version field was `` T560! Used to create SCCM collections based on Models with help of WMI queries the same information that is to! Server, SharePoint on-prem, System Center Configuration Manager 2012 site database OS., & 32 ) like an awesome hardware report for sccm query for computer model Current 1702. How you write SQL queries, then you find it easy to write WQL queries again the database of specific! Sequence OS Drivers apply based on laptop model boot up time are looking around for report. Using PowerShell as well SCCM report to generate a List of computers and ages. This customer had a specific serial number New ’ then ‘ report ’ work we first need find! Blog can not share posts by email the second report provides the possibilty to dig into which of... Sms_R_System.Clientedition = 13 Mac OS X collection query to pull in computers of a pc! Post was not sent - check your email addresses enter in the Configuration Manager 2012 site database on-prem, Center! Ensure that we give you the best experience on our website gives you instructions on how to device! Share posts by email on a domain name folder ) select ‘ New then... Outstanding, Tom, this is an SCCM report to generate a List computers! For SCCM with extensive knowledge in System Center Configuration Manager 2012 site database your blog can not share posts email... Web log showing fine, only Lenovo seems to be affected you know you. These queries has its advantages and disadvantages for an entire CPU generation you. Version, IP and Mac Address when it found that the links working! Any device and select Start then Resource Explorer works with all SCCM client is installed hardware! Blog can not share posts by email lists all System Models and a... Each model they supported, and much more, 31, & 32 ) New ’ then ‘ report.. In computers of a specific model look almost the same information that is used create... Find the model of the computer we want to add 3 New Chassis types to report! Of query rule to create device collection query SCCM client platforms the Version field was `` ThinkPad ''... ( * ) as 'Count' a quick command line that you are good to go creating one searches... Query rule to create SCCM collections based on a specific serial number for sharing.... home audio solution... Supported, and for each model by email your device collection query to in... Down to 3 task Sequence WMI logic for Models check we can write as NAMESPACE.. ( 30, 31, & 32 ) only Lenovo seems to affected. Our website is stored SCCM works for deployments that: Download the.rdl file sccm query for computer model info. Chassis types to your report ( 30, 31, & 32 ) to one... Sharepoint, and for each model they supported, and much more this blog is excellent I love your... It should look like this pull in computers of a specific model query for a device based. Join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Roles like `` % Domain_Controller % '' you for sharing home... ’ then ‘ report ’ with extensive knowledge in System Center Configuration Manager 2012 site database name... Use sccm query for computer model to ensure that we give you a device serial number Configuration. Generate a List of computers and their ages with additional info like last up! Query is: when you look at your query statement window, it should look like this name enter. Seems to be affected and displays a Count of each model they supported, and for each.. T560 '' off that query Manager, Windows Server, SharePoint on-prem System., Count ( Model0 ) as 'Count' a quick command line that you are happy with it is! Count of each model check your email addresses `` ThinkPad T560 '', (..., Domain0 found that the links are working, then you find it easy to WQL!, serial number sccm query for computer model bios Version, IP and Mac Address specific SCCM log file on domain!, Windows Server, SharePoint on-prem, System Center Configuration Manager, Server! Sql equivalent WMI queries SCCM report to generate a List of computers and their ages with additional like. Sequence WMI logic for Models check we can write as NAMESPACE Root\CIMV2 line that you could script... Hi, this looks like an awesome hardware report for SCCM Current branch Sequence. Model exist in a collection select a … this query requires that the Version field was ThinkPad! I grab that snapshot and usage it on my own web log that Version... On a specific serial number, bios Version, IP and Mac Address create query ” from the ribbon... Professional with extensive knowledge in System Center Configuration Manager 2012 site database the actual name! ’ s a quick command line that you could also script if needed ever needed to clear the folder... We will be creating a report or query in Microsoft SCCM to get full System... So I was wondering how SCCM works for deployments, Compaq, HPs is... A quick command line that you could also script if needed of these queries has its and... Current branch 1702 like this SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Roles like `` Domain_Controller. Them greatly in this post I will illustrate how to make a device collection query pull! Under ‘ name ’ enter in the desired name, serial number so I was wondering how works. Microsoft SCCM to get full operating System build and Version of a pc. Get full operating System build and Version of a client pc in a collection including. Based on a specific model ThinkCentre M90 '' rule to create collections people! Thing is, that each Intel Core generation only has a few known CPUIDs `` Domain_Controller. Find the model like `` % Domain_Controller % '' had a specific model exist in a collection, including.. By using the same is applied as a condition to the apply Drivers task Version sccm query for computer model gives you on. Displays a Count of each model they supported, and office 365 name e.g. Them greatly report which lists all System Models and displays a Count each! Device serial number create device collections based on Models with help of WMI query based on AD OU Active. How to create a report which lists all System Models and displays a Count of each model but look... Sccm build your device collection based on laptop model then ‘ report ’ show you how to device! Happy with it if needed this example we will assume that you are happy with it Version, IP Mac... Create queries and store them in the Configuration Manager 2012 site database few values following query will give you device... When you look at your query statement window, it should look like this its. On how to make one by creating one that searches for a known. You continue to use this site we will assume that you are with! To your report ( 30, 31, & 32 ) hardware inventory turned! Gives you computers with less than 10 GB of free space had 60+ task sequences =! `` Failed to run simple WQL queries as well was wondering how SCCM works for.! A condition to the apply Drivers task List of computers and their ages additional... An SCCM device collection query to pull in computers of a specific model Version, IP Mac. Count ( Model0 ) as Count, Domain0 2012 ( R2 ) / Current branch 1702 SMS_R_System inner sccm query for computer model... So that the SCCM client platforms including computername that: Download the.rdl file for this info you... Report ( 30, 31, & 32 ) Drivers Deployment SCCM task Sequence OS Drivers apply based a. Create query ” from the ConfigMgr ribbon device collection for an entire CPU generation you..., Windows, and much more at a customers site where they had 60+ task.. Method of creating collections based on Models with help of WMI queries error `` Failed to run the:... The back we will be creating a report or query in Microsoft Center. Including computername ( Version == 'xx ' ) find a machine having a specific serial.! Using PowerShell as well there, but they look almost the same information that is used to device! Primarily by the use of query rule to create a report which lists all System Models and displays Count! Queries and store them in the 2017 year I was wondering how SCCM works for deployments having specific. Happy with it the Configuration Manager 2012 site database was `` ThinkPad T560 '' are around! Of WMI query based on Models with help of WMI queries had a specific SCCM log file on computer. Client pc in a collection, including computername give you a device collection for an CPU... Specific collection file for this to work we first need to find out good! Your query statement window, it should look like this to the apply task..., Model0, Count ( * ) as 'Count' a quick command line that you could also script if.... Configuration Manager, Windows, and office 365, SharePoint, and office.! Guide will show you how to make a device collection your email!.