Configure Business Locations with a Device Attribute (Legacy Location Mapping)

The legacy method for location mapping assigns a location from a device attribute, like its subnet, which changes whenever the device connects from a different location. This method requires two separate mappings: first from an attribute (like a subnet) to a location name, then a separate mapping from each location name to its city, state, country, region and coordinates.

Tip

If you set up your Microsoft Active Directory correctly, we recommend using the quicker single-step site-based mapping which uses the Site field in your Active Directory to automatically map locations for you.

Legacy location mapping requires two mappings

Use the legacy (attribute-based) mapping if:

  • Your Microsoft Active Directory does not have a Site for each business location, with properties containing city, state and country.

  • Your devices run a legacy version of the Agent for End User Devices (8.x or older).

  • You use virtual desktops (VDIs), displaying an unknown location.

  • Your monitored mobile apps do not report the Active Directory's site.

Before you begin

Before configuring the legacy location mapping:

  • Decide on the device attribute which determines its location. This attribute must be different in each location, like the department of the device, or its hostname, or another device attribute.

Procedure

  1. Step 1 Open a browser and sign in to Aternity.
  2. Step 2 Create a location mappings file subnet_to_location_mapping.csv, a plain text comma separated file (CSV), in Microsoft Excel or in a plain text editor.

    Add a new mapping entry on a new line. For example, if you are mapping subnet ranges to location names, enter each subnet range on a separate line. One location can contain many subnets, but a subnet can only belong to a single location.

    Tip

    You can obtain a list of subnets for monitored devices (physical only) reporting to Aternity using the Analyze > Device Inventory dashboard. Select Break by > Subnets. Alternatively, contact Aternity SaaS Administration for a CSV file containing the list of subnets which Aternity detected in your organization.

    Enter a range of IP addresses (IP v4 or v6) as a subnet mask, showing the start of the range, then a slash ('/'), then the number of bits in the address which acts as the mask.

    For example, for IP v4 addresses which are 32-bits (4 x 8 bits), specify a subnet mask for the first 24 bits of the address to cover everything except the last (8 bit) number. Hence for a range from 110.1.0.0 to 255, in the file specify the first 24 bits as 110.1.0.0/24.

    Enter a subnet range in a plain text mapping file (csv)

    In Excel, enter the subnet mask format in the first column and save as CSV.

    Enter the subnet ranges in Excel

    In a plain text editor, enter:

    110.99.1.0/24
    252.1.0.0/16
    253.1.0.0/16
    272.1.0.0/16
    110.99.0.0/16
  3. Step 3 In the next column, enter the location name as you want it to appear in the dashboards.

    In Excel, enter the location name in the second column and save as CSV.

    Add a location name to each subnet range

    Alternatively, in a plain text file, add a tab or a comma (,) with no space before or after, and then the name of the location.

    For example, to assign subnet 110.99.1.0 to 255 to a location called Sydney Building, in a plain text editor insert a tab (or comma) then add the location name:

    110.99.1.0/24    Sydney Building
  4. Step 4 Create a new separate file location_mapping.csv which contains the geographical location for each location name.

    The first line or row in the CSV file represents the column headings. Each row associates (maps) a location name to its geographical position.

    In Excel, add the information in its appropriate column.

    Define the geo-location of each location name
    Important

    The header row (first line in the file) must contain these exact headings in this order.

    In a plain text editor, you separate each column with a tab or comma.

    Location	Country	State	City	Location Latitude	Location Longitude	Region
    Brussels Building	Belgium	Brussels	Brussels	50.85	4.348	EMEA
    Beijing Data Center	China	Beijing	Beijing	39.907	116.397	PACRIM
    Helsinki Building	Finland	Uusimaa	Helsinki	60.169	24.935	EMEA

    For each new line, add the following values in its column:

    Field Description
    Location

    The location name to associate with the geographical data in the remaining columns.

    Note

    This value must be identical to a business location you defined for a subnet in the Subnet_to_Location_mapping.csv file earlier in this procedure.

    Country

    (Mandatory if empty) Enter the country name for this site. This information is then used to display data per country in the dashboards.

    Countries and their Latitude and Longitude are listed in the geo_locations.csv file.

    State

    (Mandatory if empty) Enter the name of the state for this site, used for displaying data per state in the dashboards.

    City

    (Mandatory if empty) Enter the name of the city for this site, used for displaying data per city in the dashboards.

    Location Latitude

    (Optional) Enter the latitude coordinate of this site in degrees North, between -90 and 90, for accurate placement on the dashboards' geographic maps. For example 51.377802.

    Tip

    Use an online map to pinpoint a site's coordinates. If your spelling of the Country, State and City is recognized, Aternity automatically adds the city's geolocation coordinates.

    Tip

    Countries and their Latitude and Longitude are listed in the geo_locations.csv file.

    Location Longitude

    (Optional) Enter the longitude in degrees East, between -180 and 180, for accurate placement on the dashboards' geographic maps. For example -71.616.

    Tip

    Use an online map to pinpoint a site's coordinates. If your spelling of the Country, State and City is recognized, Aternity automatically adds its geolocation coordinates.

    Tip

    Countries and their Latitude and Longitude are listed in the geo_locations.csv file.

    Region

    (Optional) Enter a label which groups together locations in the way you see fit. For example, a region can be as broad as APAC or as specific as NW England.

    If you have several company locations at the same address, for example on different floors of the same building, they can appear in the dashboards as different locations so long as they belong to different subnets. However, on a visual map, obviously, they will appear as one overlapping the other.

  5. Step 5 Send the files to Aternity SaaS Administration for uploading to Aternity.

    Once uploaded, the dashboards display new information with this location information. It still displays old data using the previous mappings.