
Sentinel 6.1 Rapid Deployment Database Views for PostgreSQL
63
no
vd
ocx
(e
n)
13
Ma
y 20
09
6.1.10 ADV_MASTER_RPT_V
6.1.11 ADV_PRODUCT_RPT_V
View references ADV_PRODUCT table that stores Advisor product information such as vendor and
product ID.
Column Name
Datatype
Comment
MASTER_ID
integer
ID that associates PLUGIN_KEY,
ATTACK_KEY and VULN_KB_ID
PLUGIN_KEY
integer
ID to reference the
ADV_ATTACK_PLUGIN_V
ATTACK_KEY
integer
ID to reference the
ADV_ATTACK_MAP_V
VULN_KB_ID
integer
ID to reference the VULN_KB_ID_V
DATE_PUBLISHED
timestamp with time zone Date the entry was published
DATE_UPDATED
timestamp with time zone Date the entry was uptimestamp with
time zoned
BEGIN_EFFECTIVE_DATE timestamp with time zone Date from which the entry is valid
END_EFFECTIVE_DATE
timestamp with time zone Date until which the entry is valid
DATE_CREATED
timestamp with time zone Date the entry was created
DATE_MODIFIED
timestamp with time zone Date the entry was modified
CREATED_BY
integer
User who created object
MODIFIED_BY
integer
User who last modified object
Column Name
Datatype
Comment
PRODUCT_ID
integer
ID of the product
VENDOR_ID
integer
ID of the vendor
PRODUCT_CATEGORY_ID
integer
ID of the Product Category
PRODUCT_CATEGORY_NAME character varying(128)
Product Category Name
PRODUCT_TYPE_ID
integer
ID of the product type
PRODUCT_TYPE_NAME
character varying(256)
Name of the Product Type
PRODUCT_NAME
character varying(128)
Product Name
PRODUCT_DESCRIPTION
character varying(512)
Product Descritpion
FEED_DATE_CREATED
timestamp with time zone
Date of the Feed that carried
information on this product
Summary of Contents for Sentinel Rapid Deployment 6.1
Page 4: ...4 Sentinel 6 1 Rapid Deployment Reference Guide novdocx en 13 May 2009 ...
Page 24: ...24 Sentinel 6 1 Rapid Deployment Reference Guide novdocx en 13 May 2009 ...
Page 36: ...36 Sentinel 6 1 Rapid Deployment Reference Guide novdocx en 13 May 2009 ...
Page 50: ...50 Sentinel 6 1 Rapid Deployment Reference Guide novdocx en 13 May 2009 ...
Page 54: ...54 Sentinel 6 1 Rapid Deployment Reference Guide novdocx en 13 May 2009 ...
Page 120: ...120 Sentinel 6 1 Rapid Deployment Reference Guide novdocx en 13 May 2009 ...
Page 124: ...124 Sentinel 6 1 Rapid Deployment Reference Guide novdocx en 13 May 2009 ...
Page 132: ...132 Sentinel 6 1 Rapid Deployment Reference Guide novdocx en 13 May 2009 ...
Page 136: ...136 Sentinel 6 1 Rapid Deployment Reference Guide novdocx en 13 May 2009 ...