Table sem5.dbo.SEM_COMPUTER
Keeps computers information

Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
COMPUTER_ID char 32
DOMAIN_ID char 32  √  null GUID of the domain
HARDWARE_KEY char 32  √  null Hash of computer hardware information
COMPUTER_NAME nvarchar 128  √  null Computer name
COMPUTER_DOMAIN_NAME nvarchar 512  √  null Computer description
COMPUTER_DESCRIPTION nvarchar 512  √  null Domain name of the computer
PROCESSOR_TYPE nvarchar 128  √  null Processor type
PROCESSOR_CLOCK bigint 8  √  null Processor clock
PROCESSOR_NUM int 4  √  null Number of processors
MEMORY bigint 8  √  null Physical memory in kb
BIOS_VERSION varchar 128  √  null BIOS version
TPM_DEVICE int 4  √  null TPM device id
OPERATION_SYSTEM nvarchar 256  √  null Operation System name
SERVICE_PACK nvarchar 128  √  null Service pack
CURRENT_LOGIN_USER nvarchar 512  √  null Logged in user
CURRENT_LOGIN_DOMAIN nvarchar 512  √  null Windows domain
DNS_SERVER1 bigint 8  √  null
DNS_SERVER2 bigint 8  √  null
WINS_SERVER1 bigint 8  √  null
WINS_SERVER2 bigint 8  √  null
DHCP_SERVER bigint 8  √  null
MAC_ADDR1 varchar 17  √  null
IP_ADDR1 bigint 8  √  null
GATEWAY1 bigint 8  √  null
SUBNET_MASK1 bigint 8  √  null
MAC_ADDR2 varchar 17  √  null
IP_ADDR2 bigint 8  √  null
GATEWAY2 bigint 8  √  null
SUBNET_MASK2 bigint 8  √  null
MAC_ADDR3 varchar 17  √  null
IP_ADDR3 bigint 8  √  null
GATEWAY3 bigint 8  √  null
SUBNET_MASK3 bigint 8  √  null
MAC_ADDR4 varchar 17  √  null
IP_ADDR4 bigint 8  √  null
GATEWAY4 bigint 8  √  null
SUBNET_MASK4 bigint 8  √  null
USN bigint 8 Update serial number; used by replication
TIME_STAMP bigint 8 Time that the record was modified; used to resolve merge conflict
DELETED tinyint 1 The deleted flag of the schema object:
1 = Deleted
0 = Not Deleted
RESERVED_INT1 int 4  √  null
RESERVED_INT2 int 4  √  null
RESERVED_BIGINT1 bigint 8  √  null
RESERVED_BIGINT2 bigint 8  √  null
RESERVED_CHAR1 char 32  √  null
RESERVED_CHAR2 char 32  √  null
RESERVED_VARCHAR1 nvarchar 520  √  null
RESERVED_BINARY varbinary 2000  √  null
DISK_TOTAL bigint 8  √  null Total disk space
DISK_DRIVE varchar 3  √  null Drive letter referred to by DISK_TOTAL
OS_LANG int 4  √  null Operating system language ID, for example, English = 0x09
HYPERVISOR_VENDOR_ID tinyint 1  √  null Foreign key to HYPERVISOR_VENDOR table

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
COMPUTER_ID Primary key Asc PK_SEM_COMPUTER
DELETED Performance Asc I_SEM_COMPUTER_DELETED
DOMAIN_ID + DELETED Performance Asc/Asc I_SEM_COMPUTER_DOM
HARDWARE_KEY Performance Asc I_SEM_COMPUTER_HWK
COMPUTER_ID + DOMAIN_ID Performance Asc/Asc I_SEM_COMPUTER_ID_DOMAIN_ID
COMPUTER_ID Performance Asc I_SEM_COMPUTER_ID_PLUS
MAC_ADDR1 Performance Asc I_SEM_COMPUTER_MAC_ADDR1
MAC_ADDR2 Performance Asc I_SEM_COMPUTER_MAC_ADDR2
MAC_ADDR3 Performance Asc I_SEM_COMPUTER_MAC_ADDR3
MAC_ADDR4 Performance Asc I_SEM_COMPUTER_MAC_ADDR4
USN Performance Asc I_SEM_COMPUTER_USN