AppCode Index table for BMC Discovery CMDB export for PowerBI

[hudatolah]

Code: Select all

/****** Object:  Table [dbo].[AppCode_Index]    Script Date: 6/29/2022 11:50:38 AM ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AppCode_Index]') AND type in (N'U'))
DROP TABLE [dbo].[AppCode_Index]
GO

/****** Object:  Table [dbo].[AppCode_Index]    Script Date: 6/29/2022 11:50:38 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[AppCode_Index](
	[Request_ID] [nvarchar](15) NOT NULL,
	[Submitter] [nvarchar](254) NULL,
	[Create_Date] [int] NULL,
	[Assigned_To] [nvarchar](254) NULL,
	[Last_Modified_By] [nvarchar](254) NOT NULL,
	[Modified_Date] [int] NULL,
	[Status] [int] NOT NULL,
	[Short_Description] [nvarchar](254) NOT NULL,
	[AppCode] [nvarchar](5) NULL,
	[ApplicationName] [nvarchar](255) NULL,
	[ForeignKeyReferenceSGAppIndex] [nvarchar](15) NULL,
	[CMDBInstanceID] [nvarchar](38) NULL,
	[SourceNotes] [nvarchar](255) NULL,
	[ReconciliationIdentity] [nvarchar](38) NULL,
 CONSTRAINT [pk_AppCode_Index] PRIMARY KEY CLUSTERED 
(
	[Request_ID] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO