Security

Reply
Contributor I
Posts: 31
Registered: ‎03-19-2015

tipsLogDb

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;
Thanks,
Balazs
Guru Elite
Posts: 8,011
Registered: ‎09-08-2010

Re: tipsLogDb

You can use the appexternal account to connect to the postgres database and run queries/browse the tables. 

Tim Cappalli | Aruba ClearPass TME
@timcappalli | ACMX #367 / ACCX #480 / ACEAP / CWSP
Contributor I
Posts: 31
Registered: ‎03-19-2015

Re: tipsLogDb

Thank you!

Thanks,
Balazs
Search Airheads
Showing results for 
Search instead for 
Did you mean: