Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
maxLevel2
minLevel2
typeflat
Note

Deprecated operation

This operation is deprecated and its use is not recommended. If you need to use it, use Geolocated AS Organization Name with MaxMind GeoIP2 (mm2asorg) instead.

Description

Geolocates an IP address and returns its corresponding AS (autonomous system) owner name.

How does it work in the search window?

...

The data type of the new column is string.

Example

We want to get the AS owner names of the IP addresses in our clientIpAddress column, so we click Create column and select the Geolocated AS owner operation. Select clientIpAddress as the argument and assign a name to the new column - let's call it AS_owner.

...

Use the operator select... as...  and add the operation syntax to create the new column. The syntax is as follows:

  • mmasowner(ip)

Example

Copy the following LINQ script and try the above example on the demo.ecommerce.data table. 

Code Block
from demo.ecommerce.data
select mmasowner(clientIpAddress) as AS_owner