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_arch] (
        [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_arch] (
        [dm_nodename],
        [dm_startdate]
) ON netmdm_monitoring_security_ps(dm_startdate)
GO
 
CREATE INDEX [netmdm_metsec_index2] ON [dbo].[netmdm_monitoring_security_arch] (
        [dm_startdate],
        [dm_eventtype]
) ON netmdm_monitoring_security_ps(dm_startdate)
GO
 
CREATE INDEX [netmdm_metsec_index3] ON [dbo].[netmdm_monitoring_security_arch] (
        [dm_hostname]
) ON netmdm_monitoring_security_ps(dm_startdate)
GO