CREATE TABLE [dbo].[wtContinuousDiscoveryAgent]
(
[uuid] [binary] (16) NOT NULL,
[containerhost] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[pollset_name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[get_auth_name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[set_auth_name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[port_number] [int] NULL,
[dsm_obj_name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Version] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ManagedSubNets] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SubNetToManage] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AgentManager] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[agt_ipaddress] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[agt_subnetMask] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[agt_gateway] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[agt_hostname] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CL_THREADPOOL_MAX_THREAD] [int] NULL,
[DHCP_ENABLE] [tinyint] NULL,
[DHCP_POLL_INTERVAL] [int] NULL,
[DHCP_DEBUG_FLAG] [int] NULL,
[ICMP_ENABLED] [tinyint] NULL,
[SNMP_ENABLED] [tinyint] NULL,
[ICMPTIMEOUT] [int] NULL,
[ICMPRETRY] [int] NULL,
[SNMPTIMEOUT] [int] NULL,
[SNMPRETRY] [int] NULL,
[DISCOVERY_INTERVAL] [int] NULL,
[SubNetToManage1] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SubNetToManage2] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SubNetToManage3] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SubNetToManage4] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RECLASS_POLLINTERVAL] [int] NULL,
[ManagedSubNets1] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ManagedSubNets2] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ManagedSubNets3] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ManagedSubNets4] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ManagedSubNets5] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ManagedSubNets6] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ManagedSubNets7] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ManagedSubNets8] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ManagedSubNets9] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ManagedSubNets10] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ManagedSubNets11] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ManagedSubNets12] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ManagedSubNets13] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ManagedSubNets14] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ManagedSubNets15] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ManagedSubNets16] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ManagedSubNets17] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ManagedSubNets18] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SNMPDISCOVERY_ENABLED] [tinyint] NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [x_ContinuousDiscoveryAgent_x] ON [dbo].[wtContinuousDiscoveryAgent] ([uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[wtContinuousDiscoveryAgent] TO [uniadmin]
GRANT INSERT ON  [dbo].[wtContinuousDiscoveryAgent] TO [uniadmin]
GRANT DELETE ON  [dbo].[wtContinuousDiscoveryAgent] TO [uniadmin]
GRANT UPDATE ON  [dbo].[wtContinuousDiscoveryAgent] TO [uniadmin]
GRANT SELECT ON  [dbo].[wtContinuousDiscoveryAgent] TO [uniuser]
GRANT SELECT ON  [dbo].[wtContinuousDiscoveryAgent] TO [wvadmin]
GRANT INSERT ON  [dbo].[wtContinuousDiscoveryAgent] TO [wvadmin]
GRANT DELETE ON  [dbo].[wtContinuousDiscoveryAgent] TO [wvadmin]
GRANT UPDATE ON  [dbo].[wtContinuousDiscoveryAgent] TO [wvadmin]
GRANT SELECT ON  [dbo].[wtContinuousDiscoveryAgent] TO [wvuser]
GO