CREATE TABLE [dbo].[e2e_wrm_wrmreport]
(
[urldescription] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[warnthres] [int] NULL,
[critthres] [int] NULL,
[resptime] [int] NULL,
[firstbytems] [int] NULL,
[sourceid] [int] NOT NULL,
[urlid] [int] NULL,
[statuscode] [int] NULL,
[activedetailid] [int] NULL,
[bytesrec] [int] NULL,
[contentcheckid] [int] NULL,
[timestart] [datetime] NOT NULL,
[timeend] [datetime] NOT NULL,
[groupid] [int] NULL,
[retrycount] [int] NULL,
[connecttimems] [int] NULL,
[pingtimems] [int] NULL,
[issent] [int] NULL CONSTRAINT [DF__e2e_wrm_w__issen__3A228BCB] DEFAULT ((0)),
[identifierid] [int] NULL,
[transactionid] [int] NULL,
[newsumstatid] [int] NULL,
[newrespstatid] [int] NULL,
[newaccuracystatid] [int] NULL,
[statusmessageid] [int] NULL,
[typeid] [int] NULL,
[timefactor] [int] NULL,
[minresptime] [int] NULL,
[maxresptime] [int] NULL,
[pctresptime] [int] NULL,
[requestnameid] [int] NULL,
[ismerged] [int] NULL CONSTRAINT [DF__e2e_wrm_w__ismer__3B16B004] DEFAULT ((0)),
[agedate] [int] NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xie4e2e_wrm_wrmreport] ON [dbo].[e2e_wrm_wrmreport] ([sourceid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xie3e2e_wrm_wrmreport] ON [dbo].[e2e_wrm_wrmreport] ([timeend]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xie1e2e_wrm_wrmreport] ON [dbo].[e2e_wrm_wrmreport] ([timefactor]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ie1e2e_wrm_wrmreport] ON [dbo].[e2e_wrm_wrmreport] ([timefactor], [issent]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xie2e2e_wrm_wrmreport] ON [dbo].[e2e_wrm_wrmreport] ([timestart]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xie6e2e_wrm_wrmreport] ON [dbo].[e2e_wrm_wrmreport] ([transactionid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xie7e2e_wrm_wrmreport] ON [dbo].[e2e_wrm_wrmreport] ([typeid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ie3e2e_wrm_wrmreport] ON [dbo].[e2e_wrm_wrmreport] ([typeid], [sourceid], [identifierid], [resptime], [timestart], [urlid], [timefactor]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ie4e2e_wrm_wrmreport] ON [dbo].[e2e_wrm_wrmreport] ([typeid], [sourceid], [identifierid], [resptime], [timestart], [urlid], [timefactor]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ie2e2e_wrm_wrmreport] ON [dbo].[e2e_wrm_wrmreport] ([typeid], [sourceid], [transactionid], [timestart], [issent], [urlid], [timefactor]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xie5e2e_wrm_wrmreport] ON [dbo].[e2e_wrm_wrmreport] ([typeid], [sourceid], [transactionid], [timestart], [timefactor], [requestnameid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xie8e2e_wrm_wrmreport] ON [dbo].[e2e_wrm_wrmreport] ([urlid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[e2e_wrm_wrmreport] TO [apmadmin]
GRANT INSERT ON  [dbo].[e2e_wrm_wrmreport] TO [apmadmin]
GRANT DELETE ON  [dbo].[e2e_wrm_wrmreport] TO [apmadmin]
GRANT UPDATE ON  [dbo].[e2e_wrm_wrmreport] TO [apmadmin]
GO