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