* Last 15 minutes
Last Seen Client Association sourcetype="Cisco-WLC" AuthEvent $usrn$ | table _time Username IPAddress ClientMAC APName SSID | head 1 | rename IPAddress as "Client IP Address" ClientMAC as "Client MAC Address" APName as "Associated Access Point" cell
SSID Associations Over Time sourcetype="Cisco-WLC" AuthEvent $usrn$ SSID!="NULL" | timechart dc(ClientMAC) by SSID Total Unique MAC Addresses sourcetype="Cisco-WLC" AuthEvent $usrn$ | dedup ClientMAC | stats count Unique BYOD MAC Addresses sourcetype="Cisco-WLC" AuthEvent (SSID=IVYGuest OR SSID=IVYStudent) $usrn$ | dedup ClientMAC | stats count Unique Student MAC Addresses sourcetype="Cisco-WLC" AuthEvent SSID=IVYStudent $usrn$ | dedup ClientMAC | stats count Unique Guest MAC Addresses sourcetype="Cisco-WLC" AuthEvent SSID=IVYGuest $usrn$ | dedup ClientMAC | stats count Unique Staff MAC Addresses sourcetype="Cisco-WLC" AuthEvent SSID=IVYStaff $usrn$ | dedup ClientMAC | stats count Client Association Events (By Unique IP) sourcetype="Cisco-WLC" AuthEvent $usrn$ | dedup IPAddress | table Username IPAddress ClientMAC APName SSID _time | rename IPAddress as "Client IP Address" ClientMAC as "Client MAC Address" APName as "Associated Access Point"