DiscoveredDevice Table

A DiscoveredDevice is a loose record of the discovery of a device on a network, using any of a number of discovery methods. As such, the same device may be found in more than one way (see DuplicateID which may be able to track this fact if known), or by more than one distinguishing feature. Accordingly this table has a somewhat unsatisfactory primary key!

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for DiscoveredDevice table

Database Column

Details

DeviceID

Type: integer. Key. Generated ID

Auto-generated identity number.

DeviceUID

Type: unique identifier. Key

A unique external identifier for the device.

DuplicateID

Type: integer. Key. Nullable

Reference to another discovery record for this device, if known.

ComputerID

Type: integer. Key. Nullable

IT Asset Management

computer id, if known

DeviceName

Type: text (max 64 characters). Key. Nullable

NetBIOS name for computers or any name for other devices, if known.

DNSFullName

Type: text (max 256 characters). Key. Nullable

Fully qualified DNS name, if known.

NTDomainName

Type: text (max 256 characters). Key. Nullable

NT domain name, if known.

IPAddress

Type: text (max 64 characters). Key. Nullable

IP address of the device.

IPSubnet

Type: text (max 64 characters). Nullable

IP subnet that contains the node.

IPSubnetMask

Type: text (max 64 characters). Nullable

IP subnet mask for the subnet contains the device.

PhysicalAddress

Type: text (max 64 characters). Key. Nullable

Network adapter physical address of the node. Can be a MAC address or token ring address.

DeviceRole

Type: integer. Nullable

What role does the device perform?

  • NULL = unknown
  • 0 = Computer (don’t know if server or workstation)
  • 1 = Workstation
  • 2 = Server
  • 3 = Printer
  • 4 = Switch
  • 5 = Router
  • 6 = Hub
OperatingSystem

Type: text (max 128 characters). Nullable

Operating system of the node, if it is a computer.

IsManaged

Type: integer. Key. Nullable

Is the device to be managed by IT Asset Management? 0 = no, 1 = yes, NULL = unknown.

Description

Type: text (max 256 characters). Nullable

Operator-entered description of the device.

SystemDescription

Type: text (max 256 characters). Nullable

This field is currently unused.

SystemLocation

Type: text (max 256 characters). Nullable

This field is currently unused.

SystemContact

Type: text (max 256 characters). Nullable

This field is currently unused.

FirstDiscovered

Type: datetime

The date and time that the node was first discovered.

LastUpdate

Type: datetime

The last time the node was checked or updated.

LastDataSourceName

Type: text (max 128 characters). Key. Nullable

A name that identifies where the discovery information came from (for example: physical location, server, and so on).

LastDataSourceType

Type: text (max 32 characters). Key. Nullable

The type of data source (for example: Excel, Fluke, NM, Text).

OpenPortsTCP

Type: text (max 512 characters). Nullable

The comma-delimited list of TCP ports which were found to be open on scan.

OpenPortsUDP

Type: text (max 512 characters). Nullable

The comma-delimited list of UDP ports which were found to be open on scan.

ScannedOperatingSystem

Type: text (max 512 characters). Nullable

The IP scan tool’s best guess at the operating system. This is based on corner cases in the behavior of the network protocol stack.

ScannedOsType

Type: text (max 512 characters). Nullable

OS Type, as reported by scan tool.

ScannedOsVendor

Type: text (max 512 characters). Nullable

OS Vendor, as reported by scan tool.

ScannedOsFamily

Type: text (max 512 characters). Nullable

OS family, as reported by scan tool.

ScannedOsGen

Type: text (max 512 characters). Nullable

OS Generation (Versions), as reported by scan tool.

ScannedMacAddress

Type: text (max 64 characters). Nullable

MAC Address, as reported by scan tool.

ScannedMacVendor

Type: text (max 512 characters). Nullable

MAC Vendor, as reported by scan tool.

SQLDiscoveredBy

Type: text (max 128 characters). Nullable

The discovery tool used to discover SQL Server.

SQLPorts

Type: text (max 128 characters). Nullable

The ports where SQL Server has been discovered.

IPAddressInt

Type: big integer. Key. Nullable

Integer representation of IPAddress column.