SQL Query To Get A Specified Machines Manufacturer, Model And Processor Count

 

This rather simple SQL query will allow you to gather the manufacturer, model and Processor Count for a specified machine.

 

SQL Query:

 

Select

Name0 'Machine Name',

Manufacturer00 Manufacturer,

Model0 Model,

NumberOfProcessors00 Processors

From Computer_System_Data

Where Name0 = 'MachineName'

 

Published Sunday, February 25, 2007 10:11 AM by dhite
Filed under:

Comments

No Comments