I am trying to compare IP,user field in a log and then compare it with a lookup file(having only IP and username field). What I want to try is to find the firewall logs having same IP with the lookup file but different username. Could you help me? Let's assume the fields as below.
Username in log: assigned_user
IP in the log: assigned_ip
username in lookup file: username