Aggragate tables of IVR Schema for Tenable.sc

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

PerformAggregates_SC_Vulnerabilities_Requiring_Content

Table 1. IVR.AGT_SC_Vulnerabilities_Requiring_Content_summaryThe IVR.AGT_SC_Vulnerabilities_Requiring_Content_summary contains detail information of Vulnerability Requiring content of Tenable SC
Name	Type	Description
`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
`Exploitability`	nvarchar	Exploitability information correlates with detected vulnerabilities when known exploits are published
`Published_Date`	nvarchar	The date when the vulnerability is published
`Published_Date_Key`	date
`Order_Key`	int
`Applicable_Devices`	int
`Solution`	nvarchar	The Solution section provides a suggested solution to fix the vulnerability or a reference defering to the vendor.

Table 2. IVR.AGT_SC_Vulnerabilities_Requiring_Content_devicedetailsThe IVR. AGT_SC_Vulnerabilities_Requiring_Content_devicedetails contains detail information of Device
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
`ComputerName`	nvarchar	Name of computer
`OperatingSystem`	nvarchar	Operating system of device
`IP_Address`	nvarchar	Ip address of device
`Device Type`	nvarchar
`Last Report Time`	datetime	Last report time of device to bigfix server
`Detected_Date_Key`	date
`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
`VPR_Score`	decimal	Tenable Vulnerability Priority Rating (VPR) Score

Table 3. IVR.AGT_SC_Vulnerabilities_Requiring_Content_cve_listThe IVR. AGT_SC_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

Table 4. IVR.AGT_SC_Vulnerabilities_Requiring_Content_detectedvullistThe IVR.AGT_SC_Vulnerabilities_Requiring_Content_detectedvullist contains detail information of detected vulnerability list
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`	datetime2	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
`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)
`FirstDetectedRowNum`	bigint

Table 5. IVR.AGT_SC_Vulnerabilities_Requiring_Content_tblMaxDateThe IVR.AGT_SC_Vulnerabilities_Requiring_Content_tblMaxDate contains detail of Max datetime
Name	Type	Description
MaxDate	nvarchar	Max of datetime

Table 6. IVR.AGT_SC_Vulnerabilities_Requiring_Content_Top5DeviceThe IVR. AGT_SC_Vulnerabilities_Requiring_Content_Top5Device contains detail of Top 5 device
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_SC_Vulnerabilities_With_Available_Fixlets

Table 7. IVR.AGT_SC_Vulnerabilities_With_Available_Fixlets_summaryThe IVR.AGT_Vulnerabilities_With_Available_Fixlets_applicablefixlets_summary contains detail information of Applicable fixlets of Tenable SC
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-8 High, 9-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
`VulnFixKey`	nvarchar

Table 8. IVR.AGT_SC_Vulnerabilities_With_Available_Fixlets_devicedetailsThe IVR. AGT_SC_Vulnerabilities_With_Available_Fixlets_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
`Device Type`	nvarchar
`Last Report Time`	datetime	Last report time of device to bigfix server
`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 9. IVR.AGT_SC_Vulnerabilities_With_Available_Fixlets_cve_list
The IVR. AGT_SC_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 10. IVR.AGT_SC_Vulnerabilities_With_Available_Fixlets_detectedvullistThe IVR. AGT_SC_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
`FirstDetectedRowNum`	bigint

Table 11. IVR.AGT_SC_Vulnerabilities_With_Available_Fixlets_tblMaxDateThe IVR. AGT_SC_Vulnerabilities_With_Available_Fixlets_tblMaxDate detail of Max datetime
Name	Type	Description
`MaxDate`	nvarchar	Max of datetime

Table 12. IVR.AGT_SC_Vulnerabilities_With_Available_Fixlets_Top5DeviceThe IVR. AGT_SC_Vulnerabilities_With_Available_Fixlets_tblMaxDate detail of Max datetime
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
`MaxDate`	nvarchar	Max of datetime

PerformAggregates_SC_VulnerabilityDiscrepancies

Table 13. IVR. AGT_SC_VulnerabilityDiscrepancies_summaryThe IVR. AGT_SC_VulnerabilityDiscrepancies_summary contains detail information of Vulnerability Discrepanciesof Tenable SC
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 CVSS
`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	Tenable Vulnerability Priority Rating (VPR) Score
`Exploitability`	nvarchar	Exploitability information correlates with detected vulnerabilities when known exploits are published
`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 14. IVR. AGT_SC_VulnerabilityDiscrepancies_devicedetailsThe IVR. AGT_SC_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
`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	Internal key
`VulnFixKey`	nvarchar
`VPR_Score`	decimal	Tenable Vulnerability Priority Rating (VPR) Score

Table 15. IVR. AGT_SC_VulnerabilityDiscrepancies_cve_listThe IVR. AGT_SC_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 16. IVR. AGT_SC_VulnerabilityDiscrepancies_detectedvullistThe IVR. AGT_SC_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
`CVSS2`	nvarchar	Common Vulnerability Scoring System (CVSS2) base score calculated according to the formula defined here: https://nvd.nist.gov/vuln-metrics/cvss/v2-calculator. Note that this field is based on CVSS v2.
`CVSS2_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)
`VulnFixKey`	nvarchar
`FirstDetectedRowNum`	bigint

Table 17. IVR. AGT_SC_VulnerabilityDiscrepancies_tblMaxDateThe IVR. AGT_SC_VulnerabilityDiscrepancies_tblMaxDate detail of Max datetime
Name	Type	Description
MaxDate	nvarchar	Max of datetime

Table 18. IVR AGT_SC_VulnerabilityDiscrepancies_Top5DeviceThe IVR. AGT_SC_VulnerabilityDiscrepancies_Top5Device contains detail of Top 5 device
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