Difference between revisions of "Flow/Reporting"
From Observer GigaFlow Support | VIAVI Solutions Inc.
Kevin Wilkie (Talk | contribs) |
Kevin Wilkie (Talk | contribs) |
||
(3 intermediate revisions by one user not shown) | |||
Line 3: | Line 3: | ||
Available field manipulators | Available field manipulators | ||
− | Fields can be converted by appending the following to the table column name | + | Fields can be converted by appending the following to the table column name |
"__btoip" Converts the bytearray value to textual IP address | "__btoip" Converts the bytearray value to textual IP address | ||
"__ltomac" Converts the long value to the textual MAC address | "__ltomac" Converts the long value to the textual MAC address | ||
Line 11: | Line 11: | ||
"__itofwextcode" Converts the integer value to the textual FW Ext Code Name | "__itofwextcode" Converts the integer value to the textual FW Ext Code Name | ||
"__itofwevent" Converts the integer value to the textual FWEvent 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 |
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