Report / Search based on network interface
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.
1 Comment
[ + ] Show comment
-
Thanks Chucksteel. Any way you can change it from = to contains Remote Ndis Based Internet Sharing Device? - SVenesky 9 years ago
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
chucksteel
9 years ago
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"
