Skip to content

Instantly share code, notes, and snippets.

View vinijmoura's full-sized avatar

Vinicius Moura vinijmoura

324 followers · 18 following
View GitHub Profile
@vinijmoura
vinijmoura / ListUsersGroupsAndAreaPermissions.ps1
Last active May 12, 2021 23:41
Param
(
[string]$PAT,
[string]$Organization,
[string]$ProjectName,
[string]$mailAddress,
[string]$Connstr
)
Function get-Identifier ($children,[ref]$AllAreaPaths)
@vinijmoura
vinijmoura / AreaPermissions.sql
Created May 10, 2021 20:45
CREATE TABLE [dbo].[AreaPermissions](
[TeamProjectName] [varchar](100) NULL,
[AreaPathName] [varchar](150) NULL,
[SecurityNameSpace] [varchar](100) NULL,
[UserPrincipalName] [varchar](100) NULL,
[UserDisplayName] [varchar](100) NULL,
[GroupDisplayName] [varchar](200) NULL,
[GroupAccountName] [varchar](200) NULL,
[AreaCommandName] [varchar](100) NULL,
[AreaCommandInternalName] [varchar](100) NULL,
@vinijmoura
vinijmoura / ListUsersGroupsAndIterationPermissions.ps1
Created May 13, 2021 01:53
Param
(
[string]$PAT,
[string]$Organization,
[string]$ProjectName,
[string]$mailAddress,
[string]$Connstr
)
Function get-Identifier ($children,[ref]$AllIterationPaths)
@vinijmoura
vinijmoura / IterationPermissions.sql
Created May 13, 2021 01:55
CREATE TABLE [dbo].[IterationPermissions](
[TeamProjectName] [varchar](100) NULL,
[IterationPathName] [varchar](150) NULL,
[SecurityNameSpace] [varchar](100) NULL,
[UserPrincipalName] [varchar](100) NULL,
[UserDisplayName] [varchar](100) NULL,
[GroupDisplayName] [varchar](200) NULL,
[GroupAccountName] [varchar](200) NULL,
[IterationCommandName] [varchar](100) NULL,
[IterationCommandInternalName] [varchar](100) NULL,
@vinijmoura
vinijmoura / ListVariableGroups.ps1
Created June 1, 2021 22:01
Param
(
[string]$PAT,
[string]$Organization,
[string]$Connstr
)
$SQLQuery = "TRUNCATE TABLE VariableGroups"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr
@vinijmoura
vinijmoura / VariableGroups.sql
Created June 1, 2021 22:06
CREATE TABLE [dbo].[VariableGroups](
[TeamProjectName] [varchar](100) NULL,
[VariableGroupName] [varchar](150) NULL,
[VariableGroupType] [varchar](50) NULL,
[VariableGroupKeyVaultName] [varchar](100) NULL,
[VariableGroupVariableName] [varchar](100) NULL,
[VariableGroupVariableValue] [nvarchar](MAX) NULL
) ON [PRIMARY]
GO
@vinijmoura
vinijmoura / ListEnvironmentsDeploys.ps1
Created June 7, 2021 18:14
Param
(
[string]$PAT,
[string]$Organization,
[string]$Connstr
)
$SQLQuery = "TRUNCATE TABLE EnvironmentsDeploys"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr
@vinijmoura
vinijmoura / EnvironmentsDeploys.sql
Created June 7, 2021 18:15
CREATE TABLE [dbo].[EnvironmentsDeploys](
[TeamProjectName] [varchar](100) NULL,
[EnvironmentId] [int] NULL,
[EnvironmentName] [varchar](150) NULL,
[EnvironmentDeployDefinitionName] [varchar](100) NULL,
[EnvironmentDeployStageName] [varchar](150) NULL,
[EnvironmentDeployJobName] [varchar](150) NULL,
[EnvironmentDeployResult] [varchar](50) NULL,
[EnvironmentDeployQueueTime] [datetime] NULL,
[EnvironmentDeployStartTime] [datetime] NULL,
@vinijmoura
vinijmoura / ListTaskGroups.ps1
Created June 14, 2021 14:07
Param
(
[string]$PAT,
[string]$Organization,
[string]$Connstr
)
$SQLQuery = "TRUNCATE TABLE TaskGroups"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr
@vinijmoura
vinijmoura / TaskGroups.sql
Created June 14, 2021 14:09
CREATE TABLE [dbo].[TaskGroups](
[TeamProjectName] [varchar](100) NULL,
[TaskGroupId] [varchar](40) NULL,
[TaskGroupName] [varchar](150) NULL,
[TaskGroupIconURL] [nvarchar](max) NULL,
[TaskGroupVersion] [varchar](30) NULL,
[TaskGroupCategory] [varchar](30) NULL,
[TaskGroupTaskDisplayName] [varchar](150) NULL,
[TaskGroupTaskReferenceId] [varchar](40) NULL,
[TaskGroupTaskVersionSpec] [varchar](30) NULL,