On Thu, Mar 21, 2019 at 3:05 PM Ales Musil <amusil@redhat.com> wrote:
One more question. Suppose the problem caused any stale vnic on any vm, previously atached on OVN, is there a way to see at db level? Currently I only have 4 VMs and "network interfaces" in web admin gui doesn't show any OVN, but I would like to crosscheck also at db level, because I think in previous config before doing damages I has some on OVN.
select iface.name, n.name from vm_interface as iface left join vnic_profiles as vnic on iface.vnic_profile_id = vnic.id left join network n on vnic.network_id = n.id where n.provider_network_external_id is not null
A bit longer but should show you the ovn network name that might be attached to the VM.
Hopefully this helps
Output is this name | name ------+------ (0 rows) So I should be in the safe side, I hope. Thanks again for insights! Gianluca