Wednesday, February 4, 2009

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/

No comments:

Post a Comment