This might NOT list all routers in your environment, and it will has lots of false positives too.

Of the 7 device marked as a router, only 3 are right, the remaining 4 are false positives.

In my test lab it found 3 out of 7, Routers /Switches.

Plus it lists

·        1 WS, that is not acting like routers. (I doubled checked)

·        1 Server was listed twice and it is not acting like a router. No unless you consider a WSUS server a router.

·        1 Network UPS???? And that is clearly not a router. And it did not detect the other network UPS.

Anyways have fun with it.

select SMS_R_System.* from  SMS_R_System where SMS_R_System.SystemRoles = "Router"