This is the query I ran,
select SUBSTR(node_name,1,15) as NODENAME,date(start_time) as date,fsid,totfiles_to_replicate as files_total,totfiles_replicated as files_replicated,totbytes_to_replicate/1024/1024 as MB_to_replicate,totbytes_replicated/1024/1024 as MB_replicated,(totbytes_to_replicate/1024/1024 - totbytes_replicated/1024/1024) as MB_backlog from replicationview where date(start_time) >= current_date - 1 days
Its output is 4 pages long. How do i add a filter to show only anything under MB_Backlog that is greater than 0?
select SUBSTR(node_name,1,15) as NODENAME,date(start_time) as date,fsid,totfiles_to_replicate as files_total,totfiles_replicated as files_replicated,totbytes_to_replicate/1024/1024 as MB_to_replicate,totbytes_replicated/1024/1024 as MB_replicated,(totbytes_to_replicate/1024/1024 - totbytes_replicated/1024/1024) as MB_backlog from replicationview where date(start_time) >= current_date - 1 days
Its output is 4 pages long. How do i add a filter to show only anything under MB_Backlog that is greater than 0?