View sem5.dbo.V_SEM_SVA_COMPUTER 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
SEM_SVA_COMPUTER.COMPUTER_ID Implied Constraint R
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
DISK_TOTAL bigint 8  √  null
DISK_DRIVE varchar 3  √  null
OS_LANG int 4  √  null
HYPERVISOR_VENDOR_ID tinyint 1  √  null
HYPERVISOR_VENDOR.HYPERVISOR_VENDOR_ID Implied Constraint R
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
DELETED tinyint 1
TIME_STAMP bigint 8
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
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 Thu Oct 04 16:09 PDT 2012

View Definition:
CREATE VIEW V_SEM_SVA_COMPUTER as SELECT *, CAST((case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when DNS_SERVER1 < 0 then 0xFFFFFFFF + DNS_SERVER1 else DNS_SERVER1 end & 0xFF as VARCHAR) as DNS_SERVER1_TEXT, CAST((case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when DNS_SERVER2 < 0 then 0xFFFFFFFF + DNS_SERVER2 else DNS_SERVER2 end & 0xFF as VARCHAR) as DNS_SERVER2_TEXT, CAST((case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when WINS_SERVER1 < 0 then 0xFFFFFFFF + WINS_SERVER1 else WINS_SERVER1 end & 0xFF as VARCHAR) as WINS_SERVER1_TEXT, CAST((case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when WINS_SERVER2 < 0 then 0xFFFFFFFF + WINS_SERVER2 else WINS_SERVER2 end & 0xFF as VARCHAR) as WINS_SERVER2_TEXT, CAST((case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when DHCP_SERVER < 0 then 0xFFFFFFFF + DHCP_SERVER else DHCP_SERVER end & 0xFF as VARCHAR) as DHCP_SERVER_TEXT, CAST((case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when IP_ADDR1 < 0 then 0xFFFFFFFF + IP_ADDR1 else IP_ADDR1 end & 0xFF as VARCHAR) as IP_ADDR1_TEXT, CAST((case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when GATEWAY1 < 0 then 0xFFFFFFFF + GATEWAY1 else GATEWAY1 end & 0xFF as VARCHAR) as GATEWAY1_TEXT, CAST((case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end / 256 / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end / 256 / 256) & 0xFF as VARCHAR) + '.' + CAST((case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUBNET_MASK1 else SUBNET_MASK1 end / 256) & 0xFF as VARCHAR) + '.' + CAST( case when SUBNET_MASK1 < 0 then 0xFFFFFFFF + SUB
 
Possibly Referenced Tables/Views:


Close relationships: