|
Name |
|
|
Comment |
See documentation on MD_KeyedComputer in the StarsLabUsage package. |
|
Dimensional Type |
Dimension |
|
select |
|
Name |
Child Table/View |
|
ViewReference_227 |
|
|
ViewReference_236 |
|
Name |
|
Name |
|
Grant |
User |
|
SELECT,VIEW DEFINITION |
IssueTrackingReader |
|
Name |
Data Type |
Comment |
Length |
|
MD_KeyedComp_SurrogateKey |
numeric |
|
|
|
MD_KeyedComp_UniqueID |
varchar(36) |
Maps to computerID in K2. |
|
|
MD_KeyedComp_SystemOfRecord |
varchar(64) |
Until we add data from another keyserver, the data here will all come from K2, and "K2" will be the only value present. |
|
|
MD_KeyedComp_Name |
nvarchar(64) |
Some mnemonic or name assigned to a computer. May not be unique (i.e., multiple computers might have, at one time or another, been assigned the same name). |
|
|
MD_KeyedComp_MACAddress |
varchar(32) |
Corresponds to computerMACAddress in KSComputers table in K2. Should generally be unique, at least in K2. Used to create K2's unique key for a given piece of hardware. |
|
|
MD_KeyedComp_NetworkAddress |
varchar(32) |
Usually an IP address (the current one; may change). Corresponds to computerAddress in the KSComputers table in K2. |
|
|
MD_KeyedComp_Platform |
nvarchar(64) |
Corresponds to KStermPlatform table in K2, termAbbreviation field. KStermPlatform joins to computerPlatform field in KSComputers on termID = computerPlatform. Typically designates the operating system (or in the case of Apple computers running OS/X and iDevices, we use 'Macintosh'). |
|
|
MD_KeyedComp_Manufacturer |
nvarchar(64) |
Corresponds to computerManufacturer field in the KSComputers table in K2. Manufacturers are to computers as publisher are to software. Since we're talking computers (hardware) here, this field is a manufacturer field. |
|
|
MD_KeyedComp_Model |
nvarchar(64) |
Corresponds to computerModel field in the KSComputers table in K2. |
|
|
MD_KeyedComp_OSType |
nvarchar(64) |
Obtained from termAbbreviation field in KSTermOSType table, which joins to KSComputers on termID = computerOSType. |
|
|
MD_KeyedComp_OSVersion |
varchar(32) |
An integer in K2 (computerOSVersion in KSComputers table); a string here. |
|
|
MD_KeyedComp_OSRelease |
varchar(32) |
An integer in K2 (computerOSVersion in KSComputers table). A string here. |
|
|
MD_KeyedComp_OSIs64Bit |
varchar(7) |
Corresponds to computerOS64Bit field in KSComputers table in K2. |
|
|
MD_KeyedComp_CPUIs64Bit |
varchar(7) |
Corresponds in computerCPU64Bit in KSComputers table in K2. |
|
|
MD_KeyedComp_CPUCount |
int |
Corresponds to computerCPUCount field in the KSComputers table in K2. Defaults to zero (0), which means, basically 'Unknown.' |
|
|
MD_KeyedComp_CPUType |
nvarchar(64) |
Corresponds to computerCPUType field in the KSComputers table in K2, but the actual value here is obtained via a join to KSTermCPUType. |
|
|
MD_KeyedComp_CPUClockFreq |
varchar(32) |
Corresponds to computerCPUClock field in the KSComputers table in K2. |
|
|
MD_KeyedComp_RAMSize |
varchar(32) |
Corresponds to the computerRAMSize field in the KSComputers table in K2. |
|
|
MD_KeyedComp_DiskSize |
varchar(32) |
Corresponds to computerDiskSize field in the KSComputers table in K2. |
|
|
MD_KeyedComp_DiskFree |
varchar(32) |
Corresponds to computerFreeSpace field in the KSComputers table in K2. |
|
|
MD_KeyedComp_DisplayWidth |
varchar(32) |
Corresponds to computerDisplayWidth field in the KSComputers table in K2. |
|
|
MD_KeyedComp_DisplayHeight |
varchar(32) |
Corresponds to computerDisplayHeight field in the KSComputers table in K2. |
|
|
|
|