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

Table 15-6: ServerBUContacts (all user defined)

Column DataType Description

int ID of the associated SQL Server

serverID

databaseID int If databaseID is null, then the BU contact is for the

entire server. Otherwise, the BU contact is associated
with this database only.

BUContactEmail varchar(256) E-mail address of the BU user. This can be an

individual's e-mail or an e-mail group.

varchar(256) Page address of the BU user

BUContactPage

varchar(20) Phone number of the BU user

BUContactPhone

preferredContactMethod varchar(1) Preferred method of contact by BU (e.g., M for e-mail,

P for page, N for phone number)

createDate smalldatetime Date and time the BU contact record was created

smalldatetime Date and time the BU contact record was last updated

updateDate

Table 15-7: Regions

Column DataType Description

regionID char(2) Regions that DBAs support (e.g., EU, NA, AS)

varchar(256) Description of the region (e.g., Europe, North America, Asia)

regionDescription

Table 15-8: RegionSupportShifts

Column DataType Description

regionID char(2) ID of the region

varchar(256) Contact e-mail group of each region

(e.g., lndba, nydba, asdba)

dbaContactEmailGroup

Time (new data type introduced in
SQL Server 2008)

Starting time of the support shift,
based on GMT

startTime

endTime Time Ending time of the support shift,

based on GMT