Hi @Jarurug ,
You say:
Sorry if my question was not proper. Am trying to find a Moquery to list EPGs which doesn't have any EndPoints associated with it.
Then I'm pretty sure @Marcel Zehnder 's answer has nailed it. And it will help others find the correct answer if you mark it correct.
However, just for fun, I'll give you the same answer using icurl and jq - just because I figured it out and others may find it helpful. And I got a bit carried away, adding a few other options.
Find EPGs with no endpoints
The following will give you a list of the dn (distinguished or unique name) of every EPG in the system and put the list in a file called /tmp/all_epgs
apic#1 bash
T17@apic1:~> icurl -s http://localhost/api/node/class/fvAEPg.json |
jq -r '.imdata[].fvAEPg.attributes.dn' | sort > /tmp/all_epgs
The following icurl command will give you a list of every endpoint in the system in an EPG, including its dn. That dn will begin with the dn of the EPG to which it belongs - something like
uni/tn-Tenant10/ap-2Tier_AP/epg-WebServers_EPG/cep-B4:96:91:89:16:5F
so we use jq to separate out the dns of the EPG and send them to a different file /tmp/epgs_with_endpoints
T17@apic1:~> icurl -s http://localhost/api/node/class/fvCEp.json?'query-target-filter=wcard(fvCEp.dn,"epg-")' |
jq -r '.imdata[].fvCEp.attributes | (.dn|capture("(?<E>.*)/cep-").E)' | sort | uniq > /tmp/epgs_with_endpoints
And finally, you can use either comm or grep to get the difference between the files.
T17@apic1:~> comm -3 /tmp/all_epgs /tmp/epgs_with_endpoints ;# or
T17@apic1:~> grep -vf /tmp/epgs_with_endpoints /tmp/all_epgs
Don't forget to clean up!
T17@apic1:~> rm /tmp/all_epgs ;rm /tmp/epgs_with_endpoints
Find EPGs with no static mappings
The following will give you a list of the dn (distinguished or unique name) of every EPG in the system and put the list in a file called /tmp/all_epgs
apic#1 bash
T17@apic1:~> icurl -s http://localhost/api/node/class/fvAEPg.json |
jq -r '.imdata[].fvAEPg.attributes.dn' | sort > /tmp/all_epgs
The following icurl command will give you a list of static mapping for all EPGs, including its dn. That dn will begin with the dn of the EPG to which it belongs - something like
uni/tn-Tenant10/ap-2Tier_AP/epg-WebServers_EPG/rspathAtt-[topology/pod-1/paths-2201/pathep-[eth1/27]]
so we use jq to separate out the dns of the EPG and send them to a different file /tmp/epgs_with_static_maps
T17@apic1:~> icurl -s http://localhost/api/node/class/fvRsPathAtt.json?\
'query-target-filter=wcard(fvRsPathAtt.dn,"epg-")' |
jq -r '.imdata[].fvRsPathAtt.attributes | (.dn|capture("(?<E>.*)/rspathAtt-").E)' |
sort | uniq > /tmp/epgs_with_static_maps
And finally, you can use either comm or grep to get the difference between the files.
T17@apic1:~> comm -3 /tmp/all_epgs /tmp/epgs_with_static_maps ;# or
T17@apic1:~> grep -vf /tmp/epgs_with_static_maps /tmp/all_epgs
Don't forget to clean up!
T17@apic1:~> rm /tmp/all_epgs ;rm /tmp/epgs_with_static_maps
Find EPGs with no provided or consumed contracts
The following will give you a list of the dn (distinguished or unique name) of every EPG in the system and put the list in a file called /tmp/all_epgs
apic#1 bash
T17@apic1:~> icurl -s http://localhost/api/node/class/fvAEPg.json |
jq -r '.imdata[].fvAEPg.attributes.dn' | sort > /tmp/all_epgs
The following icurl command will give you a list of the dn (distinguished or unique name) of every EPG in the system that either provides or consumes a contract. We use jq to separate out the dns of the EPGs with contracts and send them to a different file /tmp/epgs_with_contracts
T17@apic1:~> icurl -s http://localhost/api/node/class/fvAEPg.json?\
'query-target=subtree&\
target-subtree-class=fvAEPg&\
rsp-subtree=children&\
rsp-subtree-class=fvRsCons,fvRsProv&
rsp-subtree-include=required' |
jq -r '.imdata[].fvAEPg.attributes.dn' | sort | uniq > /tmp/epgs_with_contracts
And finally, you can use either comm or grep to get the difference between the files.
T17@apic1:~> comm -3 /tmp/all_epgs /tmp/epgs_with_contracts ;# or
T17@apic1:~> grep -vf /tmp/epgs_with_contracts /tmp/all_epgs
Don't forget to clean up!
T17@apic1:~> rm /tmp/all_epgs ;rm /tmp/epgs_with_contracts
Find EPGs with no Physical Domain or VMM Domain
The following will give you a list of the dn (distinguished or unique name) of every EPG in the system and put the list in a file called /tmp/all_epgs
apic#1 bash
T17@apic1:~> icurl -s http://localhost/api/node/class/fvAEPg.json |
jq -r '.imdata[].fvAEPg.attributes.dn' | sort > /tmp/all_epgs
The following icurl command will give you a list of domain associations for all EPGs, including its dn. That dn will begin with the dn of the EPG to which it belongs - something like
uni/tn-Tenant10/ap-2Tier_AP/epg-WebServers_EPG/rsdomAtt-[uni/phys-T17:MappedVLANs_PhysDom
so we use jq to separate out the dns of the EPG and send them to a different file /tmp/epgs_with_domain
T17@apic1:~> icurl -s http://localhost/api/node/class/fvRsDomAtt.json?\
'query-target-filter=wcard(fvRsDomAtt.dn,"epg-")' |
jq -r '.imdata[].fvRsDomAtt.attributes | (.dn|capture("(?<E>.*)/rsdomAtt-").E)' |
sort | uniq > /tmp/epgs_with_domain
And finally, you can use either comm or grep to get the difference between the files.
T17@apic1:~> comm -3 /tmp/all_epgs /tmp/epgs_with_domain ;# or
T17@apic1:~> grep -vf /tmp/epgs_with_domain /tmp/all_epgs
Don't forget to clean up!
T17@apic1:~> rm /tmp/all_epgs ;rm /tmp/epgs_with_domain
RedNectar aka Chris Welsh.
Forum Tips: 1. Paste images inline - don't attach. 2. Always mark helpful and correct answers, it helps others find what they need.
