USE [master]
GO
/****** Object:  Database [logging2006]    Script Date: 10-08-2024 10:34:13 ******/
CREATE DATABASE [logging2006]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'logging2_Data', FILENAME = N'G:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\logging2006.mdf' , SIZE = 1144929792KB , MAXSIZE = UNLIMITED, FILEGROWTH = 102400KB )
 LOG ON 
( NAME = N'logging2_Log', FILENAME = N'G:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\logging2006_log.LDF' , SIZE = 10330112KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB )
 WITH CATALOG_COLLATION = DATABASE_DEFAULT
GO
ALTER DATABASE [logging2006] SET COMPATIBILITY_LEVEL = 120
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [logging2006].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [logging2006] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [logging2006] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [logging2006] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [logging2006] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [logging2006] SET ARITHABORT OFF 
GO
ALTER DATABASE [logging2006] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [logging2006] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [logging2006] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [logging2006] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [logging2006] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [logging2006] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [logging2006] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [logging2006] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [logging2006] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [logging2006] SET  DISABLE_BROKER 
GO
ALTER DATABASE [logging2006] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [logging2006] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [logging2006] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [logging2006] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [logging2006] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [logging2006] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [logging2006] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [logging2006] SET RECOVERY SIMPLE 
GO
ALTER DATABASE [logging2006] SET  MULTI_USER 
GO
ALTER DATABASE [logging2006] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [logging2006] SET DB_CHAINING OFF 
GO
ALTER DATABASE [logging2006] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [logging2006] SET TARGET_RECOVERY_TIME = 0 SECONDS 
GO
ALTER DATABASE [logging2006] SET DELAYED_DURABILITY = DISABLED 
GO
ALTER DATABASE [logging2006] SET ACCELERATED_DATABASE_RECOVERY = OFF  
GO
ALTER DATABASE [logging2006] SET QUERY_STORE = OFF
GO
USE [logging2006]
GO
/****** Object:  UserDefinedFunction [dbo].[inet_aton]    Script Date: 10-08-2024 10:34:13 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO


CREATE   FUNCTION [dbo].[inet_aton] (@ip nvarchar(50))  
RETURNS bigint
BEGIN
 
declare @i Int
declare @num1 nvarchar(3)
declare @num1a bigint
declare @num2 nvarchar(3)
declare @num2a bigint
declare @num3 nvarchar(3)
declare @num3a bigint
declare @num4 nvarchar(3)
declare @num4a bigint
declare @longip bigint

	select @i = charindex(".",@ip,0) - 1
	select @num1 = Left(@ip,@i)

	select @ip = right(@ip,len(@ip) - @i - 1)

	select @i = charindex(".",@ip,0) - 1
	select @num2 = Left(@ip,@i)
	select @ip = right(@ip,len(@ip) - @i - 1)

	select @i = charindex(".",@ip,0) - 1
	select @num3 = Left(@ip,@i)
	select @ip = right(@ip,len(@ip) - @i - 1)

	Select @num4 = @ip

        select @num1a = convert(bigint,@num1) 

	select @num2a = convert(bigint,@num2) 
	select @num3a = convert(bigint,@num3) 
	select @num4a = convert(bigint,@num4)

	/* select @Longip = convert(nvarchar,@num1) + "." + convert(nvarchar,@num2) + "." + convert(nvarchar,@num3) + "." + convert(nvarchar,@num4) */
/* select @Longip2dotted = "test.test.test.test" */
select @longip = (@num1a * 16777216) + (@num2a * 65536) + (@num3a * 256) + @num4a
     Return @longip
END



GO
/****** Object:  UserDefinedFunction [dbo].[inet_ntoa]    Script Date: 10-08-2024 10:34:13 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE FUNCTION [dbo].[inet_ntoa] (@longip bigint)  
RETURNS nvarchar(50)
BEGIN
 
declare @i Int
declare @num1 bigint
declare @num2 bigint
declare @num3 bigint
declare @num4 bigint
declare @Longip2dotted nvarchar(50)
	select @num1 = (@longip  & 0xFF000000  ) / 16777216
	select @num2 = (@longip & 0x00FF0000) / 65536 
	select @num3 =  (@longip & 0x0000FF00) / 256 
	select @num4 =  (@longip  & 0x000000FF )
            
	 select @Longip2dotted = convert(nvarchar,@num1) + "." + convert(nvarchar,@num2) + "." + convert(nvarchar,@num3) + "." + convert(nvarchar,@num4)
/* select @Longip2dotted = "test.test.test.test" */
            Return convert(nvarchar(50),@Longip2dotted)
END
GO
/****** Object:  UserDefinedFunction [dbo].[InterfaceBitps]    Script Date: 10-08-2024 10:34:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date, ,>
-- Description:	<Description, ,>
-- =============================================
CREATE FUNCTION [dbo].[InterfaceBitps]
(
	-- Add the parameters for the function here
	@bytes bigint
)
RETURNS nvarchar(50)
AS
BEGIN
	
	Declare @bpsToConvert as bigint
	Declare @result as nvarchar(50)
	-- Add the T-SQL statements to compute the return value here
	select @bpsToConvert = @bytes

	-- Return the result of the function		    
   
	  if ABS(@bpsToConvert) <= 9999
	  
	  BEGIN
	   select @result = CONCAT(ROUND(@bpsToConvert, 2 ), ' bit')
	  END
	  
	  else if ABS(@bpsToConvert) < 999999 

	  BEGIN
	   select @result = CONCAT(ROUND((@bpsToConvert/1000), 2 ), ' kbit')
	  END

      else if ABS(@bpsToConvert) < 999999999
	  
	  BEGIN
	   select @result = CONCAT( ROUND( (@bpsToConvert/1000)/1000, 2 ), ' Mbit')
	  END 

	  else if ABS(@bpsToConvert) < 999999999999
	  
	  BEGIN
	   select @result = CONCAT( ROUND(((@bpsToConvert/1000) / 1000) / 1000, 2 ), ' Gbit' )
	  END 

	  else if ABS(@bpsToConvert) < 999999999999999

	  BEGIN
	   select @result =  CONCAT( ROUND((((@bpsToConvert/1000) / 1000) / 1000) / 1000, 2 ), ' Tbit')
	  END
	  
	  RETURN convert(nvarchar(50),@Result)
END
GO
/****** Object:  UserDefinedFunction [dbo].[PrettyBps]    Script Date: 10-08-2024 10:34:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [dbo].[PrettyBps]
(
	-- Add the parameters for the function here
	@bytes bigint
)
RETURNS nvarchar(50)
AS
BEGIN
	-- Declare the return variable here
	Declare @bpsToConvert as bigint
	Declare @result as nvarchar(50)
	-- Add the T-SQL statements to compute the return value here
	select @bpsToConvert = @bytes

	-- Return the result of the function
		
   
	  if ABS(@bpsToConvert) < 1024
	  
	  BEGIN
	   select @result = CONCAT(ROUND(@bpsToConvert, 2 ), ' bit/s')
	  END
	  
	  else if ABS(@bpsToConvert) < 1048576 

	  BEGIN
	   select @result = CONCAT(ROUND((@bpsToConvert/1024), 2 ), ' kbit/s')
	  END

      else if ABS(@bpsToConvert) < 1073741824
	  
	  BEGIN
	   select @result = CONCAT( ROUND( (@bpsToConvert/1048576), 2 ), ' Mbit/s')
	  END 

	  else if ABS(@bpsToConvert) < 1099511627776
	  
	  BEGIN
	   select @result = CONCAT( ROUND( (@bpsToConvert/1073741824), 2 ), ' Gbit/s' )
	  END 

	  else if ABS(@bpsToConvert) < 1125899906842624 

	  BEGIN
	   select @result =  CONCAT( ROUND( (@bpsToConvert/1099511627776), 2 ), ' Tbit/s')
	  END

	  else if ABS(@bpsToConvert) < 1152921504606846976 
	  
	  BEGIN
	   select @result =  CONCAT( ROUND( (@bpsToConvert/1125899906842624), 2 ), ' Pbit/s' )
	  END

	  else if ABS(@bpsToConvert) < 1180591620717411303424

	  BEGIN
	   select @result =  CONCAT( ROUND( (@bpsToConvert/1152921504606846976) ,2), ' Ebit/s' )
	  END 

	  else if  ABS(@bpsToConvert) < 1208925819614629174706176 
	   
	  BEGIN
	   select @result =  CONCAT( ROUND( (@bpsToConvert/1180591620717411303424), 2), ' Zbit/s' )
	  END
      
	  else if ABS(@bpsToConvert) < 1237940039285380274899124224
	  
	  BEGIN
	   select @result =  CONCAT( ROUND( (@bpsToConvert/1208925819614629174706176), 2), ' Ybit/s' )
	  END

	  else if ABS(@bpsToConvert) < 1267650600228229401496703205376
	  
	  BEGIN
	   select @result = CONCAT( ROUND( (@bpsToConvert/1237940039285380274899124224), 2), ' Bbit/s' )
	  END

	  RETURN convert(nvarchar(50),@Result)
END


GO
/****** Object:  UserDefinedFunction [dbo].[PrettySystemUptime]    Script Date: 10-08-2024 10:34:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date, ,>
-- Description:	<Description, ,>
-- =============================================
CREATE FUNCTION [dbo].[PrettySystemUptime]
(
	-- Add the parameters for the function here
	@TimeNanoSec bigint
)
RETURNS nvarchar(50)
AS
BEGIN
	Declare @TimeSeconds as bigint
	-- Declare the return variable here
	Declare @Days int
	Declare @Hours int
	Declare @Minutes int
	Declare @Seconds int
	
	DECLARE @Result nvarchar(50)

	select @TimeSeconds = @TimeNanoSec / 100

	Select @days = Sum(@TimeSeconds) / 86400
	Select @Hours = (sum(@TimeSeconds) % 86400) /3600
	Select @Minutes = (Sum(@Timeseconds % 3600) / 60)
	Select @Seconds = sum(@Timeseconds % 60)
	
	if @days > 0 
	BEGIN
		SET @Result = convert(nvarchar,@days) + ' Days ' + convert(nvarchar,@Hours) + ' Hours ' + convert(nvarchar,@Minutes) + ' Minutes ' + convert(nvarchar,@Seconds) + ' Seconds'
	END
	ELSE IF @Hours > 0
	BEGIN
		SET @Result = convert(nvarchar,@Hours) + ' Hours ' + convert(nvarchar,@Minutes) + ' Minutes ' + convert(nvarchar,@Seconds) + ' Seconds'
	END
	ELSE IF @Minutes > 0
	BEGIN
		SET @Result = convert(nvarchar,@Minutes) + ' Minutes ' + convert(nvarchar,@Seconds) + ' Seconds'
	END
	ELSE
	BEGIN
		SET @Result = convert(nvarchar,@Seconds) + ' Seconds'
	END

	RETURN convert(nvarchar(50),@Result)

END
GO
/****** Object:  UserDefinedFunction [dbo].[PrettyTime]    Script Date: 10-08-2024 10:34:13 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
-- =============================================
-- Author:		Neosec
-- Create date: 26-05-2013
-- Description:	PrettyTime
-- =============================================
CREATE FUNCTION [dbo].[PrettyTime] 
(
	-- Add the parameters for the function here
	@TimeSeconds bigint
)
RETURNS nvarchar(50)
AS
BEGIN
	-- Declare the return variable here
	Declare @Days int
	Declare @Hours int
	Declare @Minutes int
	Declare @Seconds int
	
	DECLARE @Result nvarchar(50)

	Select @days = Sum(@TimeSeconds) / 86400
	Select @Hours = (sum(@TimeSeconds) % 86400) /3600
	Select @Minutes = (Sum(@Timeseconds % 3600) / 60)
	Select @Seconds = sum(@Timeseconds % 60)
	
	if @days > 0 
	BEGIN
		SET @Result = convert(nvarchar,@days) + ' Days ' + convert(nvarchar,@Hours) + ' Hours ' + convert(nvarchar,@Minutes) + ' Minutes ' + convert(nvarchar,@Seconds) + ' Seconds'
	END
	ELSE IF @Hours > 0
	BEGIN
		SET @Result = convert(nvarchar,@Hours) + ' Hours ' + convert(nvarchar,@Minutes) + ' Minutes ' + convert(nvarchar,@Seconds) + ' Seconds'
	END
	ELSE IF @Minutes > 0
	BEGIN
		SET @Result = convert(nvarchar,@Minutes) + ' Minutes ' + convert(nvarchar,@Seconds) + ' Seconds'
	END
	ELSE
	BEGIN
		SET @Result = convert(nvarchar,@Seconds) + ' Seconds'
	END

	RETURN convert(nvarchar(50),@Result)
	
			
	-- RETURN convert(nvarchar,@Result)
	

END
GO
/****** Object:  Table [dbo].[AD_Audit_Connection]    Script Date: 10-08-2024 10:34:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AD_Audit_Connection](
	[ID] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
	[Name] [varchar](128) NOT NULL,
	[Description] [text] NULL,
	[CredentialID] [varchar](50) NULL,
	[NetworkAgentID] [varchar](50) NULL,
	[BaseDN] [varchar](256) NOT NULL,
	[Hostnames] [varchar](256) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AlertEventCol]    Script Date: 10-08-2024 10:34:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AlertEventCol](
	[AlertEventID] [int] IDENTITY(1,1) NOT NULL,
	[AlertID] [nvarchar](50) NOT NULL,
	[EventID] [nvarchar](50) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AlertHistory]    Script Date: 10-08-2024 10:34:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AlertHistory](
	[historyid] [int] NOT NULL,
	[alertid] [int] NULL,
	[message] [nvarchar](3500) NULL,
	[timegenerated] [int] NOT NULL,
	[generatedby] [nvarchar](255) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Alerts]    Script Date: 10-08-2024 10:34:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Alerts](
	[alertid] [uniqueidentifier] NOT NULL,
	[Device] [bigint] NULL,
	[alertsource] [nvarchar](255) NULL,
	[alertname] [nvarchar](255) NULL,
	[description] [nvarchar](1500) NULL,
	[severity] [int] NOT NULL,
	[resolution] [smallint] NOT NULL,
	[alertcount] [int] NULL,
	[timecollected] [int] NOT NULL,
	[timefirstevent] [int] NULL,
	[timelastevent] [int] NULL,
	[timeresolved] [int] NULL,
	[resolvedby] [nvarchar](50) NULL,
	[timemodified] [int] NULL,
	[modifiedby] [nvarchar](255) NULL,
	[historycreated] [bit] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AlertView]    Script Date: 10-08-2024 10:34:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AlertView](
	[ID] [int] NOT NULL,
	[name] [nvarchar](128) NOT NULL,
	[description] [char](10) NULL,
	[sqlstring] [text] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Archive_SrcDstForensics]    Script Date: 10-08-2024 10:34:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Archive_SrcDstForensics](
	[ID] [int] NOT NULL,
	[eventid] [nvarchar](50) NOT NULL,
	[timecollected] [int] NULL,
	[timelocal] [int] NULL,
	[utcbias] [int] NULL,
	[eventtag] [nvarchar](50) NULL,
	[device] [bigint] NULL,
	[devicetype] [int] NULL,
	[name] [nvarchar](50) NULL,
	[srcip] [bigint] NULL,
	[srcport] [int] NULL,
	[dstip] [bigint] NULL,
	[dstport] [int] NULL,
	[protocol] [nvarchar](50) NULL,
	[ack] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Asset_Device_Enviroment]    Script Date: 10-08-2024 10:34:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Asset_Device_Enviroment](
	[DeviceID] [varchar](50) NULL,
	[EnviromentID] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Asset_Enviroments]    Script Date: 10-08-2024 10:34:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Asset_Enviroments](
	[EnviromentID] [int] NULL,
	[EnviromentName] [varchar](64) NULL,
	[Description] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Asset_HW_Computersystem]    Script Date: 10-08-2024 10:34:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Asset_HW_Computersystem](
	[deviceID] [nvarchar](50) NOT NULL,
	[Name] [nvarchar](250) NULL,
	[Domain] [nvarchar](250) NULL,
	[DomainRole] [nvarchar](150) NULL,
	[Model] [nvarchar](50) NULL,
	[Manufacturer] [nvarchar](250) NULL,
	[LogicalProcessors] [int] NULL,
	[ProcessorCores] [int] NULL,
	[PhysicalMemory] [bigint] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Asset_HW_EntityPhysical]    Script Date: 10-08-2024 10:34:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Asset_HW_EntityPhysical](
	[entIndex] [int] NULL,
	[entPhysicalIndex] [int] NULL,
	[entPhysicalDescr] [varchar](128) NULL,
	[entPhysicalVendorType] [varchar](50) NULL,
	[entPhysicalContainedIn] [int] NULL,
	[entPhysicalClass] [int] NULL,
	[entPhysicalParentRelPos] [int] NULL,
	[entPhysicalName] [varchar](128) NULL,
	[entPhysicalHardwareRev] [varchar](50) NULL,
	[entPhysicalFirmwareRev] [varchar](50) NULL,
	[entPhysicalSoftwareRev] [varchar](50) NULL,
	[entPhysicalSerialNum] [varchar](50) NULL,
	[entPhysicalMfgName] [varchar](50) NULL,
	[entPhysicalModelName] [varchar](50) NULL,
	[entPhysicalAlias] [varchar](50) NULL,
	[entPhysicalAssetID] [varchar](50) NULL,
	[entPhysicalFRU] [varchar](50) NULL,
	[deviceId] [varchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Asset_HW_LogicalDisk]    Script Date: 10-08-2024 10:34:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Asset_HW_LogicalDisk](
	[deviceID] [varchar](50) NOT NULL,
	[Name] [varchar](50) NULL,
	[Description] [varchar](150) NULL,
	[TotalSize] [bigint] NULL,
	[FreeSpace] [bigint] NULL,
	[UsedSpace] [bigint] NULL,
	[FileSystem] [varchar](50) NULL,
	[MediaType] [int] NULL,
	[SerialNumber] [varchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Asset_HW_NetworkDevice]    Script Date: 10-08-2024 10:34:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Asset_HW_NetworkDevice](
	[ID] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
	[DeviceID] [nvarchar](50) NULL,
	[Name] [nvarchar](50) NULL,
	[Model] [nvarchar](50) NULL,
	[Manufacturer] [nvarchar](250) NULL,
	[DeviceType] [int] NULL,
	[SerialNumber] [nvarchar](50) NULL,
	[HardwareVersion] [nvarchar](250) NULL,
	[SoftwareVersion] [nvarchar](250) NULL,
	[DeviceOID] [nvarchar](250) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Asset_HW_PhysicalDisk]    Script Date: 10-08-2024 10:34:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Asset_HW_PhysicalDisk](
	[deviceID] [varchar](50) NOT NULL,
	[Name] [varchar](150) NULL,
	[Description] [varchar](150) NULL,
	[SerialNumber] [varchar](50) NULL,
	[Size] [bigint] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Asset_HW_Processor]    Script Date: 10-08-2024 10:34:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Asset_HW_Processor](
	[deviceID] [varchar](50) NOT NULL,
	[Name] [varchar](50) NOT NULL,
	[Description] [varchar](64) NULL,
	[DataWidth] [int] NULL,
	[Cores] [int] NULL,
	[clockSpeed] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Asset_NET_Routetable]    Script Date: 10-08-2024 10:34:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Asset_NET_Routetable](
	[DeviceID] [varchar](50) NOT NULL,
	[Name] [varchar](50) NULL,
	[Destination] [bigint] NULL,
	[Mask] [bigint] NULL,
	[Gateway] [bigint] NULL,
	[Metric] [int] NULL,
	[IfIndex] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Asset_NET_RoutetableIPv4]    Script Date: 10-08-2024 10:34:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Asset_NET_RoutetableIPv4](
	[DeviceID] [varchar](50) NOT NULL,
	[Name] [varchar](50) NULL,
	[Destination] [bigint] NULL,
	[Mask] [bigint] NULL,
	[Gateway] [bigint] NULL,
	[Metric] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Asset_ServiceContract]    Script Date: 10-08-2024 10:34:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Asset_ServiceContract](
	[Id] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
	[Number] [nvarchar](50) NULL,
	[Name] [nvarchar](128) NULL,
	[Description] [text] NULL,
	[StartDate] [bigint] NULL,
	[EndDate] [bigint] NULL,
	[Type] [nvarchar](50) NULL,
	[Status] [int] NULL,
	[CreatedBy] [nvarchar](50) NULL,
	[RenewDate] [bigint] NULL,
	[RenewedBy] [nvarchar](50) NULL,
	[VendorID] [nvarchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Asset_ServiceContract_Device]    Script Date: 10-08-2024 10:34:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Asset_ServiceContract_Device](
	[ServiceContractID] [nvarchar](50) NULL,
	[deviceID] [nvarchar](50) NULL,
	[SerialNumber] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Asset_ServiceContract_Vendor]    Script Date: 10-08-2024 10:34:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Asset_ServiceContract_Vendor](
	[VendorID] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
	[Name] [nvarchar](50) NULL,
	[Address1] [nvarchar](128) NULL,
	[Address2] [nvarchar](128) NULL,
	[PostCode] [nvarchar](10) NULL,
	[City] [nvarchar](50) NULL,
	[Country] [nvarchar](128) NULL,
	[Telephone] [nvarchar](50) NULL,
	[Mobile] [nvarchar](50) NULL,
	[Email] [nvarchar](128) NULL,
	[ContactSirName] [nvarchar](50) NULL,
	[ContactLastName] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Asset_SW_FeatureRole]    Script Date: 10-08-2024 10:34:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Asset_SW_FeatureRole](
	[DeviceID] [varchar](50) NOT NULL,
	[RoleName] [varchar](150) NULL,
	[RoleID] [int] NULL,
	[ParentRoleID] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Asset_SW_WindowsServices]    Script Date: 10-08-2024 10:34:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Asset_SW_WindowsServices](
	[DeviceID] [varchar](50) NOT NULL,
	[IPAddress] [varchar](50) NULL,
	[Name] [varchar](50) NOT NULL,
	[DisplayName] [varchar](50) NOT NULL,
	[Description] [varchar](256) NOT NULL,
	[StartMode] [varchar](50) NOT NULL,
	[State] [varchar](50) NOT NULL,
	[ProcessPath] [varchar](256) NOT NULL,
	[Username] [varchar](50) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[auditlog]    Script Date: 10-08-2024 10:34:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[auditlog](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[timecollected] [int] NOT NULL,
	[username] [varchar](50) NULL,
	[srcip] [bigint] NULL,
	[workstationname] [varchar](255) NULL,
	[Action] [int] NULL,
	[Actiontext] [varchar](1024) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Availability]    Script Date: 10-08-2024 10:34:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Availability](
	[timecollected] [int] NOT NULL,
	[device] [bigint] NOT NULL,
	[AvailMin] [int] NULL,
	[AvailAvg] [int] NULL,
	[AvailMax] [int] NULL,
	[Packetloss] [int] NULL,
	[Availability] [int] NULL,
	[Maintenance] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[CPUperf]    Script Date: 10-08-2024 10:34:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CPUperf](
	[timecollected] [int] NOT NULL,
	[device] [bigint] NOT NULL,
	[value] [int] NULL,
	[cpuid] [int] NULL,
	[ResponseTime] [int] NULL,
	[loss] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Credentials]    Script Date: 10-08-2024 10:34:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Credentials](
	[CredentialID] [varchar](128) NOT NULL,
	[Name] [varchar](64) NOT NULL,
	[Description] [varchar](64) NULL,
	[CredentialType] [int] NOT NULL,
	[Username] [varchar](32) NULL,
	[Password] [varchar](128) NULL,
	[EnablePassword] [varchar](128) NULL,
	[readCommunity] [varchar](16) NULL,
	[writeCommunity] [varchar](16) NULL,
	[ProtocolVersion] [int] NULL,
	[Domain] [varchar](32) NULL,
	[Port] [int] NULL,
	[Timeout] [int] NULL,
	[AuthProtocol] [varchar](50) NULL,
	[AuthPassword] [varchar](128) NULL,
	[PrivProtocol] [varchar](50) NULL,
	[PrivPassword] [varchar](128) NULL,
	[ContextName] [varchar](128) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[DataCollect]    Script Date: 10-08-2024 10:34:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DataCollect](
	[dataid] [int] NOT NULL,
	[value] [float] NOT NULL,
	[datetime] [int] NOT NULL,
	[collecttime] [int] NOT NULL,
	[collectid] [int] NOT NULL,
	[msgshort] [varchar](255) NULL,
	[msglong] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[DeviceEnviroment]    Script Date: 10-08-2024 10:34:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DeviceEnviroment](
	[ID] [int] NOT NULL,
	[Enviroment] [nvarchar](50) NOT NULL,
	[Description] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[devicegroups]    Script Date: 10-08-2024 10:34:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[devicegroups](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[description] [varchar](128) NOT NULL,
	[devicetype] [int] NULL,
	[bindtodevicetype] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[devices]    Script Date: 10-08-2024 10:34:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[devices](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[deviceID] [varchar](50) NOT NULL,
	[ipaddress] [bigint] NOT NULL,
	[hostname] [varchar](255) NULL,
	[description] [nvarchar](255) NULL,
	[devicetype] [int] NULL,
	[active] [int] NULL,
	[timeadded] [bigint] NULL,
	[status] [int] NULL,
	[devicegroup] [int] NULL,
	[lastActive] [bigint] NULL,
	[serialnumber] [nvarchar](250) NULL,
	[devicevendor] [nvarchar](250) NULL,
	[devicemodel] [nvarchar](250) NULL,
	[hardwareversion] [nvarchar](250) NULL,
	[softwareversion] [nvarchar](250) NULL,
	[firmwareversion] [nvarchar](250) NULL,
	[assetid] [nvarchar](250) NULL,
	[deviceoid] [nvarchar](255) NULL,
	[systemuptime] [bigint] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[DeviceToVirtual]    Script Date: 10-08-2024 10:34:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DeviceToVirtual](
	[ID] [varchar](50) NOT NULL,
	[InstanceUUID] [nvarchar](50) NOT NULL,
	[deviceID] [varchar](50) NOT NULL,
	[virtualInfrastructureID] [nvarchar](50) NOT NULL,
	[vmPath] [nvarchar](256) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[DeviceTypes]    Script Date: 10-08-2024 10:34:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DeviceTypes](
	[id] [int] NOT NULL,
	[devicetypename] [nvarchar](100) NOT NULL,
	[devicetype] [nvarchar](15) NOT NULL,
	[manufactore] [nvarchar](100) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[eventlog]    Script Date: 10-08-2024 10:34:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[eventlog](
	[ID] [int] NOT NULL,
	[logtime] [int] NOT NULL,
	[logmessage] [nvarchar](50) NOT NULL,
	[device] [nvarchar](50) NOT NULL,
	[severity] [int] NOT NULL,
	[facility] [int] NOT NULL,
	[event] [nvarchar](1024) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[events]    Script Date: 10-08-2024 10:34:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[events](
	[eventid] [uniqueidentifier] NOT NULL,
	[parentid] [int] NULL,
	[childid] [int] NULL,
	[timecollected] [int] NOT NULL,
	[device] [bigint] NULL,
	[deviceold] [varchar](128) NULL,
	[name] [varchar](128) NULL,
	[severity] [int] NOT NULL,
	[facility] [int] NULL,
	[event] [nvarchar](max) NULL,
	[logmessage] [varchar](128) NULL,
	[devicetype] [varchar](128) NULL,
	[eventcount] [int] NULL,
	[status] [int] NULL,
	[msgid] [int] NULL,
	[acktime] [int] NULL,
	[ackuser] [varchar](128) NULL,
	[Source] [nvarchar](255) NULL,
	[Category] [nvarchar](255) NULL,
	[EventUser] [nvarchar](255) NULL,
	[EventCode] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Index [_dta_index_events_c_5_1842105603__K4]    Script Date: 10-08-2024 10:34:19 ******/
CREATE CLUSTERED INDEX [_dta_index_events_c_5_1842105603__K4] ON [dbo].[events]
(
	[timecollected] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[GeoIPCountryWhois]    Script Date: 10-08-2024 10:34:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GeoIPCountryWhois](
	[begin_ip] [bigint] NULL,
	[end_ip] [bigint] NULL,
	[cc] [nvarchar](2) NULL,
	[country] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[headerdatacollect]    Script Date: 10-08-2024 10:34:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[headerdatacollect](
	[dataid] [int] NOT NULL,
	[collectid] [int] NOT NULL,
	[collectname] [varchar](255) NULL,
	[Legend] [varchar](255) NOT NULL,
	[devicename] [varchar](128) NULL,
	[device] [varchar](128) NOT NULL,
	[devicetype] [varchar](128) NOT NULL,
	[starttime] [int] NOT NULL,
	[lasttime] [int] NOT NULL,
	[minvalue] [int] NOT NULL,
	[maxval] [int] NOT NULL,
	[statsmin] [float] NULL,
	[statsmax] [float] NULL,
	[statsavg] [float] NULL,
	[interval] [int] NOT NULL,
	[status] [int] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[headerevent]    Script Date: 10-08-2024 10:34:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[headerevent](
	[eventid] [int] NOT NULL,
	[parentid] [int] NULL,
	[childid] [int] NULL,
	[device] [varchar](128) NOT NULL,
	[devicetype] [varchar](128) NOT NULL,
	[logmessage] [varchar](128) NOT NULL,
	[starttime] [int] NOT NULL,
	[modtime] [int] NOT NULL,
	[evtcount] [int] NOT NULL,
	[status] [int] NOT NULL,
	[msgshort] [varchar](255) NOT NULL,
	[msglong] [text] NOT NULL,
	[acktime] [int] NULL,
	[ackuser] [varchar](128) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[IPAddGroup]    Script Date: 10-08-2024 10:34:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[IPAddGroup](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[Description] [nvarchar](50) NOT NULL,
	[Type] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[IPAddObsList]    Script Date: 10-08-2024 10:34:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[IPAddObsList](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[Description] [nvarchar](50) NOT NULL,
	[IPnetStart] [bigint] NOT NULL,
	[IPnetEnd] [bigint] NOT NULL,
	[Type] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ipaddresslocal]    Script Date: 10-08-2024 10:34:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ipaddresslocal](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[ipaddress] [bigint] NOT NULL,
	[macaddress] [varchar](50) NULL,
	[dnsname] [varchar](256) NULL,
	[inittime] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ipnets]    Script Date: 10-08-2024 10:34:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ipnets](
	[ipnetID] [int] IDENTITY(1,1) NOT NULL,
	[description] [nvarchar](50) NOT NULL,
	[device] [bigint] NOT NULL,
	[ipnetstart] [bigint] NOT NULL,
	[ipnetend] [bigint] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[IPtoGroup]    Script Date: 10-08-2024 10:34:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[IPtoGroup](
	[IpID] [int] NULL,
	[GroupID] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[LLDP_Interfaces]    Script Date: 10-08-2024 10:34:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LLDP_Interfaces](
	[DeviceID] [nvarchar](50) NULL,
	[IfIndex] [int] NULL,
	[PortIndex] [int] NULL,
	[PortDescription] [nvarchar](128) NULL,
	[DeviceSystem] [nvarchar](512) NULL,
	[ChassisID] [nvarchar](50) NULL,
	[ManagementAddress] [nvarchar](250) NULL,
	[Hostname] [nvarchar](255) NULL,
	[discoverTime] [bigint] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[logfiles]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[logfiles](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[logfiletype] [int] NULL,
	[filename] [varchar](255) NOT NULL,
	[md5] [varchar](50) NULL,
	[timecreated] [int] NULL,
	[timearchivestart] [int] NULL,
	[timearchivestop] [int] NULL,
	[device] [bigint] NULL,
	[filepath] [varchar](255) NOT NULL,
	[Archived] [int] NULL,
	[Archivefilepath] [varchar](255) NULL,
	[ArchiveStatus] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[lognumbers]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[lognumbers](
	[id] [int] NOT NULL,
	[logmessage] [int] NOT NULL,
	[logshortdescription] [nvarchar](255) NOT NULL,
	[logdescription] [nvarchar](4000) NULL,
	[devicetype] [int] NOT NULL,
	[clasify] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[macaddress]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[macaddress](
	[id] [int] NOT NULL,
	[macaddress] [varchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[memperf]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[memperf](
	[timecollected] [int] NOT NULL,
	[device] [bigint] NOT NULL,
	[used] [bigint] NULL,
	[free] [bigint] NULL,
	[largest] [bigint] NULL,
	[ResponseTime] [int] NULL,
	[loss] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[monitorgroups]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[monitorgroups](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Description] [varchar](255) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[monitorlist]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[monitorlist](
	[monitorgroupid] [varchar](50) NOT NULL,
	[monitorid] [int] NOT NULL,
	[monitortype] [int] NULL,
	[device] [varchar](50) NULL,
	[description] [varchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[MonTypes]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MonTypes](
	[id] [uniqueidentifier] NOT NULL,
	[MonType] [int] NOT NULL,
	[MonTag] [varchar](50) NOT NULL,
	[Description] [varchar](255) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[NetworkAgent]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[NetworkAgent](
	[ID] [varchar](50) NOT NULL,
	[UniqeID] [varchar](100) NOT NULL,
	[hostname] [varchar](256) NULL,
	[ipaddress] [bigint] NULL,
	[macaddress] [varchar](10) NULL,
	[state] [int] NULL,
	[active] [int] NULL,
	[timeadded] [bigint] NULL,
	[lastactive] [bigint] NULL,
	[version] [varchar](50) NULL,
	[Description] [varchar](100) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[NetworkAgent_IPNETS]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[NetworkAgent_IPNETS](
	[NetworkAgentID] [varchar](50) NULL,
	[ipnetID] [varchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[NotificationList]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[NotificationList](
	[NotificationListID] [varchar](50) NOT NULL,
	[NotificationID] [varchar](50) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[PortTypes]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PortTypes](
	[id] [uniqueidentifier] NOT NULL,
	[PortNr] [int] NOT NULL,
	[ProtocolType] [nvarchar](50) NULL,
	[Description] [nvarchar](128) NULL,
	[LongDescription] [nvarchar](1024) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ProcessPerf]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProcessPerf](
	[timecollected] [bigint] NOT NULL,
	[device] [bigint] NOT NULL,
	[id] [int] NULL,
	[CPUUsage] [int] NULL,
	[ProcessID] [int] NULL,
	[MemUsage] [bigint] NULL,
	[MemUsagePercent] [int] NULL,
	[PageFileUsage] [bigint] NULL,
	[PageFileUsagePercent] [int] NULL,
	[VirtualMemUsage] [bigint] NULL,
	[VirtualMemUsagePercent] [int] NULL,
	[ResponseTime] [int] NULL,
	[loss] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[reportcollections]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[reportcollections](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[reporttoken] [varchar](50) NULL,
	[reportcollectionname] [varchar](128) NULL,
	[reportcollectiondescription] [text] NULL,
	[checkedin] [tinyint] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[reportfiles]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[reportfiles](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[timecollected] [bigint] NULL,
	[reportID] [varchar](50) NULL,
	[reportdescription] [varchar](128) NULL,
	[reportfilename] [text] NULL,
	[reporttype] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[reportscripts]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[reportscripts](
	[ID] [int] NOT NULL,
	[reportname] [char](128) NOT NULL,
	[reportdescription] [nvarchar](4000) NOT NULL,
	[reportscript] [nvarchar](4000) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ResolutionTypes]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ResolutionTypes](
	[resolution] [smallint] NULL,
	[resolutionname] [nvarchar](50) NULL,
	[resolutiondescription] [nvarchar](1024) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ServerInfo]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ServerInfo](
	[ServerID] [uniqueidentifier] NOT NULL,
	[ServerName] [nvarchar](255) NOT NULL,
	[ServerType] [nvarchar](50) NULL,
	[Location] [nvarchar](50) NULL,
	[TimeZone] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ServerStatistics]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ServerStatistics](
	[datetime] [int] NOT NULL,
	[serverid] [uniqueidentifier] NOT NULL,
	[stattype] [int] NOT NULL,
	[statdata] [float] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ServicePerf]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ServicePerf](
	[timecollected] [bigint] NOT NULL,
	[device] [bigint] NOT NULL,
	[id] [int] NULL,
	[state] [nvarchar](50) NULL,
	[ResponseTime] [int] NULL,
	[loss] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[severitytypes]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[severitytypes](
	[severity] [int] NOT NULL,
	[severityname] [nvarchar](50) NOT NULL,
	[severitydescription] [nvarchar](1024) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[snmpAddOperStatus]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[snmpAddOperStatus](
	[id] [int] NULL,
	[Description] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[snmpAdminStatus]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[snmpAdminStatus](
	[id] [int] NULL,
	[Description] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[snmpdata]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[snmpdata](
	[timecollected] [int] NOT NULL,
	[id] [int] NOT NULL,
	[avgval] [decimal](18, 4) NULL,
	[minval] [decimal](18, 4) NULL,
	[maxval] [decimal](18, 4) NULL,
	[valuestr] [nchar](255) NULL,
	[loss] [int] NULL,
	[response] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[snmpinterfaces]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[snmpinterfaces](
	[device] [bigint] NOT NULL,
	[nodeID] [int] NOT NULL,
	[ifDescr] [varchar](255) NULL,
	[ifType] [int] NULL,
	[ifMTU] [int] NULL,
	[ifSpeed] [bigint] NULL,
	[ifPhysAddress] [varchar](255) NULL,
	[ifAdminStatus] [int] NULL,
	[ifOperStatus] [int] NULL,
	[ifLastChange] [varchar](255) NULL,
	[realLifeSpeed] [int] NULL,
	[collectstats] [tinyint] NULL,
	[ifAlias] [varchar](255) NULL,
	[ifName] [varchar](255) NULL,
	[StatusSeverity] [int] NULL,
	[StatusText] [varchar](256) NULL,
	[InterfaceType] [int] NULL,
	[ifInbps] [bigint] NULL,
	[ifOutbps] [bigint] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[snmpinterfacetraffic]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[snmpinterfacetraffic](
	[timecollected] [int] NOT NULL,
	[device] [bigint] NOT NULL,
	[interfaceid] [int] NOT NULL,
	[ifInOctets] [bigint] NOT NULL,
	[ifInbps] [bigint] NOT NULL,
	[ifOutOctets] [bigint] NOT NULL,
	[ifOutbps] [bigint] NOT NULL,
	[ifInUcastPkts] [bigint] NOT NULL,
	[ifInNUcastPkts] [bigint] NOT NULL,
	[ifInDiscards] [bigint] NOT NULL,
	[ifInErrors] [bigint] NOT NULL,
	[ifInUnknownProtos] [bigint] NOT NULL,
	[ifOutUcastPkts] [bigint] NOT NULL,
	[ifOutNUcastPkts] [bigint] NOT NULL,
	[ifOutDiscards] [bigint] NOT NULL,
	[ifOutErrors] [bigint] NOT NULL,
	[ifOutQLen] [bigint] NOT NULL,
	[loss] [int] NULL,
	[InterfaceType] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Index [indexinterface]    Script Date: 10-08-2024 10:34:21 ******/
CREATE CLUSTERED INDEX [indexinterface] ON [dbo].[snmpinterfacetraffic]
(
	[timecollected] ASC,
	[device] ASC,
	[ifInbps] ASC,
	[ifOutbps] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = ON, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[snmpInterfaceType]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[snmpInterfaceType](
	[ifType] [int] NOT NULL,
	[ifTypeString] [nvarchar](50) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[snmpInterfaceVLAN]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[snmpInterfaceVLAN](
	[DeviceID] [varchar](50) NOT NULL,
	[ifIndex] [nchar](10) NULL,
	[Vlan] [int] NULL,
	[VlanType] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[snmpmonitors]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[snmpmonitors](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[device] [bigint] NOT NULL,
	[monitortype] [int] NULL,
	[monitoragent] [int] NULL,
	[OID] [varchar](255) NULL,
	[WQL] [varchar](255) NULL,
	[Description] [varchar](128) NULL,
	[Interval] [int] NOT NULL,
	[datatype] [int] NOT NULL,
	[Active] [int] NULL,
	[Legend] [varchar](50) NULL,
	[EnableThreshold] [int] NULL,
	[ThresholdValue] [decimal](18, 4) NULL,
	[ThresholdStrValue] [varchar](256) NULL,
	[Thresholdchecktype] [int] NULL,
	[ThresholdAlarmCount] [int] NULL,
	[AlertSeverityLevel] [int] NULL,
	[EnableClearThreshold] [int] NULL,
	[ClearThresholdValue] [decimal](18, 4) NULL,
	[ClearThresholdStrValue] [varchar](256) NULL,
	[ClearAlertSeverityLevel] [int] NULL,
	[StatusText] [varchar](256) NULL,
	[StatusSeverity] [int] NULL,
	[LastValue] [decimal](18, 4) NULL,
	[LastTextValue] [varchar](256) NULL,
	[ValueScale] [decimal](18, 4) NULL,
	[ValueScaleType] [int] NULL,
	[EnableNotification] [int] NULL,
	[NotificationListID] [varchar](50) NULL,
	[deviceID] [varchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[snmpOperstatus]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[snmpOperstatus](
	[id] [int] NULL,
	[Description] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SrcDstEventCol]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SrcDstEventCol](
	[colid] [int] IDENTITY(1,1) NOT NULL,
	[srcdstID] [nvarchar](50) NOT NULL,
	[eventID] [nvarchar](50) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SrcDstForensics]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SrcDstForensics](
	[ID] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
	[eventid] [nvarchar](50) NOT NULL,
	[timecollected] [int] NULL,
	[timelocal] [int] NULL,
	[utcbias] [int] NULL,
	[eventtag] [nvarchar](50) NULL,
	[device] [bigint] NULL,
	[devicetype] [int] NULL,
	[name] [nvarchar](50) NULL,
	[srcip] [bigint] NULL,
	[srcport] [int] NULL,
	[dstip] [bigint] NULL,
	[dstport] [int] NULL,
	[protocol] [nvarchar](50) NULL,
	[ack] [nvarchar](50) NULL,
	[User] [nvarchar](50) NULL,
	[Reason] [nvarchar](254) NULL,
	[SiteType] [nvarchar](50) NULL,
	[Site] [nvarchar](254) NULL,
	[Category] [nvarchar](50) NULL,
	[ThreatLevel] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SrcDstStats]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SrcDstStats](
	[ID] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
	[TimeCollected] [int] NOT NULL,
	[TimeStarted] [int] NOT NULL,
	[EventTag] [nvarchar](50) NULL,
	[Device] [bigint] NOT NULL,
	[DeviceType] [int] NULL,
	[srcIP] [bigint] NULL,
	[srcPort] [int] NULL,
	[DstIP] [bigint] NULL,
	[DstPort] [int] NULL,
	[GblIP] [bigint] NULL,
	[GblPort] [int] NULL,
	[RecvBytes] [int] NULL,
	[SendBytes] [int] NULL,
	[TotalBytes] [bigint] NULL,
	[TotalTime] [int] NULL,
	[Protocol] [nvarchar](10) NULL,
	[Reason] [nvarchar](50) NULL,
	[User] [nvarchar](50) NULL,
	[Group] [nvarchar](50) NULL,
	[SiteType] [nvarchar](50) NULL,
	[Site] [nvarchar](254) NULL,
	[Category] [nvarchar](50) NULL,
	[ThreatLevel] [nvarchar](50) NULL,
	[NewRecvBytes] [bigint] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SrcDstStats_new]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SrcDstStats_new](
	[ID] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
	[TimeCollected] [int] NOT NULL,
	[TimeStarted] [int] NOT NULL,
	[EventTag] [nvarchar](50) NULL,
	[Device] [bigint] NOT NULL,
	[DeviceType] [int] NULL,
	[srcIP] [bigint] NULL,
	[srcPort] [int] NULL,
	[DstIP] [bigint] NULL,
	[DstPort] [int] NULL,
	[GblIP] [bigint] NULL,
	[GblPort] [int] NULL,
	[RecvBytes] [bigint] NULL,
	[SendBytes] [bigint] NULL,
	[TotalBytes] [bigint] NULL,
	[TotalTime] [int] NULL,
	[Protocol] [nvarchar](10) NULL,
	[Reason] [nvarchar](50) NULL,
	[User] [nvarchar](50) NULL,
	[Group] [nvarchar](50) NULL,
	[SiteType] [nvarchar](50) NULL,
	[Site] [nvarchar](254) NULL,
	[Category] [nvarchar](50) NULL,
	[ThreatLevel] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[StatisticsToday]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[StatisticsToday](
	[EventsToday] [bigint] NULL,
	[ForensicsToday] [bigint] NULL,
	[StatisticsToday] [bigint] NULL,
	[AlertsToday] [bigint] NULL,
	[ClosedAlertsToday] [bigint] NULL,
	[OpenAlerts] [bigint] NULL,
	[TotalEventsToday] [bigint] NULL,
	[SevEmergencyToday] [bigint] NULL,
	[SevAlertsToday] [bigint] NULL,
	[SevCriticalToday] [bigint] NULL,
	[SevErrorToday] [bigint] NULL,
	[SevWarningToday] [bigint] NULL,
	[SevNotificationToday] [bigint] NULL,
	[SevInformationalToday] [bigint] NULL,
	[SevDebugToday] [bigint] NULL,
	[TotalSNMPDevices] [bigint] NULL,
	[TotalDevices] [bigint] NULL,
	[TotalDevicesToday] [bigint] NULL,
	[TotalSNMPDevicesToday] [bigint] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[StoragePerf]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[StoragePerf](
	[timecollected] [bigint] NOT NULL,
	[device] [bigint] NOT NULL,
	[id] [int] NOT NULL,
	[totalstorage] [bigint] NULL,
	[usedstorage] [bigint] NULL,
	[freestorage] [bigint] NULL,
	[percentused] [int] NULL,
	[percentfree] [int] NULL,
	[loss] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[syslog]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[syslog](
	[logtime] [int] NOT NULL,
	[device] [nvarchar](50) NOT NULL,
	[logmessage] [nvarchar](50) NULL,
	[severity] [int] NOT NULL,
	[sourceip] [nvarchar](50) NOT NULL,
	[sourceport] [int] NOT NULL,
	[destinationip] [nvarchar](50) NOT NULL,
	[destinationport] [int] NOT NULL,
	[protocoltype] [nvarchar](50) NULL,
	[flag] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[syslogd]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[syslogd](
	[ID] [int] NOT NULL,
	[logtime] [int] NOT NULL,
	[device] [nvarchar](50) NOT NULL,
	[logmessage] [nvarchar](50) NOT NULL,
	[severity] [int] NOT NULL,
	[facility] [int] NOT NULL,
	[syslogtext] [nvarchar](500) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Tags]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Tags](
	[TagID] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
	[TagName] [nvarchar](64) NOT NULL,
	[TagDescription] [nvarchar](254) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Tags_DeviceID]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Tags_DeviceID](
	[TagID] [nvarchar](50) NOT NULL,
	[DeviceID] [nvarchar](50) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Tags_Monitors]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Tags_Monitors](
	[TagId] [nvarchar](50) NULL,
	[MonitorID] [bigint] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Tags_NetworkInterfaces]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Tags_NetworkInterfaces](
	[TagId] [nvarchar](50) NULL,
	[DeviceID] [nvarchar](50) NULL,
	[nodeID] [bigint] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[testtable]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[testtable](
	[test] [nvarchar](50) NOT NULL,
	[test2] [real] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UpdatePaths]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UpdatePaths](
	[ID] [nvarchar](50) NOT NULL,
	[Path] [nvarchar](250) NOT NULL,
	[PathType] [int] NOT NULL,
	[Description] [nvarchar](250) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[userroles]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userroles](
	[role] [int] NOT NULL,
	[roledescription] [varchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[users]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[users](
	[UserID] [int] IDENTITY(1,1) NOT NULL,
	[username] [varchar](50) NOT NULL,
	[password] [varchar](50) NULL,
	[email] [varchar](128) NULL,
	[firstname] [varchar](128) NULL,
	[lastname] [varchar](128) NULL,
	[role] [int] NOT NULL,
	[mobilenr] [varchar](50) NULL,
	[changepassword] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ViewHour]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ViewHour](
	[Hour] [int] NULL,
	[HourText] [char](10) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[virtualmemperf]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[virtualmemperf](
	[timecollected] [int] NOT NULL,
	[device] [bigint] NOT NULL,
	[virtualMemUsed] [bigint] NULL,
	[VirtualMemFree] [bigint] NULL,
	[VirtualMemLargest] [bigint] NULL,
	[Responsetime] [int] NULL,
	[Loss] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Index [virtialmem_index]    Script Date: 10-08-2024 10:34:21 ******/
CREATE CLUSTERED INDEX [virtialmem_index] ON [dbo].[virtualmemperf]
(
	[timecollected] ASC,
	[device] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[vmInfrastructureConfiguration]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[vmInfrastructureConfiguration](
	[vmInfrastructureID] [uniqueidentifier] NOT NULL,
	[hostname] [varchar](256) NOT NULL,
	[CredentialID] [varchar](50) NULL,
	[vmInfrastructureType] [int] NOT NULL,
	[Description] [varchar](250) NULL,
	[Enabled] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[vmInfrastructureDatastore]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[vmInfrastructureDatastore](
	[vmInfrastructureID] [varchar](50) NOT NULL,
	[vmMoref] [varchar](50) NOT NULL,
	[Name] [varchar](150) NOT NULL,
	[TotalStorage] [bigint] NULL,
	[FreeStorage] [bigint] NULL,
	[UsedStorage] [bigint] NULL,
	[DatastoreType] [varchar](50) NULL,
	[Version] [decimal](18, 0) NULL,
	[datastoreURL] [varchar](250) NULL,
	[Accessable] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[vmInfrastructureDevice]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[vmInfrastructureDevice](
	[DeviceID] [varchar](50) NULL,
	[vmInfrastructureID] [varchar](50) NOT NULL,
	[vmInstanceUUID] [varchar](50) NOT NULL,
	[CredentialID] [varchar](50) NULL,
	[PowerState] [varchar](50) NULL,
	[GuestState] [varchar](50) NULL,
	[GuestToolsState] [int] NULL,
	[GuestToolsVersion] [varchar](50) NULL,
	[SnapshotState] [int] NULL,
	[RunningOS] [varchar](250) NULL,
	[ConfiguredOS] [varchar](50) NULL,
	[Hostname] [varchar](50) NULL,
	[IPAddresses] [varchar](100) NULL,
	[vmPath] [varchar](250) NULL,
	[GuestHWVersion] [int] NULL,
	[MarkedForDelete] [int] NULL,
	[NumCPU] [int] NULL,
	[MemoryMB] [int] NULL,
	[Name] [varchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[vmInfrastructureDeviceGuestNic]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[vmInfrastructureDeviceGuestNic](
	[vmInfrastructureID] [nvarchar](50) NOT NULL,
	[vmInstanceUUID] [nvarchar](50) NOT NULL,
	[ID] [int] NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
	[Connected] [int] NULL,
	[IPAddress] [nvarchar](50) NULL,
	[IPv6Address] [nvarchar](50) NULL,
	[MacAddress] [nvarchar](50) NULL,
	[NetworkName] [nvarchar](50) NULL,
	[NicType] [nvarchar](50) NULL,
	[SwitchPort] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[vmInfrastructureHost]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[vmInfrastructureHost](
	[DeviceID] [varchar](50) NULL,
	[vmInfrastructureID] [varchar](50) NOT NULL,
	[vmInstanceUUID] [varchar](50) NOT NULL,
	[Hostname] [varchar](50) NULL,
	[IPAddress] [varchar](50) NULL,
	[PowerState] [varchar](50) NULL,
	[HostState] [varchar](50) NULL,
	[HostVersion] [varchar](50) NULL,
	[CPUCount] [int] NULL,
	[CPUCores] [int] NULL,
	[CPUMhz] [int] NULL,
	[ProductName] [varchar](50) NULL,
	[ProductVersion] [varchar](10) NULL,
	[ProductBuild] [varchar](20) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[vmInfrastructureNetwork]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[vmInfrastructureNetwork](
	[vmInfrastructureID] [nvarchar](50) NULL,
	[vmMoRef] [nvarchar](128) NULL,
	[NetworkName] [nvarchar](50) NULL,
	[SwitchType] [nvarchar](2) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[vmInfrastructureSnapshot]    Script Date: 10-08-2024 10:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[vmInfrastructureSnapshot](
	[vmInfrastructureID] [varchar](50) NOT NULL,
	[vmMoref] [varchar](50) NOT NULL,
	[vmUUID] [varchar](50) NOT NULL,
	[SnapshotName] [varchar](250) NULL,
	[Description] [varchar](250) NULL,
	[CreateTime] [bigint] NULL,
	[vmParentSnapshotMoref] [varchar](50) NULL,
	[State] [varchar](50) NULL,
	[Id] [int] NULL,
	[Size] [bigint] NULL,
	[vmName] [varchar](128) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [_dta_index_AlertEventCol_5_677577452__K2_3]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [_dta_index_AlertEventCol_5_677577452__K2_3] ON [dbo].[AlertEventCol]
(
	[AlertID] ASC
)
INCLUDE([EventID]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [evenitidinx]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [evenitidinx] ON [dbo].[AlertEventCol]
(
	[EventID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [alert]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [alert] ON [dbo].[Alerts]
(
	[alertid] ASC,
	[Device] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [NonClusteredIndex-20171218-233344]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [NonClusteredIndex-20171218-233344] ON [dbo].[Asset_SW_WindowsServices]
(
	[DeviceID] ASC,
	[Name] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [IX_Availability]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [IX_Availability] ON [dbo].[Availability]
(
	[timecollected] ASC,
	[device] ASC,
	[Packetloss] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [cpu]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [cpu] ON [dbo].[CPUperf]
(
	[timecollected] ASC,
	[device] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [devicegroups]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [devicegroups] ON [dbo].[devicegroups]
(
	[id] ASC,
	[description] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [devices]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [devices] ON [dbo].[devices]
(
	[ID] ASC,
	[deviceID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [devicetypes]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [devicetypes] ON [dbo].[DeviceTypes]
(
	[id] ASC,
	[devicetypename] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [_dta_index_events_5_14623095__K8]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [_dta_index_events_5_14623095__K8] ON [dbo].[events]
(
	[severity] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [_dta_index_events_5_1842105603__K1_K4]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [_dta_index_events_5_1842105603__K1_K4] ON [dbo].[events]
(
	[eventid] ASC,
	[timecollected] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [IX_GeoIPCountryWhois]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [IX_GeoIPCountryWhois] ON [dbo].[GeoIPCountryWhois]
(
	[begin_ip] ASC,
	[end_ip] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [ipaddresslocal]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [ipaddresslocal] ON [dbo].[ipaddresslocal]
(
	[id] ASC,
	[ipaddress] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [ipnets]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [ipnets] ON [dbo].[ipnets]
(
	[ipnetID] ASC,
	[description] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [NonClusteredIndex-20180408-103341]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [NonClusteredIndex-20180408-103341] ON [dbo].[LLDP_Interfaces]
(
	[DeviceID] ASC,
	[IfIndex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [logfiles]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [logfiles] ON [dbo].[logfiles]
(
	[id] ASC,
	[logfiletype] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [NonClusteredIndex-20130611-221216]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [NonClusteredIndex-20130611-221216] ON [dbo].[logfiles]
(
	[timecreated] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [mem]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [mem] ON [dbo].[memperf]
(
	[timecollected] ASC,
	[device] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [iipo]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [iipo] ON [dbo].[monitorlist]
(
	[monitorgroupid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [port]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [port] ON [dbo].[PortTypes]
(
	[id] ASC,
	[PortNr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [process]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [process] ON [dbo].[ProcessPerf]
(
	[timecollected] ASC,
	[device] ASC,
	[id] ASC
)
INCLUDE([MemUsage],[PageFileUsage],[VirtualMemUsage]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [jjjjjjjj]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [jjjjjjjj] ON [dbo].[reportfiles]
(
	[ID] ASC,
	[timecollected] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [ljjjjlkj]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [ljjjjlkj] ON [dbo].[ResolutionTypes]
(
	[resolution] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [server]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [server] ON [dbo].[ServerStatistics]
(
	[datetime] ASC,
	[serverid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [jlkj]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [jlkj] ON [dbo].[severitytypes]
(
	[severity] ASC,
	[severityname] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [IX_snmpdata]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [IX_snmpdata] ON [dbo].[snmpdata]
(
	[timecollected] ASC,
	[id] ASC,
	[avgval] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [IX_snmpdata_1]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [IX_snmpdata_1] ON [dbo].[snmpdata]
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [IX_snmpinterfaces]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [IX_snmpinterfaces] ON [dbo].[snmpinterfaces]
(
	[device] ASC,
	[InterfaceType] ASC,
	[nodeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [NonClusteredIndex-20181104-181803]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [NonClusteredIndex-20181104-181803] ON [dbo].[snmpinterfacetraffic]
(
	[interfaceid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [device]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [device] ON [dbo].[snmpmonitors]
(
	[device] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [montype]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [montype] ON [dbo].[snmpmonitors]
(
	[monitortype] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [snmpmonitors]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [snmpmonitors] ON [dbo].[snmpmonitors]
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [Category]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [Category] ON [dbo].[SrcDstForensics]
(
	[Category] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [IX_SrcDstForensicsNew]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [IX_SrcDstForensicsNew] ON [dbo].[SrcDstForensics]
(
	[timecollected] ASC,
	[device] ASC,
	[dstport] ASC,
	[srcip] ASC,
	[protocol] ASC,
	[devicetype] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [Site]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [Site] ON [dbo].[SrcDstForensics]
(
	[Site] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [SiteType]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [SiteType] ON [dbo].[SrcDstForensics]
(
	[SiteType] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [Threatlevel]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [Threatlevel] ON [dbo].[SrcDstForensics]
(
	[ThreatLevel] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [DstPort]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [DstPort] ON [dbo].[SrcDstStats]
(
	[DeviceType] ASC,
	[Protocol] ASC,
	[TimeCollected] ASC
)
INCLUDE([DstPort],[TotalBytes]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [NonClusteredIndex-20171015-090407]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [NonClusteredIndex-20171015-090407] ON [dbo].[SrcDstStats]
(
	[TimeCollected] ASC,
	[Device] ASC,
	[DeviceType] ASC
)
INCLUDE([srcIP],[DstIP],[TotalTime],[Protocol]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [NonClusteredIndex-20191107-230615]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [NonClusteredIndex-20191107-230615] ON [dbo].[SrcDstStats]
(
	[Protocol] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [NonClusteredIndex-20191108-080420]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [NonClusteredIndex-20191108-080420] ON [dbo].[SrcDstStats]
(
	[DstIP] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [NonClusteredIndex-20191110-101510]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [NonClusteredIndex-20191110-101510] ON [dbo].[SrcDstStats]
(
	[DstPort] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [lkk]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [lkk] ON [dbo].[StatisticsToday]
(
	[EventsToday] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [storage]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [storage] ON [dbo].[StoragePerf]
(
	[timecollected] ASC,
	[id] ASC,
	[usedstorage] ASC,
	[freestorage] ASC,
	[device] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [Tags-Index]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [Tags-Index] ON [dbo].[Tags]
(
	[TagID] ASC,
	[TagName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [Tags_DeviceID-Index]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [Tags_DeviceID-Index] ON [dbo].[Tags_DeviceID]
(
	[TagID] ASC,
	[DeviceID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [MonitorID_Index]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [MonitorID_Index] ON [dbo].[Tags_Monitors]
(
	[MonitorID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [TagID_Index]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [TagID_Index] ON [dbo].[Tags_Monitors]
(
	[TagId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [DeviceId_Index]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [DeviceId_Index] ON [dbo].[Tags_NetworkInterfaces]
(
	[DeviceID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [TagID_Index]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [TagID_Index] ON [dbo].[Tags_NetworkInterfaces]
(
	[TagId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [uouoiu]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [uouoiu] ON [dbo].[userroles]
(
	[role] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [uuuu]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [uuuu] ON [dbo].[users]
(
	[UserID] ASC,
	[username] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [Hour]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [Hour] ON [dbo].[ViewHour]
(
	[Hour] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [vmInfrastructureID]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [vmInfrastructureID] ON [dbo].[vmInfrastructureConfiguration]
(
	[vmInfrastructureID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [DeviceID]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [DeviceID] ON [dbo].[vmInfrastructureDevice]
(
	[DeviceID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [vmInfrastructureID]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [vmInfrastructureID] ON [dbo].[vmInfrastructureDevice]
(
	[vmInfrastructureID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [vmInstanceUUID]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [vmInstanceUUID] ON [dbo].[vmInfrastructureDevice]
(
	[vmInstanceUUID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [DeviceID]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [DeviceID] ON [dbo].[vmInfrastructureHost]
(
	[DeviceID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [vmInfrastructureID]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [vmInfrastructureID] ON [dbo].[vmInfrastructureHost]
(
	[vmInfrastructureID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [vmInstanceUUID]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [vmInstanceUUID] ON [dbo].[vmInfrastructureHost]
(
	[vmInstanceUUID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [NonClusteredIndex-20220314-124527]    Script Date: 10-08-2024 10:34:21 ******/
CREATE NONCLUSTERED INDEX [NonClusteredIndex-20220314-124527] ON [dbo].[vmInfrastructureSnapshot]
(
	[vmInfrastructureID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AD_Audit_Connection] ADD  CONSTRAINT [DF_AD_Audit_Connection_ID]  DEFAULT (newid()) FOR [ID]
GO
ALTER TABLE [dbo].[Asset_HW_NetworkDevice] ADD  CONSTRAINT [DF_Asset_HW_NetworkDevice_ID]  DEFAULT (newid()) FOR [ID]
GO
ALTER TABLE [dbo].[Asset_ServiceContract] ADD  CONSTRAINT [DF_Asset_ServiceContract_Id]  DEFAULT (newid()) FOR [Id]
GO
ALTER TABLE [dbo].[Asset_ServiceContract_Vendor] ADD  CONSTRAINT [DF_Asset_ServiceContract_Vendor_VendorID]  DEFAULT (newid()) FOR [VendorID]
GO
ALTER TABLE [dbo].[DeviceToVirtual] ADD  CONSTRAINT [DF_DeviceToVirtual_ID]  DEFAULT (newid()) FOR [ID]
GO
ALTER TABLE [dbo].[snmpinterfaces] ADD  CONSTRAINT [DF_snmpinterfaces_collectstats]  DEFAULT ((0)) FOR [collectstats]
GO
ALTER TABLE [dbo].[snmpinterfacetraffic] ADD  CONSTRAINT [DF_snmpinterfacetraffic_ifInOctets]  DEFAULT ((0)) FOR [ifInOctets]
GO
ALTER TABLE [dbo].[snmpinterfacetraffic] ADD  CONSTRAINT [DF_snmpinterfacetraffic_ifInbps]  DEFAULT ((0)) FOR [ifInbps]
GO
ALTER TABLE [dbo].[snmpinterfacetraffic] ADD  CONSTRAINT [DF_snmpinterfacetraffic_ifOutOctets]  DEFAULT ((0)) FOR [ifOutOctets]
GO
ALTER TABLE [dbo].[snmpinterfacetraffic] ADD  CONSTRAINT [DF_snmpinterfacetraffic_ifOutbps]  DEFAULT ((0)) FOR [ifOutbps]
GO
ALTER TABLE [dbo].[snmpinterfacetraffic] ADD  CONSTRAINT [DF_snmpinterfacetraffic_ifInUcastPkts]  DEFAULT ((0)) FOR [ifInUcastPkts]
GO
ALTER TABLE [dbo].[snmpinterfacetraffic] ADD  CONSTRAINT [DF_snmpinterfacetraffic_ifInNUcastPkts]  DEFAULT ((0)) FOR [ifInNUcastPkts]
GO
ALTER TABLE [dbo].[snmpinterfacetraffic] ADD  CONSTRAINT [DF_snmpinterfacetraffic_ifInDiscards]  DEFAULT ((0)) FOR [ifInDiscards]
GO
ALTER TABLE [dbo].[snmpinterfacetraffic] ADD  CONSTRAINT [DF_snmpinterfacetraffic_ifInErrors]  DEFAULT ((0)) FOR [ifInErrors]
GO
ALTER TABLE [dbo].[snmpinterfacetraffic] ADD  CONSTRAINT [DF_snmpinterfacetraffic_ifInUnknownProtos]  DEFAULT ((0)) FOR [ifInUnknownProtos]
GO
ALTER TABLE [dbo].[snmpinterfacetraffic] ADD  CONSTRAINT [DF_snmpinterfacetraffic_ifOutUcastPkts]  DEFAULT ((0)) FOR [ifOutUcastPkts]
GO
ALTER TABLE [dbo].[snmpinterfacetraffic] ADD  CONSTRAINT [DF_snmpinterfacetraffic_ifOutNUcastPkts]  DEFAULT ((0)) FOR [ifOutNUcastPkts]
GO
ALTER TABLE [dbo].[snmpinterfacetraffic] ADD  CONSTRAINT [DF_snmpinterfacetraffic_ifOutDiscards]  DEFAULT ((0)) FOR [ifOutDiscards]
GO
ALTER TABLE [dbo].[snmpinterfacetraffic] ADD  CONSTRAINT [DF_snmpinterfacetraffic_ifOutErrors]  DEFAULT ((0)) FOR [ifOutErrors]
GO
ALTER TABLE [dbo].[snmpinterfacetraffic] ADD  CONSTRAINT [DF_snmpinterfacetraffic_ifOutQLen]  DEFAULT ((0)) FOR [ifOutQLen]
GO
ALTER TABLE [dbo].[snmpinterfacetraffic] ADD  CONSTRAINT [DF_snmpinterfacetraffic_loss]  DEFAULT ((0)) FOR [loss]
GO
ALTER TABLE [dbo].[SrcDstForensics] ADD  CONSTRAINT [DF_SrcDstForensicsNew_ID]  DEFAULT (newid()) FOR [ID]
GO
ALTER TABLE [dbo].[SrcDstStats] ADD  CONSTRAINT [DF_SrcDstStats_ID]  DEFAULT (newid()) FOR [ID]
GO
ALTER TABLE [dbo].[SrcDstStats] ADD  CONSTRAINT [DF_SrcDstStats_SiteType]  DEFAULT (NULL) FOR [SiteType]
GO
ALTER TABLE [dbo].[SrcDstStats] ADD  CONSTRAINT [DF_SrcDstStats_Site]  DEFAULT (NULL) FOR [Site]
GO
ALTER TABLE [dbo].[SrcDstStats] ADD  CONSTRAINT [DF_SrcDstStats_Category]  DEFAULT (NULL) FOR [Category]
GO
ALTER TABLE [dbo].[SrcDstStats] ADD  CONSTRAINT [DF_SrcDstStats_ThreatLevel]  DEFAULT (NULL) FOR [ThreatLevel]
GO
ALTER TABLE [dbo].[StatisticsToday] ADD  CONSTRAINT [DF_StatisticsToday_EventsToday]  DEFAULT ((0)) FOR [EventsToday]
GO
ALTER TABLE [dbo].[StatisticsToday] ADD  CONSTRAINT [DF_StatisticsToday_ForensicsToday]  DEFAULT ((0)) FOR [ForensicsToday]
GO
ALTER TABLE [dbo].[StatisticsToday] ADD  CONSTRAINT [DF_StatisticsToday_StatisticsToday]  DEFAULT ((0)) FOR [StatisticsToday]
GO
ALTER TABLE [dbo].[StatisticsToday] ADD  CONSTRAINT [DF_StatisticsToday_AlertsToday]  DEFAULT ((0)) FOR [AlertsToday]
GO
ALTER TABLE [dbo].[StatisticsToday] ADD  CONSTRAINT [DF_StatisticsToday_ClosedAlertsToday]  DEFAULT ((0)) FOR [ClosedAlertsToday]
GO
ALTER TABLE [dbo].[StatisticsToday] ADD  CONSTRAINT [DF_StatisticsToday_OpenAlerts]  DEFAULT ((0)) FOR [OpenAlerts]
GO
ALTER TABLE [dbo].[StatisticsToday] ADD  CONSTRAINT [DF_StatisticsToday_TotalEventsToday]  DEFAULT ((0)) FOR [TotalEventsToday]
GO
ALTER TABLE [dbo].[StatisticsToday] ADD  CONSTRAINT [DF_StatisticsToday_SevEmergencyToday]  DEFAULT ((0)) FOR [SevEmergencyToday]
GO
ALTER TABLE [dbo].[StatisticsToday] ADD  CONSTRAINT [DF_StatisticsToday_SevAlertsToday]  DEFAULT ((0)) FOR [SevAlertsToday]
GO
ALTER TABLE [dbo].[StatisticsToday] ADD  CONSTRAINT [DF_StatisticsToday_SevCriticalToday]  DEFAULT ((0)) FOR [SevCriticalToday]
GO
ALTER TABLE [dbo].[StatisticsToday] ADD  CONSTRAINT [DF_StatisticsToday_SevErrorToday]  DEFAULT ((0)) FOR [SevErrorToday]
GO
ALTER TABLE [dbo].[StatisticsToday] ADD  CONSTRAINT [DF_StatisticsToday_SevWarningToday]  DEFAULT ((0)) FOR [SevWarningToday]
GO
ALTER TABLE [dbo].[StatisticsToday] ADD  CONSTRAINT [DF_StatisticsToday_SevNotificationToday]  DEFAULT ((0)) FOR [SevNotificationToday]
GO
ALTER TABLE [dbo].[StatisticsToday] ADD  CONSTRAINT [DF_StatisticsToday_SevInformationalToday]  DEFAULT ((0)) FOR [SevInformationalToday]
GO
ALTER TABLE [dbo].[StatisticsToday] ADD  CONSTRAINT [DF_StatisticsToday_SevDebugToday]  DEFAULT ((0)) FOR [SevDebugToday]
GO
ALTER TABLE [dbo].[StatisticsToday] ADD  CONSTRAINT [DF_StatisticsToday_TotalSNMPDevices]  DEFAULT ((0)) FOR [TotalSNMPDevices]
GO
ALTER TABLE [dbo].[StatisticsToday] ADD  CONSTRAINT [DF_StatisticsToday_TotalDevices]  DEFAULT ((0)) FOR [TotalDevices]
GO
ALTER TABLE [dbo].[StatisticsToday] ADD  CONSTRAINT [DF_StatisticsToday_TotalDevicesToday]  DEFAULT ((0)) FOR [TotalDevicesToday]
GO
ALTER TABLE [dbo].[StatisticsToday] ADD  CONSTRAINT [DF_StatisticsToday_TotalSNMPDevicesToday]  DEFAULT ((0)) FOR [TotalSNMPDevicesToday]
GO
ALTER TABLE [dbo].[Tags] ADD  CONSTRAINT [DF_Tags_TagID]  DEFAULT (newid()) FOR [TagID]
GO
USE [master]
GO
ALTER DATABASE [logging2006] SET  READ_WRITE 
GO