Open topic with navigation

Geolocation Lookup

Geographical Information System (GIS) lookup allows the user to search for a particular event based on its geo-location. Thanks to public IPS in source address column, Logger can track an event using GIS lookup.

Creating a GIS lookup connection

1. Load the required data used for MaxMind/Lookup on Logger or use any table from MySQL DB. For further details, see Import Geolocation Files

2. Confirm the MaxMind connection is enabled.

3. Create a Logger search query having MaxMind data.

4. In Design > Queries, select the appropriate connection. MySQLReportDB option allows you to create the query, while LoggerSearchQueryselects an existent one.
5. Click Design >Category and select the logger search query or table from MySQL.
6. Drag the GIS lookup to the diagram (between DataSource and Format step).
7. Select the lookup field.
8. Name the parameter as ip.

9. Type the field name and select a value from the list. As you type a word in the value field, the options will auto-populate or appear listed below.

10. Type [/] on the request path field and then click get patterns to display a new window in which you can select the additional columns that will appear in the results page.

11. Click get patterns to search for all possible record patterns. Choose a specific field from the list to perform a search.

12. Click Result > Check and confirm all newly added columns have been added.

13. From the Format tab, check the Geographical Role that corresponds to the newly created fields.

14. Save the query object.

15. Create a map using a saved query object. For additional information, see Map.

Specifying the Geographical role.

From the format icon, modify the following property value fields for this process:

• Caption: Name the fields list during the report design stage.
• Hyperlink: Add a link for a web page or cross-reference another report.
• Group Label: To create a new group, type the name as appropriate. Otherwise, select an existing group from the list.
• Hidden: To hide this field during the reporting process, check the corresponding box.
• Geographic Role: Select the corresponding geographical roles that are automatically populated:
  • Continent
  • Country
    
  • State
    
  • County
    
  • City
    
  • Latitude
    
  • Longitude
• GIS Format: Pick between signed degrees format, degrees minutes, and degrees only. This applies for both geographic role: latitude and longitude.
• Width: Define the report width from a range of 1 to 100.
• Output format: The format string is used to configure Date and Number. To select the format string at run time, select Apply Locale Default in the selector dialog.
• Input format: This format string decides the prompting format for the field value in Ad hoc Filter screen. This is useful when prompting date values in a desired format or to input IP Address format for number values.
• Align: Choose between left, right, center to align the values on the report.
• User Time Zone: Specify the appropriate time zone.
• Render As: If the string field references to an image path, select render as image.
• Width: Define the image width.
• Height: Define the image height.
• Source Type: Pick between image path or URL.