From the Gurucul interface, navigate to Configure | Data | Data Export | Data Forwarder Workflow | Configuration (Top right corner) | +Add (Top right corner).
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
Save the configuration.
The configuration is now available in the drop-down list on the Data Forwarder Job page.