Cisco Prime or Cisco ISE keeps a database of devices connected to your network. Prime will allow you to run detailed client reports as per what you require (site location, SSID, etc.).
The devices that are not connected and just dwells past your network will be a challenge, most mobile device (Andriod and iOS) won't give you their real mac addresses until they are authenticated to the wireless SSID.
<<< Please help the community by marking useful posts helpful, or accept as a solution if it resolved your issue >>>