Table sem5.dbo.V_LAN_DEVICE_DETECTED
Query detected devices with human-readable IP address 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
LAN_DEVICE_ID char 32
AGENT_ID char 32
COMPUTER_ID char 32
HASH char 32
MAC_ADDRESS varchar 18
IP_ADDRESS bigint 8
DEVICE_DETECTED_TIME bigint 8  √  null
ALERT tinyint 1  √  null
SEND_SNMP_TRAP tinyint 1  √  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 varchar 260  √  null
RESERVED_BINARY varbinary 2000  √  null
IP_ADDRESS_TEXT varchar 123  √  null

Analyzed at Mon Oct 29 12:07 PDT 2012