List routers that ConfigMgr / SMS knows about

Published Saturday, September 06, 2008 1:08 PM

Select
RASIP.IP_addresses0,
RASR.System_roles0
from
dbo.v_RA_System_IPAddresses RASIP,
dbo.v_RA_System_SystemRoles RASR
where
RASR.ResourceID = RASIP.ResourceID
and RASR.System_Roles0 = 'Router'