In WUP2005 I created
a Microsoft Access interface that I could generate a report showing any device
where the ip address is equal to the hostname. This I could then pass onto our
tech group so that they could put in the actual device name. In WUP2006 I am
trying to do this within a dynamic group. I tried this ...
SELECT DISTINCT
NetworkInterface.nDeviceID
FROM NetworkInterface
WHERE NetworkInterface.sNetworkAddress=[snetworkname]
FROM NetworkInterface
WHERE NetworkInterface.sNetworkAddress=[snetworkname]
....but neither of
the variables is the hostname. When looking through the documentation the
only reference to the hostname is in the activediscoverytable. The devices I am
working with were added and not through active discovery.
Any help would be
greatly appreciated.
