Imperva Cyber Community

Hi everyone,

I have noticed that some reports do not show the complete query, is there a way to fix this?


Thanks for your support
#DatabaseActivityMonitoring

------------------------------
Jose Sanchezc
Consultant
Cali
------------------------------

Hi,

Too big reports in PDF are truncated by default settings. Maybe it is the problem
Try to generate a report in CSV and compare both or change parameter in Admin -> System definition.

------------------------------
Karol Gruszczyński
IT Security Expert
Trafford IT
Warsaw
------------------------------

Thank you for your reply, I have generated the report in CSV and it shows the same thing



------------------------------
Jose Sanchezc
Consultant
Cali
------------------------------

Original Message:
Sent: 06-28-2022 09:48
From: Karol Gruszczyński
Subject: Incomplete query

Hi,

Too big reports in PDF are truncated by default settings. Maybe it is the problem
Try to generate a report in CSV and compare both or change parameter in Admin -> System definition.

------------------------------
Karol Gruszczyński
IT Security Expert
Trafford IT
Warsaw
------------------------------

Do you see these logs at Audit -> DB Audit Data correctly?
Try one more - You can save PDF on Audit -> DB Audit Data -> Events there and compare it with the previous reports.
Please check if the data are correctly written in the logs. Try to find the same row on raw logs and PDF report.



------------------------------
Karol Gruszczyński
IT Security Expert
Trafford IT
Warsaw
------------------------------

Original Message:
Sent: 06-29-2022 09:28
From: Jose Sanchezc
Subject: Incomplete query

Thank you for your reply, I have generated the report in CSV and it shows the same thing



------------------------------
Jose Sanchezc
Consultant
Cali
------------------------------


Original Message:
Sent: 06-28-2022 09:48
From: Karol Gruszczyński
Subject: Incomplete query

Hi,

Too big reports in PDF are truncated by default settings. Maybe it is the problem
Try to generate a report in CSV and compare both or change parameter in Admin -> System definition.

------------------------------
Karol Gruszczyński
IT Security Expert
Trafford IT
Warsaw

Hi,

Can you see full query on DB Audit Data page of MX for related Audit Policy?

For full SQL query logging, you should enable Events logging in the Audit Policy settings like below. You can check this option.


------------------------------
Cezmi Cal
technical support engineer
Barikat Cyber Security
Ankara
------------------------------

Hello everyone,

It seems that it was a failure in the executed query, the event box is active in the policy and in DBAudit Data the query is still incomplete, however the MX indicates that there was a SQL exception.

Thanks for your support.

------------------------------
Jose Sanchezc
Consultant
Cali
------------------------------