On Thu, Mar 21, 2019 at 3:05 PM Ales Musil <amusil(a)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