Configure Gurucul Risk Analytics Data Forwarder (JSON 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

    {id:203950,EmployeeId:#employeeid#,Full Name:#fullname#,First Name:#firstname#,Last Name:#lastname#,Userrisk:#userrisk#,Reporttime:#reporttime#,Severity:#severity#}

    Footer

    -

    Log Format

    JSON

    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.