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
