Sites File
When call records are captured, they include the caller’s IP subnet but no location context. A sites file maps each subnet to a site name, country, and geographic coordinates, so your dashboards can show which office or location a call originated from.
The sites file applies to all backends — the upload mechanism differs per backend.
CSV Format
Section titled “CSV Format”| Column | Type | Description |
|---|---|---|
subnet | CIDR | Network subnet (e.g. 10.64.0.0/24) |
location | String | Human-readable site name (e.g. Paris) |
country | String | ISO 3166-1 alpha-2 country code (e.g. FR) |
latitude | Number | Latitude, -90 to 90 |
longitude | Number | Longitude, -180 to 180 |
subnet,location,country,latitude,longitude10.64.0.0/24,Paris,FR,48.8588,2.264610.64.1.0/24,Berlin,DE,52.5200,13.405010.64.2.0/24,New York,US,40.7128,-74.0060Download sites.csv template
Upload by Backend
Section titled “Upload by Backend”Upload via the Site File Management panel in the app’s Configuration page.
Required permissions: storage:files:read, storage:files:write, storage:files:delete.
- In Splunk, go to Settings → Lookups → Lookup table files and upload the CSV.
- Define a lookup definition under Settings → Lookups → Lookup definitions pointing to your file.
- Optionally configure an automatic lookup on the
ms_teamsindex:
index=ms_teams| lookup ms_teams_sites subnet AS caller_subnet OUTPUT location, country, latitude, longitude