[Users] Reports

Ryan Kruse rkruse at alterpoint.com
Wed Jun 11 09:46:02 CDT 2008


You would have to modify the BIRT report definition file ~/ZipTie Server/reports/ziptie.reports.inventory/backupFailure.rptdesign.

You can see there is a SQL query that specifically looks for status that isn't 'SUCCESS'.  So if you remove that "AND D.BACKUP_STATUS != 'SUCCESS'" line you should get details for every status of backup.  You may need to restart your server for the report to reload.

SELECT D.HOSTNAME, D.IP_ADDRESS, D.VENDOR_SW, D.BACKUP_STATUS, D.BACKUP_MESSAGE, D.LAST_BACKUP
 FROM DEVICE D, BIRT_RESOLVED_DEVICES
 WHERE D.BACKUP_STATUS IS NOT NULL
 AND D.BACKUP_STATUS != 'SUCCESS'
 AND D.DEVICE_ID = BIRT_RESOLVED_DEVICES.DEVICE_ID
 AND BIRT_RESOLVED_DEVICES.EXECUTION_ID = ?
 ORDER BY D.IP_ADDRESS


________________________________________
From: users-bounces at ziptie.org [users-bounces at ziptie.org] On Behalf Of Sebas Tian [stiansts at yahoo.com.ar]
Sent: Wednesday, June 11, 2008 8:13 AM
To: ZipTie Users
Subject: [Users] Reports

Is it possible using the Backup Failure Report detail all the hosts that were backed up successfully?

Regards,


________________________________

¡Buscá desde tu celular! Yahoo! oneSEARCH ahora está en Claro
http://ar.mobile.yahoo.com/onesearch



More information about the Users mailing list