Imperva Cyber Community

 View Only
  • 1.  Incomplete query

    Posted 06-13-2022 11:34
    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
    ------------------------------


  • 2.  RE: Incomplete query

    Posted 06-28-2022 09:48
    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
    ------------------------------



  • 3.  RE: Incomplete query

    Posted 06-29-2022 09:29
    Thank you for your reply, I have generated the report in CSV and it shows the same thing



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



  • 4.  RE: Incomplete query

    Posted 06-29-2022 09:59
    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
    ------------------------------



  • 5.  RE: Incomplete query

    Posted 06-29-2022 10:20
    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
    ------------------------------



  • 6.  RE: Incomplete query

    Posted 06-30-2022 17:43
    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
    ------------------------------