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 / FeedsAndVersions.ps1
Created April 14, 2021 12:33
Param
(
[string]$PAT,
[string]$Organization,
[string]$Connstr
)
$SQLQuery = "TRUNCATE TABLE FeedPackageVersions"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr
@vinijmoura
vinijmoura / FeedPackageVersions.sql
Created April 14, 2021 12:37
CREATE TABLE [dbo].[FeedPackageVersions](
[FeedName] [varchar](100) NULL,
[FeedDescription] [nvarchar](max) NULL,
[FeedPackageName] [varchar](100) NULL,
[FeedPackageType] [varchar](30) NULL,
[FeedPackageSource] [varchar](30) NULL,
[FeedPackageVersion] [varchar](50) NULL,
[FeedPackageVersionLatest] [bit] NULL,
[FeedPackageVersionDate] [datetime] NULL,
[FeedPackageVersionDownloadCount] [int] NULL,
@vinijmoura
vinijmoura / ListUsersGroupsAndGitPermissions.ps1
Created April 27, 2021 12:14
Param
(
[string]$PAT,
[string]$Organization,
[string]$ProjectName,
[string]$mailAddress,
[string]$Connstr
)
@vinijmoura
vinijmoura / GitRepositoriesPermissions.sql
Last active April 27, 2021 12:27
CREATE TABLE [dbo].[GitRepositoriesPermissions](
[TeamProjectName] [varchar](100) NULL,
[RepoName] [varchar](100) NULL,
[SecurityNameSpace] [varchar](100) NULL,
[UserPrincipalName] [varchar](100) NULL,
[UserDisplayName] [varchar](100) NULL,
[GroupDisplayName] [varchar](200) NULL,
[GroupAccountName] [varchar](200) NULL,
[GitCommandName] [varchar](100) NULL,
[GitCommandInternalName] [varchar](100) NULL,
@vinijmoura
vinijmoura / ListUsersGroupsAndPipelinePermissions.ps1
Created April 29, 2021 17:21
Param
(
[string]$PAT,
[string]$Organization,
[string]$ProjectName,
[string]$mailAddress,
[string]$Connstr
)
@vinijmoura
vinijmoura / PipelinePermissions.sql
Last active April 29, 2021 17:47
CREATE TABLE [dbo].[PipelinePermissions](
[TeamProjectName] [varchar](100) NULL,
[RepoName] [varchar](100) NULL,
[SecurityNameSpace] [varchar](100) NULL,
[UserPrincipalName] [varchar](100) NULL,
[UserDisplayName] [varchar](100) NULL,
[GroupDisplayName] [varchar](200) NULL,
[GroupAccountName] [varchar](200) NULL,
[PipelineCommandName] [varchar](100) NULL,
[PipelineCommandInternalName] [varchar](100) NULL,
@vinijmoura
vinijmoura / ListUsersGroupsAndProjectLevelPermissions.ps1
Created May 2, 2021 20:17
Param
(
[string]$PAT,
[string]$Organization,
[string]$ProjectName,
[string]$mailAddress,
[string]$Connstr
)
@vinijmoura
vinijmoura / ProjectLevelPermissions.sql
Created May 2, 2021 20:20
CREATE TABLE [dbo].[ProjectLevelPermissions](
[TeamProjectName] [varchar](100) NULL,
[SecurityNameSpace] [varchar](100) NULL,
[UserPrincipalName] [varchar](100) NULL,
[UserDisplayName] [varchar](100) NULL,
[GroupDisplayName] [varchar](200) NULL,
[GroupAccountName] [varchar](200) NULL,
[ProjectLevelType] [varchar](50) NULL,
[ProjectLevelCommandName] [varchar](100) NULL,
[ProjectLevelCommandInternalName] [varchar](100) NULL,
@vinijmoura
vinijmoura / ListUsersGroupsAndOrganizationLevelPermissions.ps1
Created May 5, 2021 19:04
Param
(
[string]$PAT,
[string]$Organization,
[string]$mailAddress,
[string]$Connstr
)
$SQLQuery = "TRUNCATE TABLE OrganizationLevelPermissions"
@vinijmoura
vinijmoura / OrganizationLevelPermissions.sql
Created May 5, 2021 19:07
CREATE TABLE [dbo].[OrganizationLevelPermissions](
[SecurityNameSpace] [varchar](100) NULL,
[UserPrincipalName] [varchar](100) NULL,
[UserDisplayName] [varchar](100) NULL,
[GroupDisplayName] [varchar](200) NULL,
[GroupAccountName] [varchar](200) NULL,
[OrganizationLevelType] [varchar](50) NULL,
[OrganizationLevelCommandName] [varchar](100) NULL,
[OrganizationLevelCommandInternalName] [varchar](100) NULL,
[OrganizationLevelCommandPermission] [varchar](50) NULL