Qualys Data Import Utility logging

Products

• Information Centric Analytics

Issue/Introduction

When the Qualys Data Import Utility runs (either manually or executed by a SQL Server Agent job), it writes details of the operation to a log file on the file system rather than to a table in the Information Centric Analytics (ICA) relational database. In the course of troubleshooting, Broadcom support may request a copy of these logs. Refer to the Resolution section of this article for assistance with identifying the log file location.

Environment

Version : 6.x

Component : Qualys Data Import Utility

Resolution

The Qualys Data Import Utility's default log file location is in a subfolder of the path containing the QualysDataImport.exe executable and configuration utility binaries. Per Broadcom's recommendations, the Qualys import utility should be installed in the Database Utilities path on the server hosting the SQL Server instance in which the RiskFabric relational database is hosted.

If you are uncertain as to the exact location of this path, follow this procedure:

1. Open SQL Server Management Studio (SSMS)
2. Connect to the Database Engine hosting the RiskFabric relational database
3. From the File menu, select New > Query with Current Connection
   A new query editor window will open
4. Copy the following query and paste it in the new query editor window:

   SELECT [Value] FROM RiskFabric.dbo.PortalSettings WHERE [Name] = N'DatabaseUtilitiesFolderPath';

5. Execute the query by pressing the F5 key, clicking the Execute button in the SQL Editor toolbar, or selecting Execute from the Query menu
6. Note the path returned in the Results window
7. The Qualys Data Import Utility folder should be installed as a subfolder of the \Database Utilities path, and the Qualys utility's logs should be stored in a subfolder of the \Qualys Data Import Utility folder named \logs
   
   For example: D:\Program Files\Bay Dynamics\Database Utilities\Qualys Data Import Utility\logs

NOTE: The naming format of the import utility's log files is QualysDataImport<yyyyMMdd>.log