Configure Gurucul Risk Analytics Data Forwarder (CEF logs)

Prev Next
  1. From the Gurucul interface, navigate to Configure | Data | Data Export | Data Forwarder Workflow | Configuration (Top right corner) | +Add (Top right corner).

  2. Configure the data source.

    Option

    Definition

    Name

    A logical name for the configuration

    Destination type

    SyslogForwarder

    Query String

    SELECT

    trendingriskvalues.id AS id, globalusers.userrisk AS userrisk, concat(trendingriskvalues.risk_update_time,' ',(select DATE_FORMAT(end_date,'%H:%i:%s') from job_details where job_name like '%Risk Scoring%' and status_flag='SUCCESS' limit 1)) AS reporttime, concat(globalusers.firstname, ' ' , globalusers.lastname) as fullname, globalusers.firstname As firstname, globalusers.lastname As lastname, globalusers.employeeid AS employeeid,

    'First Name' AS firtsnamelabel,

    'Last Name' AS lastnamelabel, 'Risk Score' AS riskscorelabel,

    round(globalusers.userrisk/(10*2)) AS severity

    FROM

    trendingriskvalues, globalusers

    WHERE

    trendingriskvalues.userid_id = globalusers.id

    Header

    -

    Template

    CEF:0|Gurucul|GRA|6.1|1|Activities|#severity#| id=203950 cfp1=#userrisk# rt=#reporttime# duser=#fullname# cs1=#firstname# cs2=#lastname# duid=#employeeid# cs1Label=#firtsnamelabel# cs2Label=#lastnamelabel# cfp1Label=#riskscorelabel#

    Footer

    -

    Log Format

    CEF

    Batch Size

    0 (zero)

    Key Column

    trendingriskvalues.id

  3. Save the configuration.

The configuration is now available in the drop-down list on the Data Forwarder Job page.