Export all attributes of an authentication request from access tracker to a syslog server.
Requirement : We want to export authentication details along with Radius:IETF, Computed and Authorization attributes to the external Syslog server. The default Filter and columns will not allow us to export authentication records with attributes. Solution : We have to construct our custom SQL query to include the fields we need and the attributes that we want to export to external Syslog server. Problem: The attributes are stored in multiple rows for each session id (i.e. for each authentication). To achieve the requirement, we are making use of PostgreSQL array aggregate function i.e. array_agg(). Paste the following SQL query under Custom SQL field. select a.id,a.user_name, a.service_name, a.host_mac, a.timestamp, array_agg(b.attr_name) as attributes, array_agg(b.attr_value) as values from tips_dashboard_summary a inner join tips_session_log_details b on a.id = b.session_id where b.attr_name in ('Radius:Aruba:Aruba-...