Table sem5.dbo.LAN_DEVICE_DETECTED
Keeps LAN devices info detected by LAN sensors

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 GUID of the device
AGENT_ID char 32 GUID of the agent
COMPUTER_ID char 32 B1011
HASH char 32 Link with the computer HARDWARE_KEY
MAC_ADDRESS varchar 18 Mac Address of the device
IP_ADDRESS bigint 8 IP Address of the device
DEVICE_DETECTED_TIME bigint 8  √  null GUID of the domain
ALERT tinyint 1  √  null It reflects the alert attribute in profile action. It is true if action::alert is true.
SEND_SNMP_TRAP tinyint 1  √  null It reflects the send SNMP trap action. It is true if send is true.
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 varchar 260  √  null
RESERVED_BINARY varbinary 2000  √  null

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
HASH + MAC_ADDRESS Primary key Asc/Asc PK_LAN_DEVICE_DETECTED
MAC_ADDRESS Performance Asc I_LAN_DEVICE_DETECTED_MAC
USN Performance Asc I_LAN_DEVICE_DETECTED_USN