Aggregate tables of IVR Schema for Tenable.io

The tables in this section provide detailed information about Aggregate tables of IVR Schema.

PerformAggregates_IO_Vulnerabilities_Requiring_Content

Table 1. IVR.AGT_IO_Vulnerabilities_Requiring_Content_summaryThe IVR. AGT_IO_Vulnerabilities_Requiring_Content_summary contains detail information of Vulnerability Requiring content of Tenable IO
Name	Type	Description
`Vulnerability Title`	nvarchar	Vulnerability title as defined by Tenable
`Int_Parent_ID`	nvarchar	Parent_ID facilitates the hierarchy between PluginID and CVEs. It will be PluginID, when a CVE is represented by the Vulnerability ID.
`CVSS`	nvarchar	Common Vulnerability Scoring System (CVSS) base score calculated according to the formula defined here: https://nvd.nist.gov/vuln-metrics/cvss/v2-calculator Notet hat this field is based on CVSS v2.
`CVSS Sort`	int	Internal sorting of CVSS values
`Severity`	varchar	The Fixlet severity. Tenable values: 0 - information, 1-4 Low, 5-6 Medium, 7-8 High, 9-10 Critical
`VPR_Sort`	int	Sorted Tenable Vulnerability Priority Rating (VPR)
`VPR_Score`	decimal
`Exploitability`	nvarchar	Exploitability information correlates with detected vulnerabilities when known exploits are pulished
`Published Date_Key`	date
`Published Date`	nvarchar	The date when the vulnerability is published
`solution`	nvarchar	The Solution section provides a suggested solution to fix the vulnerability or a reference defering to the vendor.
`Order_Key`	int	internal
`Applicable_Devices`	int	Pre-calculated count of devices by vulnerability

Table 2. IVR.AGT_IO_Vulnerabilities_Requiring_Content_devicedetailsThe IVR. AGT_IO_Vulnerabilities_Requiring_Content_devicedetails contains detail information of Device of Tenable IO
Name	Type	Description
`Int_Parent_ID`	nvarchar	Parent_ID facilitates the hierarchy between PluginID and CVEs. It will be a PluginID, when a CVE is represented by the Vulnerability ID.
`DeviceID`	varchar	The unique computer ID assigned by Insights to a machine. References: dbo.datasource_devices
`Device_Key`	bigint	Internal key for a device record
`ComputerName`	nvarchar	Name of computer
`OperatingSystem`	nvarchar	Operating system of device
`IP_Address`	nvarchar	Ip address of device
`Device Type`	nvarchar	Type of device
`aes_value`	nvarchar
`acr_value`	nvarchar
`Last Report Time`	datetime	Last report time of device to bigfix server
`Detected_Date_Key`	date	Internal key
`Detected_Date`	nvarchar	Time stamp for detection.
`Last_Detected_Date_Key`	date
`Last_Detected_Date`	nvarchar	Time stamp for last detection.
`Results`	nvarchar	This is provided by the IVR datasource and may contain a brief description as to why the vulnerability has been identified.
`VulnDevKey`	nvarchar	Internal key
`VPR_Score`	decimal	Tenable Vulnerability Priority Rating (VPR) Score

Table 3. IVR.AGT_IO_Vulnerabilities_Requiring_Content_cve_listThe IVR. AGT_IO_Vulnerabilities_Requiring_Content_cve_list contains detail information of CVE list
Name	Type	Description
vulnerability_id	nvarchar	ID of the vulnerability as assigned by UVM (This will be defined as Plugin_Id). In the case of a CVE being used as a Vulnerability_ID, the ParentID should be a PluginID
CVE_List	nvarchar	List of CVE records related to the Parent Vulnerability ID

Table 4. IVR.AGT_IO_Vulnerabilities_Requiring_Content_detectedvullistThe IVR.AGT_IO_Vulnerabilities_Requiring_Content_detectedvullist contains detail information of detected vulnerability list of Tenable IO
Name	Type	Description
`Int_Parent_ID`	nvarchar	CVE ID of a given vulnerability. (Tenable: note plugin id's are not singularly represented by a CVE, there is an individual record for CVEs as well.)
`first_detected`	datetime	Time stamp for first detected
`global_computer_id`	bigint	The unique computer ID assigned by Insights to a machine. References: dbo.datasource_devices
`CVSS`	nvarchar	Common Vulnerability Scoring System (CVSS) base score calculated according to the formula defined here: https://nvd.nist.gov/vuln-metrics/cvss/v2-calculator
`CVSS2_Sort`	int	Sorted CVSS2
`Severity`	varchar	The Fixlet severity. Tenable values: 0 - information, 1-4 Low, 5-6 Medium, 7-8 High, 9-10 - Critical
`VPR_Sort`	int	Sorted Tenable Vulnerability Priority Rating (VPR)
`FirstDetectedRowNum`	bigint

Table 5. IVR.AGT_IO_Vulnerabilities_Requiring_Content_tblMaxDateThe IVR.AGT_IO_Vulnerabilities_Requiring_Content_tblMaxDate contains detail of Max datetime
Name	Type	Description
`MaxDate`	nvarchar	Max of datetime

Table 6. IVR.AGT_IO_Vulnerabilities_Requiring_Content_Top5DeviceaesThe IVR. AGT_IO_Vulnerabilities_Requiring_Content_Top5Deviceaes contains detail of Top 5 device of aes
Name	Type	Description
`DeviceID`	varchar	The unique computer ID assigned by Insights to a machine. References: dbo.datasource_devices
`ComputerName`	nvarchar	Name of Computer
`AES_Total`	decimal

Table 7. IVR.AGT_IO_Vulnerabilities_Requiring_Content_Top5DevicevprThe IVR. AGT_IO_Vulnerabilities_Requiring_Content_Top5Devicevpr contains detail of Top 5 device of vpr
Name	Type	Description
`DeviceID`	varchar	The unique computer ID assigned by Insights to a machine. References: dbo.datasource_devices
`ComputerName`	nvarchar	Name of computer
`VPR_Total`	decimal

PerformAggregates_IO_Vulnerabilities_With_Available_Fixlets

Table 8. IVR.AGT_IO_Vulnerabilities_With_Available_Fixlets_summaryThe IVR.AGT_IO_Vulnerabilities_With_Available_Fixlets_summary contains detail information of Applicable fixlets Tenable IO
Name	Type	Description
`Vulnerability Title`	nvarchar	Vulnerability title as defined by Tenable
`Int_Parent_id`	nvarchar	Parent_ID facilitates the hierarchy between PluginID and CVEs. It will be PluginID, when a CVE is represented by the Vulnerability ID.
`CVSS`	nvarchar	Common Vulnerability Scoring System (CVSS) base score calculated according to the formula defined here: https://nvd.nist.gov/vuln-metrics/cvss/v2-calculator
`CVSS_Sort`	int	Sorted CVSS
`Severity`	varchar	The Fixlet severity. Tenable values: 0 - information, 1-4 Low, 5-6 Medium, 7-9 High, 10 - Critical
`VPR_Sort`	int	Sorted Tenable Vulnerability Priority Rating (VPR)
`VPR_Score`	decimal	Tenable Vulnerability Priority Rating (VPR) Score
`Exploitability`	nvarchar	Exploitability information correlates with detected vulnerabilities when known exploits are pulished
`Published Date_Key`	date
`Published Date`	nvarchar	The date when the vulnerability is published
`Source Release Date`	nvarchar	Time stamp for release
`Product/Family`	nvarchar
`Fixlet Title`	nvarchar	Title name of fixlet
`Fixlet Source ID`	nvarchar	Source Id of fixlet
`Fixlet Category`	nvarchar
`Fixlet ID`	bigint	Id of Fixlet
`Fixlet_Join_ID`	bigint
`Fixlet Site Name`	nvarchar
`solution`	nvarchar	The Solution section provides a suggested solution to fix the vulnerability or a reference deferring to the vendor
`Order_Key`	int	Internal key
`Applicable_Devices`	int	Calculated total of devices per vulnerability
`VulnFixKey`	nvarchar	Internal key

Table 9. IVR.AGT_IO_Vulnerabilities_With_Available_Fixlets_devicedetailsThe IVR. AGT_IO_Vulnerabilities_With_Available_Fixlets_devicedetails contains detail information of device list of Tenable IO
Name	Type	Description
`Int_Parent_ID`	nvarchar	Parent_ID facilitates the hierarchy between PluginID and CVEs. It will be a PluginID, when a CVE is represented by the Vulnerability ID.
`Fixlet_Join_ID`	bigint
`DeviceID`	varchar	The unique computer ID assigned by Insights to a machine. References: dbo.datasource_devices
`Device_Key`	bigint
`ComputerName`	nvarchar	Name of computer
`OperatingSystem`	nvarchar	OS of device
`IP_Address`	nvarchar	Ip address
`Device Type`	nvarchar
`Last Report Time`	datetime	Last report time of device to bigfix server
`aes_value`	nvarchar
`acr_value`	nvarchar
`Detected_Date_Key`	date
`Detected_Date`	nvarchar	Time Stamp for detected
`Last_Detected_Date_Key`	date
`Last_Detected_Date`	nvarchar	Time stamp of last detected
`results`	nvarchar	This is provided by the IVR datasource and may contain a brief description as to why the vulnerability has been identified.
`VulnDevKey`	nvarchar
`VulnFixKey`	nvarchar
`VPR_Score`	decimal	Tenable Vulnerability Priority Rating (VPR) Score

Table 10. IVR.AGT_IO_Vulnerabilities_With_Available_Fixlets_cve_listThe IVR. AGT_IO_Vulnerabilities_With_Available_Fixlets_cve_list contains detail information of CVE list
Name	Type	Description
`parent_id`	nvarchar	Parent_ID facilitates the hierarchy between PluginID and CVEs. It will be a PluginID, when a CVE is represented by the Vulnerability ID.
`global_fixlet_id`	bigint	Id of fixlet
`VulnFixKey`	nvarchar
`CVE_List`	nvarchar	List of cve id

Table 11. IVR.AGT_IO_Vulnerabilities_With_Available_Fixlets_detectedvullistThe IVR. AGT_IO_Vulnerabilities_With_Available_Fixlets_detectedvullist contains detail information of Detected Vulnerability list
Name	Type	Description
`Int_Parent_ID`	nvarchar	Parent_ID facilitates the hierarchy between PluginID and CVEs. It will be a PluginID, when a CVE is represented by the Vulnerability ID.
`first_detected`	datetime2	Time stamp of first detected
`CVSS`	nvarchar	Common Vulnerability Scoring System (CVSS) base score calculated according to the formula defined here: https://nvd.nist.gov/vuln-metrics/cvss/v2-calculator
`CVSS_Sort`	int	Sorted CVSS
`Severity`	varchar	The Fixlet severity. Tenable values: 0 - information, 1-4 Low, 5-6 Medium, 7-9 High, 10 - Critical
`VPR_Sort`	int	Sorted Tenable Vulnerability Priority Rating (VPR)
`VulnFixKey`	nvarchar	Internal key
`FirstDetectedRowNum`	bigint

Table 12. IVR.AGT_IO_Vulnerabilities_With_Available_Fixlets_tblMaxDateThe IVR. AGT_IO_Vulnerabilities_With_Available_Fixlets_tblMaxDate contains detail of Max datetime
Name	Type	Description
MaxDate	nvarchar	Max of datetime

Table 13. IVR.AGT_IO_Vulnerabilities_Requiring_Content_Top5DeviceaesThe IVR. AGT_IO_Vulnerabilities_Requiring_Content_Top5Deviceaes contains detail of Top 5 device of aes
Name	Type	Description
DeviceID	varchar	The unique computer ID assigned by Insights to a machine. References: dbo.datasource_devices
ComputerName	nvarchar	Name of computer
AES_Total	decimal

Table 14. IVR.AGT_IO_Vulnerabilities_Requiring_Content_Top5DevicevprThe IVR. AGT_IO_Vulnerabilities_Requiring_Content_Top5Devicevpr contains detail of Top 5 device of vpr
Name	Type	Description
`DeviceID`	varchar	The unique computer ID assigned by Insights to a machine. References: dbo.datasource_devices
`ComputerName`	nvarchar	Name of computer
`VPR_Total`	decimal

PerformAggregates_IO_VulnerabilityDiscrepancies

Table 15. IVR.AGT_IO_VulnerabilityDiscrepancies_summaryThe IVR. AGT_IO_VulnerabilityDiscrepancies_summary contains detail information of Vulnerability Discrepancies summary
Name	Type	Description
`Vulnerability Title`	nvarchar	Vulnerability title as defined by Tenable
`Int_Parent_id`	nvarchar	Parent_ID facilitates the hierarchy between PluginID and CVEs. It will be PluginID when a CVE is represented by the Vulnerability ID.
`CVSS`	nvarchar	Common Vulnerability Scoring System (CVSS2) base score calculated according to the formula defined here: https://nvd.nist.gov/vuln-metrics/cvss/v2-calculator
CVSS_Sort	int	Sorted CVSS2
`Severity`	varchar	The Fixlet severity. Tenable values: 0 - information, 1-4 Low, 5-6 Medium, 7-9 High, 10 - Critical
`VPR_Sort`	int	Sorted Tenable Vulnerability Priority Rating (VPR)
`VPR_Score`	decimal	Tenable Vulnerability Priority Rating (VPR) Score
`Exploitability`	nvarchar	Exploitability information correlates with detected vulnerabilities when known exploits are pulished
`Published Date_Key`	date
`Published Date`	nvarchar	The date when the vulnerability is published
`Source Release Date`	nvarchar	Time stamp for release
`Product/Family`	nvarchar
`Fixlet Title`	nvarchar	Title name of fixlet
`Fixlet Source ID`	nvarchar	Source ID of Fixlet
`Fixlet Category`	nvarchar
`Fixlet ID`	bigint	ID of Fixlet
`Fixlet_Join_ID`	bigint
`Fixlet Site Name`	nvarchar
`solution`	nvarchar	The Solution section provides a suggested solution to fix the vulnerability or a reference deferring to the vendor.
`Order_Key`	int
`Applicable_Devices`	int
`VulnFixKey`	nvarchar

Table 16. IVR.AGT_IO_VulnerabilityDiscrepancies_devicedetailsThe IVR. AGT_IO_VulnerabilityDiscrepancies_devicedetails contains detail information of device list
Name	Type	Description
`Int_Parent_ID`	nvarchar	Parent_ID facilitates the hierarchy between PluginID and CVEs. It will be a PluginID, when a CVE is represented by the Vulnerability ID.
`Fixlet_Join_ID`	bigint
`DeviceID`	varchar	The unique computer ID assigned by Insights to a machine. References: dbo.datasource_devices
`Device_Key`	bigint
`ComputerName`	nvarchar	Name of computer
`OperatingSystem`	nvarchar	Os of device
`IP_Address`	nvarchar	Ip address of device
`Device Type`	nvarchar
`Last Report Time`	datetime	Last report time of device to bigfix server
`aes_value`	nvarchar
`acr_value`	nvarchar
`Detected_Date_Key`	date
`Detected_Date`	nvarchar	Time stamp for detected date
`Last_Detected_Date_Key`	date
`Last_Detected_Date`	nvarchar	Time stamp for last detected
`Results`	nvarchar	This is provided by the IVR datasource and may contain a brief description as to why the vulnerability has been identified.
`VulnDevKey`	nvarchar
`VulnFixKey`	nvarchar
`VPR_Score`	decimal	Tenable Vulnerability Priority Rating (VPR) Score

Table 17. IVR.AGT_IO_VulnerabilityDiscrepancies_cve_listThe IVR. AGT_IO_VulnerabilityDiscrepancies_cve_list contains detail information of CVE list
Name	Type	Description
`parent_id`	nvarchar	Parent_ID facilitates the hierarchy between PluginID and CVEs. It will be a PluginID, when a CVE is represented by the Vulnerability ID.
`global_fixlet_id`	bigint	Id of fixlet
`VulnFixKey`	nvarchar
`CVE_List`	nvarchar	List of CVE

Table 18. IVR.AGT_IO_VulnerabilityDiscrepancies_detectedvullistThe IVR. AGT_IO_VulnerabilityDiscrepancies_detectedvullist contains detail information of Detected Vulnerability list
Name	Type	Description
`Int_Parent_ID`	nvarchar	Parent_ID facilitates the hierarchy between PluginID and CVEs. It will be a PluginID, when a CVE is represented by the Vulnerability ID.
`first_detected`	datetime2	Time stamp for first detected date
`CVSS`	nvarchar	Common Vulnerability Scoring System (CVSS2) base score calculated according to the formula defined here: https://nvd.nist.gov/vuln-metrics/cvss/v2-calculator
`CVSS_Sort`	int	Sorted CVSS
`Severity`	varchar	The Fixlet severity. Tenable values: 0 - information, 1-4 Low, 5-6 Medium, 7-9 High, 10 - Critical
`VPR_Sort`	int	Sorted Tenable Vulnerability Priority Rating (VPR)
`VulnFixKey`	nvarchar
`FirstDetectedRowNum`	bigint

Table 19. IVR.AGT_IO_VulnerabilityDiscrepancies_tblMaxDateThe IVR. AGT_IO_VulnerabilityDiscrepancies_tblMaxDate detail of Max datetime
Name	Type	Description
MaxDate	nvarchar	Max of datetime

Table 20. IVR.AGT_IO_VulnerabilityDiscrepancies_Top5DeviceaesThe IVR. AGT_IO_VulnerabilityDiscrepancies_Top5Deviceaes contains detail of Top 5 device of aes
Name	Type	Description
DeviceID	varchar	The unique computer ID assigned by Insights to a machine. References: dbo.datasource_devices
ComputerName	nvarchar	Name of computer
AES_Total	decimal

Table 21. IVR.AGT_IO_VulnerabilityDiscrepancies_Top5DevicevprThe IVR. AGT_IO_VulnerabilityDiscrepancies_Top5Devicevpr contains detail of Top 5 device of vpr
Name	Type	Description
`DeviceID`	varchar	The unique computer ID assigned by Insights to a machine. References: dbo.datasource_devices
`ComputerName`	nvarchar	Name of computer
`VPR_Total`	decimal