How to query the Avamar PostgreSQL database

admin@xxx:~/>: psql -p 5555 -U viewuser mcdb

mcdb=>

Example queries:

SELECT * FROM "public"."v_clients";

SELECT v_clients.cid, v_clients.client_name, v_clients.client_addr,v_clients.os_type FROM "public"."v_clients";

select client_name,status_code,domain FROM v_activities_2 WHERE (status_code=30901 or status_code=30915) and recorded_date_time > current_timestamp - interval '24 hours'