CREATE TABLE [dbo].[tng_agent_info]
(
[poller_server] [char] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dscvr_server] [char] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[agent_server] [char] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[poller_running] [int] NULL,
[dscvr_running] [int] NULL,
[agent_running] [int] NULL,
[elog_name] [char] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[elog_server] [char] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[total_object] [int] NULL,
[polled_object] [int] NULL,
[total_fault] [int] NULL,
[active_clients] [int] NULL,
[severity1] [int] NULL,
[severity2] [int] NULL,
[severity3] [int] NULL,
[severity4] [int] NULL,
[severity5] [int] NULL,
[hopcount1] [int] NULL,
[hopcount2] [int] NULL,
[hopcount3] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[tng_agent_info] TO [uniadmin]
GRANT INSERT ON  [dbo].[tng_agent_info] TO [uniadmin]
GRANT DELETE ON  [dbo].[tng_agent_info] TO [uniadmin]
GRANT UPDATE ON  [dbo].[tng_agent_info] TO [uniadmin]
GRANT SELECT ON  [dbo].[tng_agent_info] TO [uniuser]
GRANT SELECT ON  [dbo].[tng_agent_info] TO [wvadmin]
GRANT INSERT ON  [dbo].[tng_agent_info] TO [wvadmin]
GRANT DELETE ON  [dbo].[tng_agent_info] TO [wvadmin]
GRANT UPDATE ON  [dbo].[tng_agent_info] TO [wvadmin]
GRANT SELECT ON  [dbo].[tng_agent_info] TO [wvuser]
GO