processors

Description

This table lists all the processors of a computer. There is one entry per processor. The processor frequency is not available on Windows 9x computers.

Fields

Field name

Data type

Description

id_snapshot

number

snapshot auto-number

server_name

string

Netbios name of the server without the backslashes.

mhz

number

Processor's frequency.

vendor

string

Name of the processor's manufacturer

model

string

Intelligible name of the processor (if available)

version

string

Cpu Id (family, model and stepping)

Serial

string

serial number of the processor (rarely available)

ExternalClock

number

Bus speed in MHz

L1Cache

number

size (KB) of the L1 cache if available

L2Cache

number

size (KB) of the L2 cache if available

L3Cache

number

size (KB) of the L3 cache if available

model2

string

for debugging purpose only

model3

string

more precise model

Example

To list all the servers with a 250 MHz frequency, use the following SQL query:

SELECT server_name
FROM processors
WHERE mhz = 250