Security

last person joined: yesterday 

Forum to discuss Enterprise security using HPE Aruba Networking NAC solutions (ClearPass), Introspect, VIA, 360 Security Exchange, Extensions, and Policy Enforcement Firewall (PEF).
Back to discussions
Expand all | Collapse all

ClearPass scheduled query exports postgresql database

This thread has been viewed 1 times

  • 1.  ClearPass scheduled query exports postgresql database

    Posted Dec 04, 2018 11:28 AM

    So pgAdmin in windows works fine for one-off query runs against the database with appexternal but we are in need of a scheduled task. Can this even be done? I've looked into pgAgent until I releaized the database doesnt have the req feat-set. Not sure if a cronjob is even possible with appadmin cli.

     

    Here is the info I am trying to export automatically

     

    SELECT mac, mac_vendor,ip, ap, ssid, hostname, username, device_category, device_family, device_name, status, added_at, updated_at, error_code, auth_status, roles, session_start_at, session_end_at
    FROM public.endpoints
    WHERE session_end_at IS null and session_start_at IS NOT null
    ORDER BY session_start_at DESC



  • 2.  RE: ClearPass scheduled query exports postgresql database
    Best Answer

    Posted Dec 04, 2018 05:25 PM

    Never mind, found out you can us obdc in windows. all good