SCCM Query for SCCM Clients Model and Manufactures Name

Need to extract SCCM Clients Model and Manufactures Name?

 

You have to dig the Computer_System_DATA Table. Here are two shared SQL Querys.

 

Select DISTINCT Model0 from Computer_System_DATA

The above one will show all the Models

The below Query will show everything in the Database

Select

* from Computer_system_data

-------------------
Thanks,
http://sccm07.blogspot.com/