Qualys Importer cannot retrieve Qualys Host Detections data

Products

• Information Centric Analytics

Issue/Introduction

You are having issues with your Qualys Importer completing because of the large range of host IDs in the query parameters.
 
Is there a parameter to help reduce the number of host IDs passed by the importer to the Qualys API?

Environment

Version : 6.x

Component : Qualys Import Utility

Resolution

Reduce the host detection partition size by executing the following statement against the QualysGuardDW relational database:

USE QualysGuardDW;
GO

MERGE INTO [dbo].[ApiOptions] AS target
USING (VALUES ('HostDetectionPartitionSize', '1000')) AS source (OptionField, OptionValue)
   ON target.OptionField = source.OptionField
WHEN  MATCHED THEN
      UPDATE SET OptionValue = source.OptionValue
WHEN  NOT MATCHED THEN
      INSERT (OptionField, OptionValue)
      VALUES (source.OptionField, source.OptionValue);