So what does the asterisk mean in the DHCP leases hostname?
In a word - duplicate.
The reason that asterisks show up is because that only one lease can own a name. When the next device takes a lease claiming to be the same hostname it steals the name from the first, and the first gets a *
This makes sense to me when I have a laptop that has an Ethernet port and Wi-Fi. Both of those will use the same hostname. I keep my Wi-Fi on a separate sub-net from the wired, so I don't have to fool around with trying to force the same IP address; yet I can still use DHCP reservations.
But I am getting stars all over the place in the hosts table???
Well, it turns out there is this:
From: https://android.stackexchange.com/a/217171
All up-to-date Android devices are going to have the identical hostname of '<null>'. To me, this seems like a great way to screw up the integrity of a database.
So it seems the best thing for me to keep a little sanity is to add a hostname at the lowest level, (dnsmasq) with the dhcp-host option for those devices that I own and are 'shooting blanks'.
YMMV
In a word - duplicate.
The reason that asterisks show up is because that only one lease can own a name. When the next device takes a lease claiming to be the same hostname it steals the name from the first, and the first gets a *
This makes sense to me when I have a laptop that has an Ethernet port and Wi-Fi. Both of those will use the same hostname. I keep my Wi-Fi on a separate sub-net from the wired, so I don't have to fool around with trying to force the same IP address; yet I can still use DHCP reservations.

Well, it turns out there is this:
Since Android 8 - when android_id became unique to apps - net.hostname is no more set, so a null is sent in DHCPREQUEST. See Android 8 Privacy Changes and Security Enhancements:
net.hostname is now empty and the dhcp client no longer sends a hostname
So the WiFi routers show no host names for Android 8+, neither we can set / unset / change it.
net.hostname is now empty and the dhcp client no longer sends a hostname
So the WiFi routers show no host names for Android 8+, neither we can set / unset / change it.
All up-to-date Android devices are going to have the identical hostname of '<null>'. To me, this seems like a great way to screw up the integrity of a database.

So it seems the best thing for me to keep a little sanity is to add a hostname at the lowest level, (dnsmasq) with the dhcp-host option for those devices that I own and are 'shooting blanks'.
YMMV
Comment