Unsolved
5 Posts
0
512
Avamar add Canned SQL reports
Hello there
I'm wondering how can we add custom reports from the folder/usr/local/avamar/lib/sql/ to the console
for example, I have just copied with other name and modified a file /rptCliUnprotected.sql to have all the clients from the MC_RETIRED domain, nothing complicated, just deleted the "not" on the last line:
and full_domain_name not like '%MC_RETIRED%'
from the MCCLI I can get the report just doing this
cat /usr/local/avamar/lib/sql/rptCliUnprotected2.sql |sed s/FROM_TIMESTAMP_TOKEN/`date -d 2020-01-01 +%s`/ | sed s/TO_TIMESTAMP_TOKEN/`date -d 2020-03-09 +%s`/ |psql -p 5555 mcdb -U admin
Is there a way to add this "new report" to the GUI?
ionthegeek
2K Posts
0
March 10th, 2020 11:00
The .sql files are for reference and for use with command line tools. The actual reports that can be run through the GUI are embedded in the Avamar Administrator Server software. I'm not aware of any way to add custom SQL reports to the GUI in this way.
The best way to run custom queries and reports is to probably to connect your tool of choice to mcdb using the viewuser account as described in the Reports Guide:
https://support.emc.com/docu93974_Avamar_19_Reports_Guide.pdf?language=en_US