--- title: "Configure Gurucul Risk Analytics Data Forwarder (JSON logs)" slug: "configure-gurucul-risk-analytics-data-forwarder-json-logs" tags: ["ESM", "Reference"] updated: 2026-10-27T15:50:33Z published: 2026-10-27T15:50:33Z canonical: "docs.trellix.com/configure-gurucul-risk-analytics-data-forwarder-json-logs" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.trellix.com/llms.txt > Use this file to discover all available pages before exploring further. # Configure Gurucul Risk Analytics Data Forwarder (JSON logs) 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. :