List of Devices in Other

This query will output a list of devices in the Other Folder in NetVoyant. These are devices that have not been correctly classified or are not responding to SNMP.
If a device has not discovered a polling instance yet, it will not show up in this query. It is possible that some non-snmp devices will not show up in this query.

Select distinct group_name, dev_alias, model_name, poll_enable, D.device_id
from devices D, pollinst P, group_instances GI, groups G, device_models m
where D.device_id = P.device_id and D.model_id = m.model_id
and P.pollinst_id = GI.pollinst_id and G.group_id = GI.group_id and G.group_name='Other' and
G.group_id not in (select network_id from networks) order by GI.group_id desc, D.dev_alias;