Im working on a project, where I will need to be able to fire a trigger (either from within a SQL database or via a program) that will be trigged, when a device is connecting to our network.
Eg; when an employee approches the office, his phone will aquire an IP address from the WiFi network. At the same time (or almost) a program or trigger will match the phones MAC address with our listed MAC addresses, and add an entry to a table showing that the employee has arrived to the office.
My first idea was to query the DHCP server for leases to that given MAC address, but its not good enough due to the lease time.
Then I thought of a network scan to scan if the MAC address is available.
But im not exactly sure whats the best approch, and would very much like to hear if any body has any experience in this?