Skip to content

Instantly share code, notes, and snippets.

View vinijmoura's full-sized avatar

Vinicius Moura vinijmoura

323 followers · 18 following
View GitHub Profile
@vinijmoura
vinijmoura / ReleaseDefinitionsTasks.sql
Created October 20, 2021 20:26
CREATE TABLE [dbo].[ReleaseDefinitionsTasks](
[TeamProjectName] [varchar](100) NULL,
[ReleaseDefinitionId] [varchar](40) NULL,
[ReleaseDefinitionName] [varchar](150) NULL,
[ReleaseDefinitionEnvironmentName] [varchar](150) NULL,
[ReleaseDefinitionPhaseName] [varchar](150) NULL,
[ReleaseDefintionTaskId] [varchar](40) NULL,
[ReleaseDefintionTaskName] [varchar](150) NULL,
[ReleaseDefintionTaskversion] [varchar](30) NULL
)
@vinijmoura
vinijmoura / ReleaseDefinitionsTasks.ps1
Created October 20, 2021 20:24
Param
(
[string]$PAT,
[string]$Organization,
[string]$Connstr
)
$SQLQuery = "TRUNCATE TABLE ReleaseDefinitionsTasks"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr
@vinijmoura
vinijmoura / BuildDefinitionsTasks.sql
Created October 14, 2021 18:55
CREATE TABLE [dbo].[BuildDefinitionsTasks](
[TeamProjectName] [varchar](100) NULL,
[BuildDefinitionId] [varchar](40) NULL,
[BuildDefinitionName] [varchar](150) NULL,
[BuildDefinitionPhaseName] [varchar](150) NULL,
[BuildDefintionTaskId] [varchar](40) NULL,
[BuildDefintionTaskName] [varchar](150) NULL,
[BuildDefintionTaskversionSpec] [varchar](30) NULL
)
GO
@vinijmoura
vinijmoura / BuildDefinitionsTasks.ps1
Created October 14, 2021 18:53
Param
(
[string]$PAT,
[string]$Organization,
[string]$Connstr
)
$SQLQuery = "TRUNCATE TABLE BuildDefinitionsTasks"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr
@vinijmoura
vinijmoura / ServiceHooks.sql
Created October 6, 2021 22:41
CREATE TABLE [dbo].[ServiceHooks](
[ProjectName] [varchar](200) NULL,
[eventDescription] [nvarchar](max) NULL,
[eventType] [varchar](100) NULL,
[publisherId] [varchar](200) NULL,
[consumerId] [varchar](200) NULL,
[consumerActionId] [nvarchar](max) NULL,
[actionDescription] [nvarchar](max) NULL,
[createdBy] [varchar](100) NULL
)
@vinijmoura
vinijmoura / MapServiceHooks.ps1
Created October 6, 2021 22:40
Param
(
[string]$PAT,
[string]$Organization,
[string]$Connstr
)
$SQLQuery = "TRUNCATE TABLE ServiceHooks"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr
@vinijmoura
vinijmoura / PersonalAccessTokens.sql
Created September 29, 2021 22:00
CREATE TABLE [dbo].[PersonalAccessTokens](
[UserDisplayName] [varchar](200) NULL,
[UserMailAddress] [varchar](200) NULL,
[PATDisplayName] [varchar](200) NULL,
[PATValidFrom] [DATETIME] NULL,
[PATValidTo] [DATETIME] NULL,
[PATScope] [nvarchar](MAX) NULL
)
GO
@vinijmoura
vinijmoura / MapPersonalAccessTokens.ps1
Created September 29, 2021 21:59
Param
(
[string]$PAT,
[string]$Organization,
[string]$Connstr
)
$SQLQuery = "TRUNCATE TABLE PersonalAccessTokens"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr
@vinijmoura
vinijmoura / ProjectStats.sql
Last active September 22, 2021 22:51
CREATE TABLE [dbo].[ProjectStats](
[TeamProjectName] [varchar](200) NOT NULL,
[TeamProjectCountWorkItemCreated] [smallint] NOT NULL,
[TeamProjectCountWorkItemCompleted] [smallint] NOT NULL,
[TeamProjectCountCommitsPushed] [smallint] NOT NULL,
[TeamProjectCountPRsCreated] [smallint] NOT NULL,
[TeamProjectCountPRsCompleted] [smallint] NOT NULL,
[TeamProjectCountBuilds] [smallint] NOT NULL,
[TeamProjectCountReleases] [smallint] NOT NULL
)
@vinijmoura
vinijmoura / MapProjectStats.ps1
Created September 22, 2021 22:50
Param
(
[string]$PAT,
[string]$Organization,
[string]$Connstr
)
$SQLQuery = "TRUNCATE TABLE ProjectStats"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr