The system.backups table was designed to talk to an FTPD server to get the information it needs for reporting. Therefore, you must specify the FTPD as part of the query or zero rows will be returned.
You must specify a
WHERE SOURCE = <ftpd_server> in the query in order to get the desired statistics. Here is an example:
select * from system.backups where source = 'ftp://ftp:XXXXXX@10.99.138.238';
More information on ClustrixDB Fast Backup and Restore can be found in documentation here: ClustrixDB Fast Backup and Restore