There are likely to be a few better ways to get this information, but I am still at that point where I enjoy writing semi-pointless scripts 
So I simply hope this is helpful to somebody if only as an example for something else...
Anyway - this is what I've got/done - feel free to suggest a better option.
Nb: There are obvious risks/issues - like those assets that don't reply to PING, or if you don't have a asset with a complete ARP table*.
*not that I understand ARP, can ARP scan the network itself, ...
There are likely to be a few better ways to get this information, but I am still at that point where I enjoy writing semi-pointless scripts 
So I simply hope this is helpful to somebody if only as an example for something else...
Anyway - this is what I've got/done - feel free to suggest a better option.
Nb: There are obvious risks/issues - like those assets that don't reply to PING, or if you don't have a asset with a complete ARP table*.
*not that I understand ARP, can ARP scan the network itself, ...

So I simply hope this is helpful to somebody if only as an example for something else...
Anyway - this is what I've got/done - feel free to suggest a better option.
Nb: There are obvious risks/issues - like those assets that don't reply to PING, or if you don't have a asset with a complete ARP table*.
*not that I understand ARP, can ARP scan the network itself, ...