Query Meta Data

From Observer GigaFlow Support | VIAVI Solutions Inc.
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 order by appid,afirstseen

  • Report Query

As the name of the met field extracted you can use 

svalue returns Value
scount returns Count
acount returns Count
avalue returns Value
aavg returns Average
atotal returns Total
amin returns Min
apct returns %
amax returns Max