Siemens SiPass Modeling Rule

Modeling Rule

Siemens SiPass

Details

IDSiemens_SiPass_ModelingRule
From Version8.4.0

Schema

siemens_sipass_raw

Field Type Array?
_raw_log string
[MODEL: dataset ="siemens_sipass_raw"]
alter log_array = split(_raw_log,"    ")
| alter id_num = split(arrayindex(log_array,0)," ")
| alter
    xdm.event.id = ltrim(arrayindex(id_num,1)," "),
    xdm.target.host.hostname = arrayindex(log_array,1),
    xdm.source.host.device_id = to_string(arrayindex(log_array,3)),
    xdm.source.host.device_model = arrayindex(log_array,5),
    xdm.event.description = arrayindex(log_array,11),
    xdm.source.user.last_name = arrayindex(log_array,13),
    xdm.source.user.first_name = arrayindex(log_array,14),
    xdm.source.user.badge_id = arrayindex(log_array,16),
    xdm.source.zone = to_string(arrayindex(log_array,32)),
    xdm.database.name = to_string(arrayindex(log_array,37)),
    xdm.source.user.employee_id = to_string(arrayindex(log_array,43));