Sccm Query Hardware Information
You can use collections for several tasks including software deployment.
Sccm query hardware information. To open the resource explorer open the sccm console and navigate to assets and compliance devices. Select from sms r system inner 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. The hardware inventory schema is important to understand when creating queries for configuration manager reports. Thank you for your help arun.
This query should give you what you need the check for operating system can be modified to provide information on other os types. This query may be heavy on the sccm server. You can use several methods to view the hardware inventory data that configuration manager collects including these methods. Full hardware information sccm query wql this query contains.
Or the check for os type can be removed and used to create a report of all clients. Once clients receive the update on the next hardware inventory cycle they should return disk free space. Select sms r system resourceid sms r system resourcetype sms r system name sms r system smsuniqueidentifier sms r system resourcedomainorworkgroup sms r system client from sms r system where sms r system name like 13579 collection of computers ending with even numbers. Most of the client data within configuration manager is contained in one of the two hardware inventory schema views.
System name client ip addresses cpu model and name number of cpu and its core number of logical cpus physical memory of device disk drives name and model disk drives capacity system manufacturer system motherboard name and model os information. And what is that wmi queries name. Create queries that return devices that are based on a specific hardware configuration. May 21 2018.
Until then it will be null. Right click on any device and select start then resource explorer. The resource explorer tool will open and by expanding each sections you will be able to find any hardware inventory information related to a device. Hello please can someone help me i am using sccm 1710 and sql 2014 for reporting i am looking sql query to get all hardware type list model type hardware name like dell hp lenovo bios ver etc.
Sccm database query to get all hardware info. Look in the configuration manager inventory database after extending the hardware inventory. If you are not in a hurry wait until the next day. Once we have extended the hardware inventory we go ahead and take a peek in the configuration manager database.
Create query based collections that are based on a specific hardware configuration. This query requires that the sccm client is installed and hardware inventory is turned on. Configuration manager status not open for further replies.