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.

You can upgrade from the legacy location mapping to the newer site-based method (learn more).

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 Aternity Agent (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:

  • Verify the access rights and privileges for your user includes Edit Advanced Configuration privileges.

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

Procedure

  1. Step 1 Open a browser and sign in to Aternity.
  2. Step 2 Select the Gear Icon > End Point Attributes > Location.

    Verify that the Data collection method is CSV mapping.

    If the Data collection method is Not Assigned, or to check that the data collection is properly configured, select the Data Collection tab.

    View the location settings
  3. Step 3 Configure the system to use a CSV mapping file, which maps the device's attribute to business location names.
    Select CSV Mapping as your data collection
    Field Description
    Collection Method

    Select CSV Mapping to point the system to a CSV file which maps the attribute of the device to location names.

    Source End Point attribute

    Select the device attribute which you want to map to the location name. For example, select Subnet to map the device's subnet to its location name.

    You could map a different attribute to the location. For example, your devices' hostnames may be dependent on their location, if, say, all the computers in the head office have a hostname beginning with HQ. For more information on mapping other attributes, contact customer services.

    Matching method

    If you are mapping a device's subnet to the location name, select Subnet Range.

    If you are mapping a different device attribute, like a device's hostname, choose Case Insensitive to match the value in the CSV file to the device attribute regardless of upper or lower case.

    For example, if you enter mike-pc in a row in the CSV, a device whose hostname is Mike-PC, with different upper and lower case, would match this rule and apply the location name in that row.

    Missing value replacement

    Enter the text to display in the dashboards when the device's attribute did not match any of the existing business locations. For example, Off-Site or Not Mapped.

    Ignored values

    Enter the subnet addresses which Aternity should ignore (Not Mapped), like home networks of employees. Select and add an ignored subnet. Select to delete your ignored values.

  4. Step 4 Select Apply.
  5. Step 5 Download the existing location mapping file which the system currently uses to assign subnets to location names.

    Select Include unmapped values to ensure that the downloaded file includes all the subnets reported by devices running the Aternity Agent, including those not yet mapped to a location name.

    Select Download Mapping to download and save the existing location mapping csv file.

    Download the current mapping file used by the system to map subnets to location names
  6. Step 6 Open the downloaded 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.

    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
    Tip

    You can edit in Excel if you downloaded this file from version 9.x or later of Aternity. For earlier legacy versions of Aternity, you must use a plain text editor.

  7. Step 7 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
  8. Step 8 Select Upload New Mapping > Browse to upload the edited mapping file to Aternity.
    Upload the mapping file with location names associated with subnet ranges

    You have now completed the first stage of the mapping: from device attribute to location name.

  9. Step 9 To assign geographical data (city, state, country, region and coordinates) to each location name, select the Gear Icon > Settings > Location > Location Mapping.
    Access the configuration of phase two of legacy location mapping
  10. Step 10 Download the system's currently used legacy location mapping file, which maps location names to their physical locations (country, state, city, region, coordinates).

    In the Download Current Mapping section, select Include unmapped values so the file includes all detected location names, including those not yet mapped to a geographic location.

    Then select Download Mapping to save the existing file locally for editing.

    Download the existing location mapping file
  11. Step 11 Open the downloaded 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
    Tip

    You can edit in Excel if you downloaded this file from version 9.x Aternity. But for earlier legacy versions of Aternity, you must edit it in a plain text editor.

    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 which matches exactly the format used in the MaxMind country database. This information is then used to display data per country in the dashboards.

    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, the system automatically adds the city's geolocation coordinates.

    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, the system automatically adds its geolocation coordinates.

    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.

  12. Step 12 Upload your edited location mapping CSV file into Aternity.

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

    Browse for the location mapping csv file you edited and upload it into Aternity. It replaces the previous version of the mapping file.

    Upload the edited mapping file which assigns office names to their geographic locations