Customizing Reports
I am looking at the "Client Risk Analisys" report in VBR 6.5.1, and I would like to see the SQL query that is generating this report, or be able to dive into additional customization of this report. In order to give a more accurate picture, I would like to be able to break this down by a number of hours. The current report can only tell me which clients have not been backed up within the past day, but I would like to see this restructured to be the past 36 hours, or something simillar. Also, the report shows the last attempted Full and Incremental backups, I would like to see the report display the Job Error Code for these backups (as this gives me an early indication of what direction to look in investigating the failure.)
Any guidance would be greatly appreciated.
Thanks,
Kevin Good
I tried setting the log level to FINEST, and running the query, I can not find any SQL queries in the log, even when I searched the directory "C:\Program Files\VERITAS\VRTSweb\log" for files containing the word "SELECT"
I also tried restarting the vbr services, and noticed that when I do that, the log level gets reset to INFO
If it makes any difference, VBR is installed to D:\Program Files\Symantec\Veritas Backup Reporter\
rather than the default location.
Upon further digging, it appears that the SQL queries are logged in D:\Program Files\Symantec\Veritas Backup Reporter\Server\Logs
Thanks for the guidance.