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.