ubergeekking
New Member
- Messages
- 1
- Reaction score
- 0
- Points
- 1
Could anyone offer some guidance on creating a query to list devices with multiple ip addresses (from multiple nics or nic+wifi?)
edit: Here is what I am starting with. Im trying to show only duplicate Hostnames.
edit: Here is what I am starting with. Im trying to show only duplicate Hostnames.
Code:
select SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress, 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.IPAddress > SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.DefaultIPGateway order by SMS_R_System.Name DESC