Security

This community is currently in a read-only state due to a maintenance window. For more info click here
Reply
Highlighted
New Contributor

ClearPass scheduled query exports postgresql database

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


Accepted Solutions
Highlighted
New Contributor

Re: ClearPass scheduled query exports postgresql database

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

View solution in original post


All Replies
Highlighted
New Contributor

Re: ClearPass scheduled query exports postgresql database

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

View solution in original post

Search Airheads
cancel
Showing results for 
Search instead for 
Did you mean: