Hi
Trying to get an export of syslog with sql querrie, but i cannot seem to find the schema of clearpass database så i can write the querry?
Kinda like this:
SELECT authlog.timestamp, authlog.username, authlog.nas_ip_address, authlog.nas_port_id, authlog.service, authlog.authentication_method, authlog.eap_type, authlog.cert_common_name, authlog.cert_serial_number, authlog.cert_issuer, authlog.cert_valid_from, authlog.cert_valid_to, authlog.cert_revocation_status, authlog.cert_subject_ou, authlog.cert_subject_country, authlog.ocsp_status, authlog.ocsp_error_details, authlog.result, authlog.failure_reason, sessionlog.session_id, sessionlog.client_ip, sessionlog.client_mac, sessionlog.start_time, sessionlog.end_time, sessionlog.duration, tacacslog.device_ip, tacacslog.command, tacacslog.privilege_level, tacacslog.response, tacacslog.result FROM authlog LEFT JOIN sessionlog ON authlog.session_id = sessionlog.session_id LEFT JOIN tacacslog ON authlog.session_id = tacacslog.session_id WHERE authlog.service IN ('RADIUS', 'TACACS+');
but cannot find the correct schema to make the export querry validate.