Skip to content

Instantly share code, notes, and snippets.

@vinijmoura

vinijmoura/LatestBuilds.sql

Created October 27, 2021 21:36
Show Gist options
  • Save vinijmoura/1213a32b4cb8b29a806ecbba703d5e07 to your computer and use it in GitHub Desktop.
Save vinijmoura/1213a32b4cb8b29a806ecbba703d5e07 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
LatestBuilds.sql
CREATE TABLE [dbo].[LatestBuilds](
[TeamProjectName] [varchar](100) NULL,
[BuildDefinitionId] [varchar](40) NULL,
[BuildDefinitionName] [varchar](150) NULL,
[BuildNumber] [varchar](100) NULL,
[BuildResult] [varchar](50) NULL,
[BuildReason] [varchar](50) NULL,
[BuildRequestedFor] [varchar](100) NULL,
[BuildRepository] [varchar](100) NULL,
[BuildSourceBranch] [varchar](100) NULL,
[BuildCommit] [varchar](10) NULL,
[BuildStartTime] [datetime] NULL,
[BuildTime] [int] NULL,
[BuildLink] [nvarchar](MAX) null
)
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment