Our device summary widget shows 65 ports down. I only have 1 port that shows up as down when I I click the 65. I ran a db query and it only shows 1 device as well. Thoughts?
SELECT COUNT(*) FROM ports AS I, devices AS D WHERE I.deleted = ‘0’ AND D.device_id = I.device_id AND I.ignore = ‘0’ AND D.ignore = ‘0’ AND I.ifOperStatus = ‘down’ AND I.ifAdminStatus = ‘up’
Shows 1
SELECT * FROM ports AS I, devices AS D WHERE I.deleted = ‘0’ AND D.device_id = I.device_id AND I.ignore = ‘0’ AND D.ignore = ‘0’ AND I.ifOperStatus = ‘down’ AND I.ifAdminStatus = ‘up’
Lists only 1