Skip to content

Instantly share code, notes, and snippets.

View vinijmoura's full-sized avatar

Vinicius Moura vinijmoura

346 followers · 18 following
View GitHub Profile
@vinijmoura
vinijmoura / MapSecrets.ps1
Created February 2, 2022 00:30
Param
(
[string]$PAT,
[string]$Organization,
[string]$Connstr
)
$base64Token = [System.Convert]::ToBase64String([char[]]$PAT)
$headers = @{Authorization = 'Basic {0}' -f $base64Token};
$UriOrganization = "https://api.github.com/orgs/$($organization)"
@vinijmoura
vinijmoura / ProjectsPickLists.sql
Created January 12, 2022 19:07
CREATE TABLE [dbo].[ProjectsPickLists](
[TeamProjectId] [VARCHAR](40) NOT NULL,
[TeamProjectName] [VARCHAR](200) NOT NULL,
[FieldName] [VARCHAR](100) NOT NULL,
[FieldReferenceName] [VARCHAR](100) NOT NULL,
[FieldType] [VARCHAR](30) NOT NULL,
[FieldPickListId] [VARCHAR](40) NOT NULL,
[FieldPickListItems] NVARCHAR(MAX) NOT NULL
)
GO
@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