Last Seen Client Associationsourcetype="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 Timesourcetype="Cisco-WLC" AuthEvent $usrn$ SSID!="NULL" | timechart dc(ClientMAC) by SSIDTotal Unique MAC Addressessourcetype="Cisco-WLC" AuthEvent $usrn$ | dedup ClientMAC | stats countUnique BYOD MAC Addressessourcetype="Cisco-WLC" AuthEvent (SSID=IVYGuest OR SSID=IVYStudent) $usrn$ | dedup ClientMAC | stats countUnique Student MAC Addressessourcetype="Cisco-WLC" AuthEvent SSID=IVYStudent $usrn$ | dedup ClientMAC | stats countUnique Guest MAC Addressessourcetype="Cisco-WLC" AuthEvent SSID=IVYGuest $usrn$ | dedup ClientMAC | stats countUnique Staff MAC Addressessourcetype="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"