select
SMS_R_System.Name
from
SMS_R_System
inner join SMS_G_System_NETWORK_ADAPTER_CONFIGURATION on SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceId = SMS_R_System.ResourceId
where
SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.DefaultIPGateway = "172.16.100.254"
转载于:https://blog.51cto.com/prain/526661