Imperva Cyber Community

communities_1.jpg
 View Only
  • 1.  export log in csv

    Posted 12-17-2019 08:51
    Iis there any command in oder to generate and export a csv from a gateway, containing all data logged by a policy?

    Thank you
    #DatabaseActivityMonitoring

    ------------------------------
    claudio
    ------------------------------


  • 2.  RE: export log in csv

    Posted 12-17-2019 10:16
    Generally, I'd like to export at the end of the day all data generated by the policy and put that on an external logger.

    ------------------------------
    claudio milan
    ------------------------------



  • 3.  RE: export log in csv

    Posted 12-19-2019 07:47
    I would recommend generating a report in CSV format with a data scope of last few days = 1 and then looking at your followed action on what to do with the resulting output. report will pull data from all gateways for the policy. not sure why you want to export directly from gateway.

    ------------------------------
    Trevor Jackson
    Database Security Specialist
    Virgin Media
    ------------------------------



  • 4.  RE: export log in csv

    Posted 12-19-2019 07:52
    This is because I'd like to use an asynchronous procedure to export data to an external system without using syslog.

    Any other suggestion?

    ------------------------------
    claudio milan
    ------------------------------



  • 5.  RE: export log in csv

    Posted 12-19-2019 08:25
    I was thinking along the lines of creating an OS Script that would ftp or scp the report file to chosen destination and  processing from there.
    Unsure if you can export audit data directly from gateway as never come across that before, only archive.

    rgds

    ------------------------------
    Trevor Jackson
    Database Security Specialist
    Virgin Media
    ------------------------------