CLI command for finding all iPhone MAC addresses

alc
Retired Employee

Question

We're in the process of testing DHCP server on Windows 2012 and we'd like to start using policies to give lower lease time to mobile devices.  I figured that since we are now running 6.1 and we have device profiling/fingerprinting setup, I should be able to pull a list from our airwave database by device type and give me a list of MAC addresses.  Once I get this, I can then summarize and get a list of the OUIs and give me a good idea of Apple IOS MACs (since they don't give them out).

 

Anyone know which cli command I would run to get this, something like

 

select device_type, mac_address from ? where device_type like '%iphone%' or device_type like '%iPad' or device_type like '%ipod%'

Answer

This command from the cli would probably give you what you're looking for:

 

# dbcsv "select device_type, mac from client_first_last where device_type like '%iP%'"

 

If you still want to see all of the tables in the database, you can log into the database console with the "db" command and do "\dt" to see a list of tables, or "\d <table_name>" to see a table's schema. "\q" would get you back to a bash prompt.

Version history
Revision #:
1 of 1
Last update:
‎07-10-2013 04:37 PM
Updated by:
alc
 
Labels (2)
Contributors
Search Airheads
cancel
Showing results for 
Search instead for 
Did you mean: