Fire a trigger, when a device comes online

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?

Thanks.
jesperhpAsked:
Who is Participating?
 
Ernie BeekExpertCommented:
It's not really querying, you set the device up to send syslog to a certain machine/server. From there you can cath the syslogs with something like kiwisyslog: http://www.kiwisyslog.com/kiwi-syslog-server-overview/ (it's got a free version).

The AP's syslog should also log when a device is unregistrered from the wireless network.
0
 
Ernie BeekExpertCommented:
What wifi access point do you have? Perhaps you can use syslog. It should log when a new association is being made.
0
 
Ernie BeekExpertCommented:
That would also include the time of the association (arrival of the employee).
0
On-Demand: Securing Your Wi-Fi for Summer Travel

Traveling this summer?Check out our on-demand webinar to learn about the importance of Wi-Fi security and 3 easy measures you can start taking immediately to protect your private data while using public Wi-Fi. Follow us today to learn more!

 
jesperhpAuthor Commented:
At the moment we are using soho versions of Linksys/Cisco.

I'm not familiar with querying the syslog - is there a standard for querying syslogs?
0
 
jesperhpAuthor Commented:
Also: will the syslog register when a device leaves the network?
0
 
jesperhpAuthor Commented:
Thanks - I will look into the syslog functions.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.