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 / MapProjectsPickLists.ps1
Created January 12, 2022 19:01
Param
(
[string]$PAT,
[string]$Organization,
[string]$Connstr
)
$SQLQuery = "TRUNCATE TABLE ProjectsPickLists"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr
@vinijmoura
vinijmoura / ImportWIS.ps1
Created December 2, 2021 03:25
Param
(
[string]$PAT,
[string]$Organization
)
#connect Azure DevOps
echo $PAT | az devops login --org $Organization
az devops configure --defaults organization=$Organization
#Read File
@vinijmoura
vinijmoura / AzureReposHealthCheck.sql
Created November 22, 2021 22:44
CREATE TABLE [dbo].[Projects](
[TeamProjectId] VARCHAR(100) NOT NULL,
[TeamProjectName] VARCHAR(100) NOT NULL,
CONSTRAINT [PK_Projects] PRIMARY KEY CLUSTERED
(
[TeamProjectId] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
@vinijmoura
vinijmoura / AzureReposHealthCheck.ps1
Created November 22, 2021 22:41
Param
(
[string]$PAT,
[string]$Organization,
[string]$Connstr
)
$SQLQuery = "DELETE FROM RepositoriesAheadBehind"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr
@vinijmoura
vinijmoura / ProcessesWorkItemsRules.sql
Created November 11, 2021 16:49
CREATE TABLE [dbo].[ProcessesWorkItemsRules](
[ProcessName] [varchar](100) NULL,
[ProcessWorkItemTypeName] [varchar](100) NULL,
[ProcessWorkItemTypeRuleName] [varchar](100) NULL,
[ProcessWorkItemTypeRuleConditionsTypes] [nvarchar](MAX) NULL,
[ProcessWorkItemTypeRuleConditionsFields] [nvarchar](MAX) NULL,
[ProcessWorkItemTypeRuleConditionsValues] [nvarchar](MAX) NULL,
[ProcessWorkItemTypeRuleActionsTypes] [nvarchar](MAX) NULL,
[ProcessWorkItemTypeRuleActionsTargetFields] [nvarchar](MAX) NULL,
[ProcessWorkItemTypeRuleActionsValues] [nvarchar](MAX) NULL
@vinijmoura
vinijmoura / MapProcessWorkItemsAndRules.ps1
Created November 11, 2021 16:46
Param
(
[string]$PAT,
[string]$Organization,
[string]$Connstr
)
$SQLQuery = "TRUNCATE TABLE ProcessesWorkItemsRules"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr
@vinijmoura
vinijmoura / LatestReleases.sql
Created November 3, 2021 17:47
CREATE TABLE [dbo].[LatestReleases](
[TeamProjectName] [varchar](100) NULL,
[ReleaseDefinitionId] [varchar](40) NULL,
[ReleaseDefinitionName] [varchar](150) NULL,
[ReleaseNumber] [varchar](100) NULL,
[ReleaseCreatedOn] [datetime] NULL,
[ReleaseLink] [nvarchar](MAX) NULL,
[ReleaseEnvironmentName] [varchar](150) NULL,
[ReleaseEnvironmentResult] [varchar](50) NULL,
[ReleaseEnvironmentReason] [varchar](50) NULL,
@vinijmoura
vinijmoura / LatestReleases.ps1
Created November 3, 2021 17:45
Param
(
[string]$PAT,
[string]$Organization,
[string]$Connstr
)
$SQLQuery = "TRUNCATE TABLE LatestReleases"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr
@vinijmoura
vinijmoura / LatestBuilds.sql
Created October 27, 2021 21:36
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,
@vinijmoura
vinijmoura / LatestBuilds.ps1
Created October 27, 2021 21:34
Param
(
[string]$PAT,
[string]$Organization,
[string]$Connstr
)
$SQLQuery = "TRUNCATE TABLE LatestBuilds"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr