I want to check if the user is detected in other areas based on IP.
Detection criteria are pre-written scenarios.
In this scenario, we inserted numbers such as rule_1 and rule_2.
The purpose of this task is to see that a user who should be in a specified location is detected in a scenario in another location.
This is my log table
country | title | Area | detail | userlist | ip |
USA | WA |
Washington |
Washington Monument | user1 | 192.168.0.100 |
USA | WA |
Washington |
Washington Monument | user2 | 192.168.0.101 |
USA | VA | Virginia | user3 | 192.168.0.102 | |
USA | NJ | New Jersey | user4 | 192.168.0.103 |
i want view