Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
COMPUTER_ID |
char |
32 |
|
|
|
|
|
DOMAIN_ID |
char |
32 |
√ |
|
null |
|
|
HARDWARE_KEY |
char |
32 |
√ |
|
null |
|
|
COMPUTER_NAME |
nvarchar |
128 |
√ |
|
null |
|
|
COMPUTER_DOMAIN_NAME |
nvarchar |
512 |
√ |
|
null |
|
|
COMPUTER_DESCRIPTION |
nvarchar |
512 |
√ |
|
null |
|
|
PROCESSOR_TYPE |
nvarchar |
128 |
√ |
|
null |
|
|
PROCESSOR_CLOCK |
bigint |
8 |
√ |
|
null |
|
|
PROCESSOR_NUM |
int |
4 |
√ |
|
null |
|
|
MEMORY |
bigint |
8 |
√ |
|
null |
|
|
BIOS_VERSION |
varchar |
128 |
√ |
|
null |
|
|
TPM_DEVICE |
int |
4 |
√ |
|
null |
|
|
OPERATION_SYSTEM |
nvarchar |
256 |
√ |
|
null |
|
|
SERVICE_PACK |
nvarchar |
128 |
√ |
|
null |
|
|
CURRENT_LOGIN_USER |
nvarchar |
512 |
√ |
|
null |
|
|
CURRENT_LOGIN_DOMAIN |
nvarchar |
512 |
√ |
|
null |
|
|
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 |
|
|
|
|
|
TIME_STAMP |
bigint |
8 |
|
|
|
|
|
DELETED |
tinyint |
1 |
|
|
|
|
|
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 |
|
|
DISK_DRIVE |
varchar |
3 |
√ |
|
null |
|
|
OS_LANG |
int |
4 |
√ |
|
null |
|
|
HYPERVISOR_VENDOR_ID |
tinyint |
1 |
√ |
|
null |
|
|
DNS_SERVER1_TEXT |
varchar |
123 |
√ |
|
null |
|
|
DNS_SERVER2_TEXT |
varchar |
123 |
√ |
|
null |
|
|
WINS_SERVER1_TEXT |
varchar |
123 |
√ |
|
null |
|
|
WINS_SERVER2_TEXT |
varchar |
123 |
√ |
|
null |
|
|
DHCP_SERVER_TEXT |
varchar |
123 |
√ |
|
null |
|
|
IP_ADDR1_TEXT |
varchar |
123 |
√ |
|
null |
|
|
GATEWAY1_TEXT |
varchar |
123 |
√ |
|
null |
|
|
SUBNET_MASK1_TEXT |
varchar |
123 |
√ |
|
null |
|
|
IP_ADDR2_TEXT |
varchar |
123 |
√ |
|
null |
|
|
GATEWAY2_TEXT |
varchar |
123 |
√ |
|
null |
|
|
SUBNET_MASK2_TEXT |
varchar |
123 |
√ |
|
null |
|
|
IP_ADDR3_TEXT |
varchar |
123 |
√ |
|
null |
|
|
GATEWAY3_TEXT |
varchar |
123 |
√ |
|
null |
|
|
SUBNET_MASK3_TEXT |
varchar |
123 |
√ |
|
null |
|
|
IP_ADDR4_TEXT |
varchar |
123 |
√ |
|
null |
|
|
GATEWAY4_TEXT |
varchar |
123 |
√ |
|
null |
|
|
SUBNET_MASK4_TEXT |
varchar |
123 |
√ |
|
null |
|
|
Analyzed at Mon Oct 29 12:07 PDT 2012
|