how do i display anything greater than 0 in this?

illllm

ADSM.ORG Member
Joined
Jan 9, 2018
Messages
153
Reaction score
2
Points
0
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 AND (totbytes_to_replicate/1024/1024 - totbytes_replicated/1024/1024) > '0'
 
Back
Top