View sem5.dbo.V_AGENT_INCL_GROUP_ID 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
AGENT_ID char 32
SEM_AGENT.AGENT_ID Implied Constraint R
AGENT_TYPE varchar 64  √  null
R_OS_TYPE int 4  √  null
COMPUTER_ID char 32  √  null
SEM_SVA_COMPUTER.COMPUTER_ID Implied Constraint R
DOMAIN_ID char 32  √  null
GROUP_ID char 32  √  null
GROUP_HI_STATUS.GROUP_ID Implied Constraint R
AGENT_VERSION nvarchar 128  √  null
PROFILE_VERSION varchar 64  √  null
PROFILE_SERIAL_NO varchar 64  √  null
PROFILE_CHECKSUM char 32  √  null
IDS_VERSION varchar 64  √  null
IDS_SERIAL_NO varchar 64  √  null
IDS_CHECKSUM char 32  √  null
HI_STATUS int 4  √  null
HI_REASONCODE int 4  √  null
HI_REASONDESC nvarchar 4000  √  null
CREATION_TIME bigint 8  √  null
STATUS tinyint 1  √  null
LAST_UPDATE_TIME bigint 8  √  null
LAST_SERVER_ID char 32  √  null
LAST_SITE_ID char 32  √  null
ATTRIBUTE_EXTENSION nvarchar 4000  √  null
FULL_NAME nvarchar 512  √  null
EMAIL nvarchar 258  √  null
JOB_TITLE nvarchar 256  √  null
DEPARTMENT nvarchar 256  √  null
EMPLOYEE_NUMBER varchar 32  √  null
EMPLOYMENT_STATUS varchar 16  √  null
OFFICE_PHONE varchar 32  √  null
MOBILE_PHONE varchar 32  √  null
HOME_PHONE varchar 32  √  null
USN bigint 8
TIME_STAMP bigint 8
DELETED tinyint 1
PATTERN_IDX char 32
PATTERN.PATTERN_IDX Implied Constraint R
AP_ONOFF tinyint 1
INFECTED tinyint 1
WORSTINFECTION_IDX int 4
LAST_SCAN_TIME bigint 8
LAST_VIRUS_TIME bigint 8
CONTENT_UPDATE tinyint 1
AVENGINE_ONOFF tinyint 1
TAMPER_ONOFF tinyint 1
MAJOR_VERSION int 4
MINOR_VERSION int 4
REBOOT_REQUIRED tinyint 1
REBOOT_REASON varchar 128
LICENSE_STATUS int 4
LICENSE_EXPIRY bigint 8
TIMEZONE int 4
FIREWALL_ONOFF tinyint 1
FREE_MEM bigint 8  √  null
FREE_DISK bigint 8  √  null
LAST_DOWNLOAD_TIME bigint 8
CURRENT_CLIENT_ID char 32  √  null
LICENSE_ID char 32  √  null
IS_GRACE tinyint 1
SNAC_LICENSE_ID char 32  √  null
PTP_ONOFF tinyint 1
LAST_HEURISTIC_THREAT_TIME bigint 8
BASH_STATUS tinyint 1
DA_ONOFF tinyint 1
CIDS_DRV_ONOFF tinyint 1
CIDS_SILENT_MODE tinyint 1
CIDS_DRV_MULF_CODE tinyint 1
CIDS_BROWSER_IE_ONOFF tinyint 1
CIDS_BROWSER_FF_ONOFF tinyint 1
CIDS_ENGINE_VERSION varchar 20  √  null
CIDS_DEFSET_VERSION varchar 20  √  null
DEPLOY_STATUS int 4
DEPLOY_MSG nvarchar 8000  √  null
DEPLOY_PRE_VER varchar 64  √  null
DEPLOY_TARGET_VER varchar 64  √  null
DEPLOY_RUNNING_VER varchar 64  √  null
DEPLOY_TIMESTAMP bigint 8
OS_BIT_TYPE varchar 8  √  null
ELAM_ONOFF tinyint 1
OSELAM_STATUS tinyint 1
VSIC_STATUS tinyint 1
IS_NPVDI_CLIENT tinyint 1
SVA_ID char 32  √  null
SEM_SVA.SVA_ID Implied Constraint R
LAST_CONNECTED_IP_ADDR bigint 8  √  null

Analyzed at Fri Aug 31 01:27 PDT 2012

View Definition:
CREATE VIEW V_AGENT_INCL_GROUP_ID as ( SELECT SA.AGENT_ID, SA.AGENT_TYPE, SA.R_OS_TYPE, SA.COMPUTER_ID, SA.DOMAIN_ID, SL.GROUP_ID, SA.AGENT_VERSION, SA.PROFILE_VERSION, SA.PROFILE_SERIAL_NO, SA.PROFILE_CHECKSUM, SA.IDS_VERSION, SA.IDS_SERIAL_NO, SA.IDS_CHECKSUM, SA.HI_STATUS, SA.HI_REASONCODE, SA.HI_REASONDESC, SA.CREATION_TIME, SA.STATUS, SA.LAST_UPDATE_TIME, SA.LAST_SERVER_ID, SA.LAST_SITE_ID, SA.ATTRIBUTE_EXTENSION, SA.FULL_NAME, SA.EMAIL, SA.JOB_TITLE, SA.DEPARTMENT, SA.EMPLOYEE_NUMBER, SA.EMPLOYMENT_STATUS, SA.OFFICE_PHONE, SA.MOBILE_PHONE, SA.HOME_PHONE, SA.USN, SA.TIME_STAMP, SA.DELETED, SA.PATTERN_IDX, SA.AP_ONOFF, SA.INFECTED, SA.WORSTINFECTION_IDX, SA.LAST_SCAN_TIME, SA.LAST_VIRUS_TIME, SA.CONTENT_UPDATE, SA.AVENGINE_ONOFF, SA.TAMPER_ONOFF, SA.MAJOR_VERSION, SA.MINOR_VERSION, SA.REBOOT_REQUIRED, SA.REBOOT_REASON, SA.LICENSE_STATUS, SA.LICENSE_EXPIRY, SA.TIMEZONE, SA.FIREWALL_ONOFF, SA.FREE_MEM, SA.FREE_DISK, SA.LAST_DOWNLOAD_TIME, SA.CURRENT_CLIENT_ID, SA.LICENSE_ID, SA.IS_GRACE, SA.SNAC_LICENSE_ID, SA.PTP_ONOFF, SA.LAST_HEURISTIC_THREAT_TIME, SA.BASH_STATUS, SA.DA_ONOFF, SA.CIDS_DRV_ONOFF, SA.CIDS_SILENT_MODE, SA.CIDS_DRV_MULF_CODE, SA.CIDS_BROWSER_IE_ONOFF, SA.CIDS_BROWSER_FF_ONOFF, SA.CIDS_ENGINE_VERSION, SA.CIDS_DEFSET_VERSION, SA.DEPLOY_STATUS, SA.DEPLOY_MSG, SA.DEPLOY_PRE_VER, SA.DEPLOY_TARGET_VER, SA.DEPLOY_RUNNING_VER, SA.DEPLOY_TIMESTAMP, SA.OS_BIT_TYPE, SA.ELAM_ONOFF, SA.OSELAM_STATUS, SA.VSIC_STATUS, SA.IS_NPVDI_CLIENT, SA.SVA_ID, SA.LAST_CONNECTED_IP_ADDR FROM SEM_CLIENT SL with (NOLOCK) INNER JOIN SEM_AGENT SA on SA.COMPUTER_ID=SL.COMPUTER_ID)
 
Possibly Referenced Tables/Views:


Close relationships: