Active Devices via clish

[Ave_Joe]

Good day.

Is there an equivalent embedded GAIA clish command to display Active Devices as seen in the GAIA portal?  See below.

If not, what would be the best way to grab this information from the appliance without having to use a web browser?

[PhoneBoy]

"arp" is probably the closest thing.

[Ave_Joe]

Thanks.  I think we landed on just using the info in /var/dhcp.leases.XX file for this.  No real sure what the GAIA webui is doing on the Active Devices screen but it's inline with what is in the dhcp.leases file.

We did find nmap in the /pfrm2.0/bin/ directory.   After investigating using nmap it was decided that cat'ing the dhcp.leases.XX was a much simpler solution.

[PhoneBoy]

On the appliance I'm looking on, I'm not using DHCP because the appliance is running in bridge mode.
arp can also be run without going to expert mode 🙂

[nmelay · Accepted solution]

Detected devices are conveniently stored in a SQLite database.

You can get the list using the following command in expert mode:

sqlite3 -column /flash/devices.db 'select name,ipAddr,macAddr,deviceOS,typeName,brand,model,ifName from devicesDb;'

[shay1]

how can i add a field that will show me the interface ? i want to recognize all wireless active devices via cli

[Olga_SMB]

Hi Shay,
you can run in expert mode: hosts -f 
grep the result according to interface name you are looking for.

[shay1]

the command does not work on smb device - 1570 

i tries in clish and in expert

[nmelay2]

Shay,

The field for the firewall interface name is ifName; see the last column in the output from my command.
You can see all the available columns with :

sqlite3 -column -header /flash/devices.db 'select * from devicesDb;'

Also, with firmware R81.10.15, the database is now located in /flash/devices.db_persistent.