netcards

Description

This table lists the network adapter cards installed on all Windows Systems (includes Windows 9x).

Fields

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

Example

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%'