On Thu, Mar 21, 2019 at 3:05 PM Ales Musil <[email protected]> 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
_______________________________________________
Users mailing list -- [email protected]
To unsubscribe send an email to [email protected]
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct: 
https://www.ovirt.org/community/about/community-guidelines/
List Archives: 
https://lists.ovirt.org/archives/list/[email protected]/message/VGOZTDKXNT5QGETQOV5LTQJOF6CWVCDH/

Reply via email to