Hello Everybody,


I would like to run a report or a K1000 search of computers that have a network interface of:

 Remote Ndis Based Internet Sharing Device

So I can find out how many of my users have an air card installed.

Thanks for your help.

Answer Summary:
Cancel
1 Comment   [ + ] Show Comment

Comments

  • Thanks Chucksteel. Any way you can change it from = to contains Remote Ndis Based Internet Sharing Device?
Please log in to comment

Answers

0
This query should work:
SELECT MACHINE.ID, MACHINE.NAME, MACHINE_NICS.NIC 
FROM ORG1.MACHINE
JOIN MACHINE_NICS on MACHINE.ID = MACHINE_NICS.ID
WHERE MACHINE_NICS.NIC = "Remote Ndis Based Internet Sharing Device"

Answered 02/11/2015 by: chucksteel
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity