Building SQL Server Inventory - Professional SQL Server 2008 Administration with Windows PowerShell - page 336

Table 15-1: Hosts Table Schema (continued)

Column DataType Description

manufacturer varchar(128) Name of the host's computer manufacturer

(e.g. Dell, HP)

model varchar(128) Product name that the manufacturer gives to

the host

varchar(128) System running on the Windows-based

computer (e.g., X86-based PC, 64-bit Intel PC)

systemType

varchar(128) List of the options for starting up the computer

system running Windows

systemStartupOptions

numberOfProcessors tinyint Number of logical processors available on the

computer

numberOfLogicalProcessors tinyint Number of physical processors available on the

computer

bigint Total size of physical memory

totalPhysicalMemory

varchar(128) Country code that the host uses

countryCode

lastBootUpTime smalldatetime Date and time the host was last restarted

locale varchar(128) Language identifier used by the host

varchar(128) Operating system used by the host

OS

version varchar(128) Version number of the operating system

servicePackMajorVersion varchar(10) Major version number of the service pack of the

OS installed on the host

varchar(10) Minor version number of the service pack of the

OS installed on the host

servicePackMinorVersion

varchar(20) Build number of an operating system

buildNumber

installDate smalldatetime When the host was first built or rebuilt

totalVisibleMemorySize bigint Number, in kilobytes, of physical memory

available to the operating system. This value
does not necessarily indicate the true amount of
physical memory, but what is reported to the
operating system as available to it.

Continued