CREATE TABLE [dbo].[lsylanutilization]
(
[server_addr] [int] NOT NULL,
[probe_addr] [int] NOT NULL,
[intervaldatetime] [datetime] NOT NULL,
[intervalduration] [int] NOT NULL,
[probeindex] [int] NOT NULL,
[utilcount] [float] NULL,
[utilsum] [float] NULL,
[utilsos] [float] NULL,
[utilhist1] [float] NULL,
[utilhist2] [float] NULL,
[utilhist3] [float] NULL,
[utilhist4] [float] NULL,
[utilhistover] [float] NULL,
[utilhist1ctl] [smallint] NULL,
[utilhist2ctl] [smallint] NULL,
[utilhist3ctl] [smallint] NULL,
[utilhist4ctl] [smallint] NULL,
[utilthreshold] [tinyint] NULL,
[utilsamplesize] [smallint] NULL,
[utilavgeobs] [smallint] NULL,
[utilburstobs] [smallint] NULL,
[utilcrossingsctr] [float] NULL,
[utilpeakrate] [float] NULL,
[utilburstmax] [float] NULL,
[sizehist1] [float] NULL,
[sizehist2] [float] NULL,
[sizehist3] [float] NULL,
[sizehist4] [float] NULL,
[sizehistover] [float] NULL,
[sizehist1ctl] [smallint] NULL,
[sizehist2ctl] [smallint] NULL,
[sizehist3ctl] [smallint] NULL,
[sizehist4ctl] [smallint] NULL,
[totalframes] [float] NULL,
[totalbytes] [float] NULL,
[broadcastframes] [float] NULL,
[broadcastbytes] [float] NULL,
[multicastframes] [float] NULL,
[multicastbytes] [float] NULL,
[frameslostprobe] [float] NULL,
[frameslostbuf] [float] NULL,
[frameslosthard] [float] NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [baseidx_lsylanutilization] ON [dbo].[lsylanutilization] ([probe_addr], [intervaldatetime], [probeindex]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[lsylanutilization] TO [uniadmin]
GRANT INSERT ON  [dbo].[lsylanutilization] TO [uniadmin]
GRANT DELETE ON  [dbo].[lsylanutilization] TO [uniadmin]
GRANT UPDATE ON  [dbo].[lsylanutilization] TO [uniadmin]
GRANT SELECT ON  [dbo].[lsylanutilization] TO [uniuser]
GO