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
  • 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?
Now Available: Firebox Cloud for AWS and FireboxV

Firebox Cloud brings the protection of WatchGuard’s leading Firebox UTM appliances to public cloud environments. It enables organizations to extend their security perimeter to protect business-critical assets in Amazon Web Services (AWS).


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

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Ruckus Zoneflex 7982 multiple SSIDs disconnects 11 83
Two SSIDs serviced and broadcast on different bands within the same AP 2 35
SMB Packet - File Data 4 41
Multi-source agreements are important because they set standards that all manufacturers should follow to ensure that devices are compatible with multiple vendors. The multi-source agreement (MSA) is an agreement that establishes how multiple vendors…
Using in-flight Wi-Fi when you travel? Business travelers beware! In-flight Wi-Fi networks could rip the door right off your digital privacy portal. That’s no joke either, as it might also provide a convenient entrance for bad threat actors.
Viewers will learn how to properly install and use Secure Shell (SSH) to work on projects or homework remotely. Download Secure Shell: Follow basic installation instructions: Open Secure Shell and use "Quick Connect" to enter credentials includi…
After creating this article (, I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

713 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