Flow/Reporting

From Observer GigaFlow Support | VIAVI Solutions Inc.
Revision as of 14:15, 14 September 2017 by Kevin Wilkie (Talk | contribs)

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

SQL Reporting Page

Available field manipulators

Fields can be converted by appending the following to the table column name
"__btoip" Converts the bytearray value to textual IP address
"__ltomac" Converts the long value to the textual MAC address
"__itoflags" Converts the integer value to the textual Flags Value
"__ltotime" Converts the long value to the textual Date/Time value
"__itoappid" Converts the integer value to the textual Application Name
"__itofwextcode" Converts the integer value to the textual FW Ext Code Name
"__itofwevent" Converts the integer  value to the textual FWEvent Name

Example showing the device IP instead of the numeric value

select device,device as device__btoip from netflow limit 10
returns: -1407899453	172.21.40.195