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.
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.