Difference between revisions of "Flow/Reporting"
From Observer GigaFlow Support | VIAVI Solutions Inc.
Kevin Wilkie (Talk | contribs) |
Kevin Wilkie (Talk | contribs) |
||
(One intermediate revision by one user not shown) | |||
Line 12: | Line 12: | ||
"__itofwevent" Converts the integer value to the textual FWEvent Name | "__itofwevent" Converts the integer value to the textual FWEvent Name | ||
− | Example | + | Example showing the device IP instead of the numeric value |
− | select device as device__btoip | + | select device,device as device__btoip from netflow limit 10 |
+ | returns: -1407899453 172.21.40.195 |
Latest revision as of 14:15, 14 September 2017
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