Hi guys,
I need to define a custom source (SQL). Is this possible that I check, what is the custom query's output on the clearpass? For example: what is the output for the following query:
1. SELECT d.attr_value FROM tips_session_log_details d, tips_dashboard_summary s WHERE s.id = d.session_id AND s.user_name = '%{Authentication:Username}' AND s.source = 'RADIUS' AND s.timestamp > now() - interval '5 minutes' and d.attr_name = 'Radius:Cisco:Cisco-AVPair' and d.attr_value like 'audit-session-id%' LIMIT 1;