clickhouse
SELECT
count(),
sum(bytes) AS TrafBytes,
in_iface,
out_iface,
IPv4NumToString(src_net) AS srcnet,
IPv4NumToString(dst_net) AS dstnet,
dictGetString('ifIndex', 'Description', (IPv4StringToNum('10.99.0.15'), in_iface)) AS ifDescr
FROM sdNetAS_nexthop_iface_dir
WHERE (d = today()) AND (device = IPv4StringToNum('10.99.0.15')) AND ((dst_net >= (IPv4StringToNum('81.100.209.0') AS net2)) AND (dst_net <= ((net2 + pow(2, 32 - 24)) - 1)))
GROUP BY
in_iface,
out_iface,
src_net,
dst_net
select count(dt) as s,dt from bgp_msglog where d = today() and dt >= toDateTime('2019-01-14 11:40:00') and dt <= toDateTime('2019-01-14 12:00:00') group by dt order by s;
SELECT
dt,
IPv4NumToString(src_ip) AS src,
IPv4NumToString(dst_ip) AS dst,
tos
FROM detailed
WHERE (d = (today() - 1)) AND (device = IPv4StringToNum('10.78.0.1')) AND (src_ip = IPv4StringToNum('174.129.28.92')) AND (dt >= toDateTime('2019-04-04 00:00:00')) AND (dt <= toDateTime('2019-04-04 12:00:00'))
LIMIT 1