Query Meta Data

From Observer GigaFlow Support | VIAVI Solutions Inc.
Revision as of 12:06, 14 April 2022 by Kevin Wilkie (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Table Query 

select (cast(meta::json->>'netscalerSmoothedRoundTripTime' as int))::bigint as avalue, count(*) as acount from netflow WHERECLAUSE group by avalue ORDERBY LIMITROW

Graph Query 

select FIRSTSEEN as afirstseen,appid ,avg(cast(meta::json->>'netscalerSmoothedRoundTripTime' as int))::int as aavg from netflow  WHERECLAUSE  and (meta::json->>'netscalerSmoothedRoundTripTime' )is not null group by afirstseen,appid o

  • Report Query

rder by appid,afirstseen

Retrieved from "https://gigaflowsupport.viavisolutions.com/index.php?title=Query_Meta_Data&oldid=1776"