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"