The number of interfaces displayed in the following search does not match the MySQL output below:
mysql> select count(*) from interfacemodel whre destroy_time is NULL;
Release : 10.4
Component : Spectrum Reporting
The reporting.interfacemodel table only supports physical interfaces/ports.
You find additional information in this section of Spectrum guide:
To determine if the port is physical or virtual, check for the attribute Internal_If_Connector_Present - True means physical, and False is virtual.
Any Spectrum model will be in the reporting.model table.
You can search in the reporting.model table.
Where model_class = 15 means port.
The following MySQL query will list all virtual interfaces from the model table. The query will exclude the existing physical interfaces from interfacemodel table:
Excluding the destroyed models (destroy_time is NULL):