Fire a trigger, when a device comes online

Posted on 2010-11-17
Last Modified: 2012-05-10
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?

Question by:jesperhp
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 35

Expert Comment

by:Ernie Beek
ID: 34154271
What wifi access point do you have? Perhaps you can use syslog. It should log when a new association is being made.
LVL 35

Expert Comment

by:Ernie Beek
ID: 34154277
That would also include the time of the association (arrival of the employee).

Author Comment

ID: 34154304
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?
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.


Author Comment

ID: 34154312
Also: will the syslog register when a device leaves the network?
LVL 35

Accepted Solution

Ernie Beek earned 250 total points
ID: 34154356
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: (it's got a free version).

The AP's syslog should also log when a device is unregistrered from the wireless network.

Author Comment

ID: 34154836
Thanks - I will look into the syslog functions.

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For Sennheiser, comfort, quality and security are high priority areas. This paper addresses the security of Bluetooth technology and the supplementary security that Sennheiser’s Contact Center and Office (CC&O) headsets provide.  
This paper addresses the security of Sennheiser DECT Contact Center and Office (CC&O) headsets. It describes the DECT security chain comprised of “Pairing”, “Per Call Authentication” and “Encryption”, which are all part of the standard DECT protocol.
Viewers will learn how to connect to a wireless network using the network security key. They will also learn how to access the IP address and DNS server for connections that must be done manually. After setting up a router, find the network security…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question