SOLVED SCCM Query - Show WIFI Devices Connected

[David Wilkinson]

Hi there,

I have been asked by our network department for a list of devices that are connected to our internal wireless network, is there a query that I can run that will show devices that are running off WIFI and not via Network cable?

I tried the following Query but it shows nearly 400 devices and I wasn't sure it was as high as that.

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_NETWORK_ADAPTER on SMS_G_System_NETWORK_ADAPTER.ResourceID = SMS_R_System.ResourceId where SMS_G_System_NETWORK_ADAPTER.Description like "Wireless"

Let me know your thoughts.

Thanks,
David

 

[Garth]

No there reliable way to do this in CM. At best you can look for the IP range, but it will not answer the question if a computer is connected to wifi and also not connected to network cable.

 

[Prajwal Desai]

SMS_R_System.ResourceId where SMS_G_System_NETWORK_ADAPTER.Description like "Wireless"

Try SMS_G_System_NETWORK_ADAPTER.Description like "%Wireless%"

 

[Garth]

Keep in mind that will not guarantee that you will find all wireless devices. But it is a great start to get most devices.