Security

Try this custom SQL query for Syslog Export. A simple output with calling-station-id would include info about the AP. But if you specifically want the Aruba-Location-Id then you will need to use SQL.

SELECT id, session_id, acct_session_id, type, attr_name, attr_value, timestamp FROM tips_radius_accounting_details_log WHERE ((timestamp>= --START-TIME--) AND (timestamp <= --END-TIME--))

Original Message:
Sent: Jan 10, 2025 11:15 AM
From: want to become aruba master
Subject: send from ClearPass to Syslog AccessTracker location ID

Hi community! 

 

I have a question: In ClearPass Access Tracker, the "Location" field displays the name of the AP that the device is connected to. So If I want to output the AP name that the device is connected to using the Location ID information in the Insight logs, will the AP name be displayed  I add the "Radius.AccessPoint" field to the "Select columns" in Insight filter?

Thank you for your response! Through various tests, I was able to successfully obtain the Insight log using Auth.AP-Name instead of radius.Accesspoint.

I will test again using the session log with the SQL query you provided.

Original Message:
Sent: Jan 13, 2025 11:31 PM
From: ProbeRequest
Subject: send from ClearPass to Syslog AccessTracker location ID

Try this custom SQL query for Syslog Export. A simple output with calling-station-id would include info about the AP. But if you specifically want the Aruba-Location-Id then you will need to use SQL.

SELECT id, session_id, acct_session_id, type, attr_name, attr_value, timestamp FROM tips_radius_accounting_details_log WHERE ((timestamp>= --START-TIME--) AND (timestamp <= --END-TIME--))

Original Message:
Sent: Jan 10, 2025 11:15 AM
From: want to become aruba master
Subject: send from ClearPass to Syslog AccessTracker location ID

Hi community! 

 

I have a question: In ClearPass Access Tracker, the "Location" field displays the name of the AP that the device is connected to. So If I want to output the AP name that the device is connected to using the Location ID information in the Insight logs, will the AP name be displayed  I add the "Radius.AccessPoint" field to the "Select columns" in Insight filter?

Here is another source of a SQL query and some more details about it in this blog: https://arubaclearpasstechie.blogspot.com/2017/12/export-all-attributes-from-access.html 

Original Message:
Sent: Jan 10, 2025 11:15 AM
From: want to become aruba master
Subject: send from ClearPass to Syslog AccessTracker location ID

Hi community! 

 

I have a question: In ClearPass Access Tracker, the "Location" field displays the name of the AP that the device is connected to. So If I want to output the AP name that the device is connected to using the Location ID information in the Insight logs, will the AP name be displayed  I add the "Radius.AccessPoint" field to the "Select columns" in Insight filter?