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’