Unfortunately there is still no label or metric which shows the "link state" of an interface,
However I found out that the label "speed" does not exist or is empty if the "link state" is down. This allows me to check if the interfaces metric for admin state is "up" and "speed" is empy to identify the interface is down.
This does not work for the MHO interfaces.
### metric value == 1 if interface admin state up / enabled
### if value of label "speed" does not have any value
### the interface is admin up, link state down.
### I do not care avout the "lo" interface and exclude it
(system_network_interface_state{host_name!~".*mho.*", name!~"lo", speed!~".+"} == 1)