List routers that ConfigMgr / SMS knows about

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’

Leave a Reply

Your email address will not be published. Required fields are marked *