Quick NetVoyant Device Query

This query will the total of devices for each device class in NetVoyant.

mysql nms2
select count(*), class_name from devices d join device_classes dc on d.class_id=dc.class_id 

group by class_name;

To show this as only enabled devices, add an additional filter for the poll_enable field.

mysql nms2
select count(*), class_name from devices d join device_classes dc on d.class_id=dc.class_id 

where d.poll_enable=1 group by class_name;