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
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
Save the configuration.
The configuration is now available in the drop-down list on the Data Forwarder Job page.