admin@xxx:~/>: psql -p 5555 -U viewuser 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'

When running pre/post scripts, it is possible that you are getting the following error message:

2017-03-20 19:43:43 avtar Info <5916>: Executing run-at-start '/usr/local/avamar/etc/scripts/'
2017-03-20 19:43:43 avtar Info <6033>: Begin STDERR from run-at-start:
avspawn::spawn after execve errno:8 code 8: Exec format error


In order to resolve that, ensure that you specified the interpreter as first line.
So it should start with, for example:



Who is Online

We have 255 guests and no members online