plugin_proval_dns_extradata

Purpose

This table stores the DNS data for a target machine. This data includes the computer ID, interface ID, DNS type, and DNS setting.

Dependencies

• EPM - Network - Script - Create and Populate plugin_proval_dns_extradata

Tables

plugin_proval_dns_extradata

Column	Type	Explanation
ComputerID	Int	The computer ID that returned the DNS setting.
InterfaceID	Varchar	The interface ID where the DNS settings were reported.
DNSType	Varchar	Manual or DHCP DNS setting.
DNSSetting	Varchar	A comma-separated list of the actual settings configured for that computer and interface.

SQL

CREATE TABLE `plugin_proval_dns_extradata` (
    `ComputerID` INT(11) NOT NULL,
    `InterfaceID` VARCHAR(100) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
    `DNSType` VARCHAR(25) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
    `DNSSetting` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
    PRIMARY KEY (`ComputerID`, `InterfaceID`) USING BTREE
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;