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

Server 2003, Windows Vista and Windows Server 2008, and different SQL Server products, including
SQL Server 2000, 2005, and 2008.

In the next chapter, we will show you how we installed the named instance INSTANCE1 on
POWERPC and the failover cluster default instance SQLCLUSTER2008, and how we used the scripts in
this chapter to record the host and server information before and after the installations.

The inventory database contains the following primary tables:

❑ Hosts : Stores information about SQL Server hosts

❑

Clusters : Stores information about SQL Server clusters

❑ ClusterNodes : Stores information about nodes in each SQL Server cluster

❑ Servers : Stores information about SQL Server instances

❑ ServerDatabases : Stores information about each database on each SQL Server

Hosts
The Hosts table contains information about all the SQL server hosts. The schema of the Hosts table is
described in Table 15-1.

Table 15-1: Hosts Table Schema

Column DataType Description

int identity(1000,1) ID of the host; and the primary key

hostID

hostName varchar(128) Name of the SQL Server host

region char(2) Region in which the SQL Server host is located

(e.g., NA, EU, and AS)

location char(2) Code of the city in which the SQL host is

located (e.g., NY for New York, CH for
Chicago)

varchar(500) Description of purposes of the SQL Server host

description

varchar(128) Primary business unit that owns the host

primaryBU

timeZone varchar(128) Standard time zone of the host

enableDaylightSavingsTime bit Indicates if daylight saving time (DST) is

enabled on the host

varchar(128) Domain of the host

domain

Continued