USE [NETMDM_SAMPLE]
GO
SET ANSI_DEFAULTS OFF
SET ANSI_NULLS OFF
SET ANSI_PADDING OFF
SET ANSI_WARNINGS OFF
SET ARITHABORT OFF
SET QUOTED_IDENTIFIER ON
SET CONCAT_NULL_YIELDS_NULL OFF
SET ANSI_NULL_DFLT_ON OFF
SET STATISTICS TIME OFF
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[netmdm_monitoring_security] (
[dm_nodename] [varchar](64) NOT NULL,
[dm_hostname] [varchar](64) NULL DEFAULT (NULL),
[dm_ipaddress] [varchar](15) NULL DEFAULT (NULL),
[dm_startdate] [datetime] NOT NULL,
[dm_enddate] [datetime] NULL DEFAULT (NULL),
[dm_eventtype] [int] NOT NULL,
[dm_filename] [varchar](520) NULL DEFAULT (NULL),
[dm_filenamenew] [varchar](520) NULL DEFAULT (NULL),
[dm_productname] [varchar](50) NULL DEFAULT (NULL),
[dm_productversion] [varchar](50) NULL DEFAULT (NULL),
[dm_productlanguage] [int] NULL DEFAULT (NULL),
[dm_fileversion] [varchar](50) NULL DEFAULT (NULL),
[dm_filelanguage] [int] NULL DEFAULT (NULL),
[dm_logonuser] [varchar](128) NULL DEFAULT (NULL),
[dm_execaccount] [varchar](128) NULL DEFAULT (NULL),
[dm_caption] [varchar](520) NULL DEFAULT (NULL),
[dm_processname] [varchar](520) NULL DEFAULT (NULL),
[dm_drivetypeold] [int] NULL DEFAULT (NULL),
[dm_drivetypenew] [int] NULL DEFAULT (NULL),
[dm_documentname] [varchar](260) NULL,
[dm_printername] [varchar](484) NULL,
[dm_printingresult] [tinyint] NULL,
[dm_url] [varchar](2083) NULL,
[dm_drivetype] [int] NULL,
[dm_drivename] [char](2) NULL,
[dm_usbconnectname] [varchar](1024) NULL,
[dm_usbdiskdrive] [varchar](2048) NULL,
[dm_usbcontroller] [varchar](2048) NULL,
[dm_usballowedcondition] [varchar](2069) NULL,
[dm_devicetype] [int] NULL DEFAULT (NULL)
) ON netmdm_monitoring_security_ps(dm_startdate)
GO
CREATE INDEX [netmdm_metsec_index1] ON [dbo].[netmdm_monitoring_security] (
[dm_nodename],
[dm_startdate]
) ON netmdm_monitoring_security_ps(dm_startdate)
GO
CREATE INDEX [netmdm_metsec_index2] ON [dbo].[netmdm_monitoring_security] (
[dm_startdate],
[dm_eventtype]
) ON netmdm_monitoring_security_ps(dm_startdate)
GO
CREATE INDEX [netmdm_metsec_index3] ON [dbo].[netmdm_monitoring_security] (
[dm_hostname]
) ON netmdm_monitoring_security_ps(dm_startdate)
GO |