This table lists the network adapter cards installed on all Windows Systems (includes Windows 9x).
Field name |
Data type |
Description |
id_snapshot |
number |
snapshot auto-number |
server_name |
string |
Netbios name of the server without the 2 backslashes. |
manufacturer |
string |
Manufacturer of the card. |
title |
string |
String describing logically the network adapter. |
driver |
string |
Internal name of the driver. |
usedhcp |
boolean |
True if the IP address of this server is allocated by DHCP. |
ips |
string |
List of the IP addresses associated with this server. |
MacAddress |
string |
MAC address of the network adapter |
gateways |
string |
List of the gateways used by this workstation. |
wins1 |
string |
Primary WINS server address. |
wins2 |
string |
Secondary WINS server address. |
PnpInstanceID |
string |
Link to the devices table field PnpInstanceID |
NetConnection |
string |
Name of the network connection for this adapter |
dns1 |
string |
IP address of the first DNS server |
dns2 |
string |
IP address of the second DNS server |
dns_suffix |
string |
DNS suffix |
DhcpServer |
string |
IP address of the DHCP server |
LeaseTerminatesTime |
datetime |
Expiration date of the DHCP lease |
LeaseObtainedTime |
datetime |
Start date of the DHCP lease |
As an example, to list all the servers with a Token Ring network adapter made by Olicom, use the following SQL query:
SELECT DISTINCT server_name
FROM netcards
WHERE
UPPER(manufacturer) = 'OLICOM' AND
title LIKE '%Token%'