How do I obtain a copy of the logs produced by the Qualys integration utility when SQL server agent job RiskFabric - Qualys Connector generates an error?

book

Article ID: 171434

calendar_today

Updated On:

Products

Information Centric Analytics Data Loss Prevention Core Package

Issue/Introduction

When the Qualys Integration gets invoked by the SQL Server agent job entitled RiskFabric - Qualys Connector and it generates an error, we will need to review the logs being produced by the Qualys integration utility to determine the root cause of the failure.  The error information being produced by the Qualys integration utility will not be logged in the ICA database schema, the logs will be self-contained within the Qualys integration utility directory. 

Environment

SQL Server

Resolution

  1. The Qualys integration utility is usually stored within the same directory of the database utilities directory.  To identify the location of the database utilities folder path you can execute the following query against the portal settings object: 
    1. Select [Name],[Value] from PortalSettings where Name = 'DatabaseUtilitiesFolderPath'

Figure 1 Portal Settings Query to determine the location of the DatabaseUtilitiesFolderPath

2. Launch Windows Remote Desktop Connection to the server hosting the ICA database schema.  The Qualys integration utility is stored within the database utilities directory commonly stored on the database server which we identified in step 1. 

3. The Qualys integration utility in this scenario is located at D:\Program Files\Bay Dynamics\Qualys Data Import Utility\Logs.