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"
With the start of a new year, it is that time again to support the System Management Community, with that in mind I have made my yearly donation of $250 USD to MyITForum (MIF).
Why do I do it? Well as a past User Group leader for www.OWSUG.ca, I know how much it cost to host a small user group community. OWSUG is small in comparison to MIF! Our network traffic is nothing compared to what the MIF site gets. I’m will to bet that the network traffic to the MIF site in less than 12 hours, is the equivalent of what the www.OWSUG.ca gets in one year! I will also tell you that it cost more that $350 as year (USD) to host the www.OWSUG.ca site. Yes that is about $1 a day for a small user group site! I hate to see what MIF spends each month!
So, have you made a donation to your community yet? http://www.myitforum.com/donations/myITpaypal.asp
R.SystemGroupName != "GARTEK\\Domain Admins"
and R.ResourceId not in ( select
inner join SMS_G_System_ADD_REMOVE_PROGRAMS ARP on ARP.ResourceId = R.ResourceId
ARP.DisplayName = "CCM Framework Tools")