Avamar: Query postgresql db

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

mcdb=>

 

Example query:

    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’

Share your love