https://community.extremenetworks.com/t5/extremecloud-iq-site-engine/report-or-flexview-to-find-ports-with-more-than-3-mac-addresses/m-p/20174#M1048 Well, then you could create a custom report for XMC that implements an SQL query against the NAC end-system database. That query could select all unique switchport names (would need to combine the switch IP with the port name) and then count the occurances. That should give you the number of end-systems seen per port. Then filter for those which have a count larger than 3. <BR /> <BR /> Haven't tried to solve this specific use case but with SQL it should be doable.<BR /> <BR /> But this requires some knowledge of the DB and the XML report. <BR /> <BR /> Unfortunately, not as easy as a FlexView... Tue, 10 Apr 2018 19:12:00 GMT Kurt_Semba 2018-04-10T19:12:00Z https://community.extremenetworks.com/t5/extremecloud-iq-site-engine/report-or-flexview-to-find-ports-with-more-than-3-mac-addresses/m-p/20169#M1043 Hello everybody<BR /> <BR /> I'm searching for all switchports with more than 3 MAC addresses. The goal is to find unmanaged switches in my network. I tried to do it with a FlexView, but I couldn't find a matching MIB. Does anybody solved this problem already?<BR /> <BR /> Thank you very much. Yves Tue, 10 Apr 2018 12:46:00 GMT https://community.extremenetworks.com/t5/extremecloud-iq-site-engine/report-or-flexview-to-find-ports-with-more-than-3-mac-addresses/m-p/20169#M1043 Yves_Haslimann 2018-04-10T12:46:00Z https://community.extremenetworks.com/t5/extremecloud-iq-site-engine/report-or-flexview-to-find-ports-with-more-than-3-mac-addresses/m-p/20170#M1044 Good question !<BR /> Because I'm using some export with the CLI "show fdb ..." then using it with Excel sheet then sorting ... analyze ... Tue, 10 Apr 2018 18:50:00 GMT https://community.extremenetworks.com/t5/extremecloud-iq-site-engine/report-or-flexview-to-find-ports-with-more-than-3-mac-addresses/m-p/20170#M1044 Pascal_Lurquin 2018-04-10T18:50:00Z https://community.extremenetworks.com/t5/extremecloud-iq-site-engine/report-or-flexview-to-find-ports-with-more-than-3-mac-addresses/m-p/20171#M1045 Exactly, I'm doing it in the same way. There is also a methode with MAC-Locking (logging only), but I'm more interested in a FlexView or so... Tue, 10 Apr 2018 18:50:00 GMT https://community.extremenetworks.com/t5/extremecloud-iq-site-engine/report-or-flexview-to-find-ports-with-more-than-3-mac-addresses/m-p/20171#M1045 Yves_Haslimann 2018-04-10T18:50:00Z https://community.extremenetworks.com/t5/extremecloud-iq-site-engine/report-or-flexview-to-find-ports-with-more-than-3-mac-addresses/m-p/20172#M1046 Do you have NAC rolled out? Tue, 10 Apr 2018 19:02:00 GMT https://community.extremenetworks.com/t5/extremecloud-iq-site-engine/report-or-flexview-to-find-ports-with-more-than-3-mac-addresses/m-p/20172#M1046 Kurt_Semba 2018-04-10T19:02:00Z https://community.extremenetworks.com/t5/extremecloud-iq-site-engine/report-or-flexview-to-find-ports-with-more-than-3-mac-addresses/m-p/20173#M1047 Hi Kurt, yes I have. Tue, 10 Apr 2018 19:05:00 GMT https://community.extremenetworks.com/t5/extremecloud-iq-site-engine/report-or-flexview-to-find-ports-with-more-than-3-mac-addresses/m-p/20173#M1047 Yves_Haslimann 2018-04-10T19:05:00Z https://community.extremenetworks.com/t5/extremecloud-iq-site-engine/report-or-flexview-to-find-ports-with-more-than-3-mac-addresses/m-p/20174#M1048 Well, then you could create a custom report for XMC that implements an SQL query against the NAC end-system database. That query could select all unique switchport names (would need to combine the switch IP with the port name) and then count the occurances. That should give you the number of end-systems seen per port. Then filter for those which have a count larger than 3. <BR /> <BR /> Haven't tried to solve this specific use case but with SQL it should be doable.<BR /> <BR /> But this requires some knowledge of the DB and the XML report. <BR /> <BR /> Unfortunately, not as easy as a FlexView... Tue, 10 Apr 2018 19:12:00 GMT https://community.extremenetworks.com/t5/extremecloud-iq-site-engine/report-or-flexview-to-find-ports-with-more-than-3-mac-addresses/m-p/20174#M1048 Kurt_Semba 2018-04-10T19:12:00Z https://community.extremenetworks.com/t5/extremecloud-iq-site-engine/report-or-flexview-to-find-ports-with-more-than-3-mac-addresses/m-p/20175#M1049 Thank you for your answer. Since my SQL skills are limited, I will probably go the conventional way. . But if I find time, I'll check this. Thanks. Tue, 10 Apr 2018 19:22:00 GMT https://community.extremenetworks.com/t5/extremecloud-iq-site-engine/report-or-flexview-to-find-ports-with-more-than-3-mac-addresses/m-p/20175#M1049 Yves_Haslimann 2018-04-10T19:22:00Z