Is it possible to find the MAC adress of a turned off computer somwhere in my LAN?

Is it possible to find the MAC adress of a turned off computer somwhere in
my LAN?

I know i can ping and find the MAC address in my local arp table. But what
if a computer i want the address to is not started and cant respond to
ping etc. and i cant reach it physically. Is there somewhere I can find
this MAC adress? For example in routers or in dns tables or something?
Regards Andreas