Aggregate tables of IVR Schema for Qualys

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

PerformPerformAggregates_Vulnerability_Requiring_Content

Table 1. IVR.AGT_Vulnerability_Requiring_Content_summaryThe IVR.AGT_Vulnerability_Requiring_Content_summary contains detail information of Vulnerability Requiring content
Name	Type	Description
`Vulnerability Title`	nvarchar	Vulnerability title defined by Qualys
`Int_Parent_ID`	nvarchar	Parent_ID facilitates the hierarchy between QID and CVEs. It will be a QID, when a CVE is represented by the Vulnerability ID.
`CVSS2`	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
`Qualys Severity`	varchar	The Fixlet severity. Possible Qualys values: 1- minimal, 2 - medium, 3 - serious, 4 - critical, 5 - urgent. For reference, please see: https://qualysguard.qg2.apps.qualys.com/qwebhelp/fo_portal/knowledgebase/severity_levels.htm
`Qualys Severity Score`	nvarchar
`Qualys_Severity_Sort`	int	Sorted Serverity
`Published Date`	nvarchar	The date when the vulnerability is published
`Published Date_Key`	date
`Order_Key`	int
`Detected 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_Vulnerability_Requiring_Content_devicedetailsThe IVR. AGT_Vulnerability_Requiring_Content_devicedetails contains detail information of Device
Name	Type	Description
`Int_Parent_ID`	nvarchar	Parent_ID facilitates the hierarchy between QID and CVEs. It will be a QID, 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
`Qualys Score`	nvarchar

Table 3. IVR.AGT_Vulnerability_Requiring_Content_cve_listThe IVR. AGT_Vulnerability_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 QID). In the case of a CVE being used as a Vulnerability_ID, the ParentID should be a QID
`CVE_List`	nvarchar	List of CVE

Table 4. IVR.AGT_Vulnerability_Requiring_Content_detectedvullistThe IVR.AGT_Vulnerability_Requiring_Content_detectedvullist contains detail information of detected vulnerability list
Name	Type	Description
`Int_Parent_ID`	nvarchar	CVE ID of a given vulnerability. Qualys: provides vulnerabilty ID.
`first_detected`	datetime2	Time stamp for first detection
`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
`Qualys Severity`	varchar	The Fixlet severity. Possible Qualys values: 1- minimal, 2 - medium, 3 - serious, 4 - critical, 5 – urgent
`Qualys_Severity_Sort`	int	Sorted severity
`FirstDetectedRowNum`	bigint

Table 5. IVR.AGT_Vulnerability_Requiring_Content_tblMaxDateThe IVR.AGT_Vulnerability_Requiring_Content_tblMaxDate contains detail of Max datetime
Name	Type	Description
`MaxDate`	nvarchar	Max of datetime

Table 6. IVR.AGT_Vulnerability_Requiring_Content_Top5DeviceThe IVR. AGT_Vulnerability_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
`Qualys_Total`	decimal

PerformAggregates_Vulnerabilities_With_Available_Fixlets

Table 7. IVR.AGT_Vulnerabilities_With_Available_Fixlets_applicablefixlets_summaryThe IVR.AGT_Vulnerabilities_With_Available_Fixlets_applicablefixlets_summary contains detail information of Applicable fixlets
Name	Type	Description
`Vulnerability Title`	nvarchar	Vulnerability title as defined by Qualys.
`Int_Parent_id`	nvarchar	Parent_ID facilitates the hierarchy between QID and CVEs. It will be a QID, 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
`Qualys Severity`	varchar	The Fixlet severity. Possible Qualys values: 1- minimal, 2 - medium, 3 - serious, 4 - critical, 5 - urgent.
`Qualys Severity Score`	nvarchar
`Qualys_Severity_Sort`	int	Sorted Serverity
`Weighted_score`	bigint	Value calculated based on cvss_base*applicable_computers as 'weighted score'.
`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
`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 8. IVR.AGT_Vulnerabilities_With_Available_Fixlets_devicedetailsThe IVR. AGT_Vulnerabilities_With_Available_Fixlets_devicedetails contains detail information of device list
Name	Type	Description
`Int_Parent_ID`	nvarchar	Parent_ID facilitates the hierarchy between QID and CVEs. It will be a QID, 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
`Qualys Score`	decimal

Table 9. IVR.AGT_Vulnerabilities_With_Available_Fixlets_cvelistThe IVR. AGT_Vulnerabilities_With_Available_Fixlets_cvelist contains detail information of CVE list
Name	Type	Description
parent_id	nvarchar	Parent_ID facilitates the hierarchy between QID and CVEs. It will be a QID, 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_Vulnerabilities_With_Available_Fixlets_detectedvullistThe IVR. AGT_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 QID and CVEs. It will be a QID, 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
`Qualys Severity`	varchar	The Fixlet severity. Possible Qualys values: 1- minimal, 2 - medium, 3 - serious, 4 - critical, 5 - urgent.
`Qualys_Severity_Sort`	int	Sorted Serverity
`VulnFixKey`	nvarchar
`FirstDetectedRowNum`	bigint

Table 11. IVR. AGT_Vulnerabilities_With_Available_Fixlets_tblMaxDateThe IVR. AGT_Vulnerabilities_With_Available_Fixlets_tblMaxDate contains detail of Max datetime
Name	Type	Description
MaxDate	nvarchar	Max of datetime

Table 12. IVR.AGT_Vulnerabilities_With_Available_Fixlets_Top5DeviceThe IVR. AGT_Vulnerabilities_With_Available_Fixlets_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
`Qualys_Total`	decimal

PerformAggregates_VulnerabilityDiscrepancies

Table 13. IVR.AGT_VulnerabilityDiscrepancies_summaryThe IVR. AGT_VulnerabilityDiscrepancies contains detail information of Vulnerability Discrepancies
Name	Type	Description
`Vulnerability Title`	nvarchar	Vulnerability title as defined by Qualys.
`Int_Parent_ID`	nvarchar	Parent_ID facilitates the hierarchy between QID and CVEs. It will be a QID, 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
`Qualys Severity`	varchar	The Fixlet severity. Possible Qualys values: 1- minimal, 2 - medium, 3 - serious, 4 - critical, 5 - urgent.
`Qualys Severity_Score`	nvarchar
`Qualys_Severity_Sort`	int	Sorted severity
`Published Date_Key`	date
`Published Date`	nvarchar	Time stamp for publish date
`Source Release Date`	nvarchar	Time stamp for release date
`Product/Family`	nvarchar
`Fixlet Title`	nvarchar	Title 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
`Order_Key`	int
`Detected_Devices`	int
`VulnFixKey`	nvarchar
`Solution`	nvarchar	The Solution section provides a suggested solution to fix the vulnerability or a reference deferring to the vendor

Table 14. IVR.AGT_VulnerabilityDiscrepancies_devicedetailsThe IVR. AGT_VulnerabilityDiscrepancies_devicedetails contains detail information of device list
Name	Type	Description
`Int_Parent_ID`	nvarchar	Parent_ID facilitates the hierarchy between QID and CVEs. It will be a QID, 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	Internal key
`Qualys_Score`	nvarchar

Table 15. IVR.AGT_VulnerabilityDiscrepancies_cvelistThe IVR. AGT_VulnerabilityDiscrepancies_cvelist contains detail information of CVE list
Name	Type	Description
`parent_id`	nvarchar	Parent_ID facilitates the hierarchy between QID and CVEs. It will be a QID, 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_VulnerabilityDiscrepancies_detectedvullistThe IVR. AGT_VulnerabilityDiscrepancies_detectedvullist contains detail information of Detected Vulnerability list
Name	Type	Description
`Int_Parent_ID`	nvarchar	Parent_ID facilitates the hierarchy between QID and CVEs. It will be a QID, 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
`Qualys Severity`	varchar	The Fixlet severity. Possible Qualys values: 1- minimal, 2 - medium, 3 - serious, 4 - critical, 5 - urgent.
`Qualys_Severity_Sort`	int	Sorted Severity
`VulnFixKey`	nvarchar
`FirstDetectedRowNum`	bigint

Table 17. IVR.AGT_VulnerabilityDiscrepancies_tblMaxDateThe IVR. AGT_VulnerabilityDiscrepancies_tblMaxDate detail of Max datetime
Name	Type	Description
MaxDate	nvarchar	Max of datetime

Table 18. IVR.AGT_VulnerabilityDiscrepancies_Top5DeviceThe IVR. AGT_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
`Qualys_Total`	decimal