Configure Business Locations (Site-Based Location Mapping)

Use Location Mapping configuration screen to edit site names and their geographical locations, in order to display business locations properly in the dashboards.

Site-based location mapping determines the business location name of a device (site, office, etc.) based on the Site name of a monitored device as it is displayed in the dashboards.

Before you begin

Before configuring the location mapping, verify the following:

  • Ensure you have one or more devices reporting data to Aternity, by deploying the Agent for End User Devices version 9.x or later on the devices.

  • Verify that the access rights and privileges for your user include Edit Configuration privileges.

  • To use the subnet of a device for mapping, ensure you have Subnet to Site CSV file. Ask your IT team to provide the file with all subnet mask ranges and their respective locations in the Site Name column.

    Get Subnet_To_Site CSV file
  • Existing customers who used the Legacy Location Mapping, ensure to modify your old subnet_to_location.csv file to the new subnet_to_site.csv. All Site Names in both files must be identical. Copy the names from your old file to the new subnet_to_site.csv. You can download the Subnet_to_Site.csv from the new Location Mapping configuration screen and use it as a template.

    Download files and update them
  • To use Active Directory (AD) for mapping, ensure the organization uses Microsoft Active Directory with properly defined Site names. Site names from Active Directory are displayed as Business Location names in Aternity dashboards. As long as the Site field in AD has a value (name), the Business Location name appears in dashboards instead of the Not Mapped value.

    In location mapping, the location's City, State and Country fields come from the Active Directory (AD), if you added this information correctly in the Site's Properties > Location field.

    Location Mapping automatically retrieves the city, state and country fields from Site > Properties > Location
    Tip

    Aternity checks the AD's Site > Properties > Location for information separated by a slash ('/'), with no space before or after the slash, using the format: country/state/city.

    If Aternity recognizes these names, it automatically assigns geolocation coordinates, so it can display the location on a dashboard map.

Procedure

  1. Step 1 Open a browser and sign in to Aternity.
  2. Step 2 Select the Gear Icon > Location Mapping.
    Define location names in Aternity
  3. Step 3 Select a method for site mapping.
    • Use Active Directory: This option determines the location name for Windows physical devices, virtual app server sessions (like Citrix XenApp), and Virtual Desktops as the Site name from your Microsoft Active Directory. Whereas MAC, mobile devices and RDP sessions will use subnets from your organization subnet range. Therefore, you must upload the Subnet to Site file.

    • Use Subnet to Site: This option applies to all devices and all devices will use the Site from the Subnet to Site file. You must upload the Subnet to Site file.

    Download the existing mapping file
  4. Step 4 To map mobile and MAC devices, and remote sessions, or to map all devices using the subnet range, upload the Subnet to Site file.

    Add to the file all subnet ranges and all site names.

    While editing the Subnet to Site file, add a new mapping entry on a new line. In other words, 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

    In the next column, enter the location name as you want it to appear in the dashboards. In Excel, enter the site name in the second column and save as CSV.

    Add a site 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 site.

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

    110.99.1.0/24    Sydney Building
  5. Step 5 Upload Site to Location file to set geographic business location per site.

    This CSV file, typically edited in Excel, contains the site name and other information gathered from the AD from monitored devices in your organization.

    Tip

    Download and use Aternity's existing mapping file as the basis for your edits, to ensure the file format and column names are correct. The file is formatted in Unicode, so you can add non-English characters if needed.

    Example mapping file with locations mapped according to their site names in Microsoft Active Directory
    Note

    If you already defined a site's city, state and country in the AD's Site > Properties window, Aternity automatically adds the values from there.

    Furthermore, if Aternity recognizes those fields, it also automatically assigns geolocation coordinates.

    Field Description
    Site Name

    This column displays the name of the business location exactly as it appears in your Microsoft Active Directory under the Sites folder.

    Important

    Do not edit this field.

    Location

    Enter the name of the location as it should be displayed in the dashboards.

    By default, Aternity automatically adds (and displays) the AD Description field for this site, if it is defined, or alternatively it adds the AD's site name (the name under the Sites folder).

    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.

    The changes take effect once you upload the new files and Agent starts reporting. In case you updated the names, but the Agent was not reporting that day, dashboards will still show the old names. Once Agent reports new data, you will see new names in the Devices Details dashboard.

  6. Step 6 Save the configuration.
    Important

    Customers who previously used the Legacy Location Mapping, please note that clicking Save overwrites all legacy location mapping settings.

    Ensure you save the files in the same format (CSV, Unicode). For example, if you edited the CSV in Microsoft Excel, select Yes to save the file in the same format.

    Note

    We recommend to maintain the same file format for simplicity. Aternity can support UTF-8 and UTF-16 formats, and you can separate the columns as either tab-separated or comma-separated format.

    Aternity does not restrict the file extension, but we recommend maintaining the extension filename.csv for easy editing.

  7. Step 7 (Optional) Update the Subnet to Site file, if necessary (for example, when adding new sites to the account).
    1. a Select Include unmapped values to ensure that the file you are going to download for further editing includes all the subnets reported by devices, including not-mapped subnets.
      Tip

      All unmapped values are included by default in the first download.

    2. b Select Download to download and save the existing Subnet to Site file which Aternity currently uses to assign subnets to site names.
    3. c Open the downloaded csv file in Microsoft Excel or in a plain text editor.
    4. d Update the entries.
    5. e Click in the field Select a file to upload, browse for the subnet_to_site.csv file you edited and upload it into Aternity.

    Once uploaded, the dashboards display new information with this location information.

    The changes take effect once you upload the new files and Agent starts reporting. In case you updated the names, but the Agent was not reporting that day, dashboards will still show the old names. Once Agent reports new data, you will see new names in the Devices Details dashboard.

  8. Step 8 (Optional) Update the Site to Location file, if necessary.
    1. a Download the existing Site to Location file which contains the geographical location for each location name and which Aternity uses to assign geographical locations.
    2. b Open the downloaded csv file in Microsoft Excel or in a plain text editor.
    3. c Update the entries.
    4. d Click in the field Select a file to upload, browse for the site_mapping.csv file you edited and upload it into Aternity.

      Once uploaded, the dashboards display new information with this location information.

      The changes take effect once you upload the new files and Agent starts reporting. In case you updated the names, but the Agent was not reporting that day, dashboards will still show the old names. Once Agent reports new data, you will see new names in the Devices Details dashboard.

      Note

      You may have warnings that there are unmapped sites. You can continue working, but the warnings will show as long as you have sites in the file that are not assigned to any business location. Even if you want to keep it that way, you can avoid having warnings by creating a dummy location for all unmapped sites. It is recommended to download the file and to enter all missing values in all rows and then reload the file to Aternity again.

      There are two types of warnings. In the Site to location area, the warning will show the number of sites without Country, city, state. Whereas, In the Subnet to Site area, the warning will show the number of unmapped subnets. You can include all unmapped values in the downloaded file by selecting the checkbox, so you can then fix the file.

  9. Step 9 Troubleshoot possible errors that might appear after uploading the files.
    • Illegal value: This error appears if a subnet mask is illegal. Make sure to enter the correct number.

    • Duplicates: This error appears due to the duplicated values: the same values of subnet mask in the Subnet to Site file, or the same site names in the Site to Location file. Make sure there are no duplicated names/values in the files.

    • Invalid number of values: This error appears if you did not fill all necessary fields as expected. Make sure to fill all fields in the file.

      Empty fields cause errors while uploading files