IVR Fixlets and Tasks

• Vulnerabilities With Available Fixlets - A list of vulnerabilities that have matching BigFix Fixlets available for remediation. The report will list the most recent Fixlet related to each vulnerability, and the CVE entries that are associated to the vulnerability.
• Vulnerabilities Without Available Fixlets - A list of vulnerabilities that do not have an available Fixlet for remediation.
• Vulnerability Discrepancies - A list of vulnerabilities where the scanning system identifies the issue, but BigFix does not see an applicable remediation.

• Tenable.io
  • http://software.bigfix.com/download/ivr/1.4/Dashboards_PowerBI_Tenableio.tmp
  • http://software.bigfix.com/download/ivr/1.4/Dashboards_Tableau_Tenableio.tmp
• Tenable.sc
  • http://software.bigfix.com/download/ivr/1.4/Dashboards_PowerBI_Tenable.tmp
  • http://software.bigfix.com/download/ivr/1.4/Dashboards_Tableau_Tenable.tmp
• Qualys
  • http://software.bigfix.com/download/ivr/1.4/Dashboards_PowerBI_Qualys.tmp
  • http://software.bigfix.com/download/ivr/1.4/Dashboards_Tableau_Qualys.tmp

DECLARE @Sql VARCHAR(MAX), @Schema varchar(20)
SET @Schema = 'ivr' --put your schema name between these quotes
SELECT @Sql = COALESCE(@Sql,'') + 'DROP TABLE %SCHEMA%.' + QUOTENAME(TABLE_NAME) + ';'
+ CHAR(13)
FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = @Schema AND TABLE_TYPE = 'BASE
TABLE'
ORDER BY TABLE_NAME SELECT @Sql = COALESCE(@Sql,'') + 'DROP PROCEDURE %SCHEMA%.' +
QUOTENAME(ROUTINE_NAME) + ';' + CHAR(13)
FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA = @Schema AND ROUTINE_TYPE =
'PROCEDURE'
ORDER BY ROUTINE_NAME SELECT @Sql = COALESCE(@Sql,'') + 'DROP FUNCTION %SCHEMA%.' +
QUOTENAME(ROUTINE_NAME) + ';' + CHAR(13)
FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA = @Schema AND ROUTINE_TYPE =
'FUNCTION'
ORDER BY ROUTINE_NAME SELECT @Sql = COALESCE(REPLACE(@Sql,'%SCHEMA%',@Schema), '')
exec (@Sql);
drop schema ivr;

DROP TABLE IF EXISTS [ivr].[vulnerability_fixlet_nexus]DROP TABLE IF EXISTS
[ivr].[findings]
DROP TABLE IF EXISTS [ivr].[vulnerabilities]DROP TABLE IF EXISTS
[ivr].[global_computer_values]
DROP TABLE IF EXISTS [ivr].[schema]DROP TABLE IF EXISTS [ivr].[analysis_calendar]
DROP FUNCTION IF EXISTS [ivr].[rtrim_non_ascii]DROP schema IF EXISTS [ivr]