Forums on Intune, SCCM, and Windows 11

Welcome to the forums. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your topics and posts, as well as connect with other members through your own private inbox!

PENDING Query to only show devices with multiple ip addresses

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.

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
 
Not sure if ConfigMgr is the best tool to use this. Third-party tools can get this job done more quickly and efficiently.
 

Forum statistics

Threads
7,026
Messages
27,491
Members
17,677
Latest member
Nairolf

Trending content

Back
Top