How to check the Down Status of All Leaf Interfaces in APIC

[AshSe]

I am trying to capture (either in APIC Dashboard or through a command) the down status of all leaf interfaces in APIC. 

I believe it is possible through "moquery" command. Please advice. 

[Marcel Zehnder · Accepted solution]

Do see all interfaces which are down you can use
moquery -c ethpmPhysIf -f 'ethpm.PhysIf.operSt!="up"' | grep dn | sort

Or all interfaces and their state in JSON:
moquery -c ethpmPhysIf -o json | jq '.imdata[] | {dn: .ethpmPhysIf.attributes.dn, operSt: .ethpmPhysIf.attributes.operSt}'

Or all states in a table kind of form
moquery -c ethpmPhysIf -o json | jq -r '.imdata[] | [.ethpmPhysIf.attributes.dn, .ethpmPhysIf.attributes.operSt] | @tsv' | sed 's/\t/ => /g'

Same for all up interfaces
moquery -c ethpmPhysIf -o json | jq -r '.imdata[] | [.ethpmPhysIf.attributes.dn, .ethpmPhysIf.attributes.operSt] | @tsv' | sed 's/\t/ => /g' | grep up

Same for all interfaces which are not up
moquery -c ethpmPhysIf -o json | jq -r '.imdata[] | [.ethpmPhysIf.attributes.dn, .ethpmPhysIf.attributes.operSt] | @tsv' | sed 's/\t/ => /g' | grep -v up

HTH