This post is more than 5 years old

2 Intern

 • 

176 Posts

663

October 6th, 2014 14:00

Canned reports.................

I prefer the command line when it comes to Avamar.....

In one of the environments I support.  The Avamar Console is puppy slow!

Does anyone know how  to run the sql scripts that EMC provides?

example script would be ::--->  ClientrptActBytesProtCli.sql

Thanks..........

Joe Despres

2 Intern

 • 

2K Posts

October 7th, 2014 06:00

You can run the report you mention above by entering the following while logged into the utility node as the admin user:

cat /usr/local/avamar/lib/sql/rptActBytesProtCli.sql | psql -p 5555 mcdb

Some of the other reports have substitution tokens that have to be replaced. You can do the replacement using sed. For example:

cat /usr/local/avamar/lib/sql/rptActDPNSummary.sql | sed s/FROM_TIMESTAMP_TOKEN/`date -d 2012-03-02 +%s`/ | sed s/TO_TIMESTAMP_TOKEN/`date -d 2012-10-08 +%s`/ | psql -p 5555 mcdb

If you do grep "TOKEN" /path/to/ .sql this will show you any tokens that need to be replaced.

21 Posts

October 7th, 2014 03:00

Hi,

To saw that type of information it's better you use the GUI.. In my opinion of course!

cheers

Top