akanieski

select 
  count(1) as KeyCount, 
  id.DisplayName, 
  id.MailAddress 
from 
  [dbo].[tbl_DelegatedAuthorizationAccessKey] as k 
  left join [dbo].[tbl_Identity] as id on k.IdentityId = id.Id 
where 
  k.IsPublic = 1 
group by 

akanieski

{
    "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
    "contentVersion": "1.0.0.0",
    "parameters": {
        "workflows_AAD_DC_Sample_name": {
            "defaultValue": "AAD-DC-Sample",
            "type": "String"
        }
    },
    "variables": {},

akanieski

// Auto-Generated - Do not edit 
using System; 
namespace ADO.ObjectModel.Permissions 
{ 
    public enum Analytics : int 
{
        Read = 1,
        Administer = 2,
        Stage = 4,
        ExecuteUnrestrictedQuery = 8,

akanieski

using Microsoft.TeamFoundation.Client;
using Microsoft.TeamFoundation.Framework.Client;
using Microsoft.TeamFoundation.Framework.Common;
using Microsoft.TeamFoundation.Git.Client;
using Microsoft.VisualStudio.Services.Security.Client;
using Microsoft.VisualStudio.Services.Common;
using Microsoft.TeamFoundation.Build.WebApi;
using Microsoft.VisualStudio.Services.ReleaseManagement.WebApi.Clients;
using System;
using System.Collections.Generic;

akanieski

DECLARE @minSizeInMb INTEGER = 0;

SELECT ProjectName
	,SUBSTRING(_filePath, 1, LEN(_filePath) - 1) AS FilePath
	,ChangeSet
	,SizeInMB
	,CommittedBy
	,CommittedByEmail
	,CommitDate
FROM (

akanieski

<#
.NOTES
    Written by Andrew Kanieski under the GNU GPLv3 license found at https://www.gnu.org/licenses/

.SYNOPSIS
    Given a list of GitHub users to scan, this script will pull all their public 
    gists and search them for suspicious strings that look like Azure DevOps or GitHub
    personal access tokens. If found it will cross reference them against GitHub and/or
    a list of provided Azure DevOps organizations.

akanieski

# These are just here for testing 
$pat = "q567g7tabpia63eq5dmrqdpcet6z3rwg6futjc2wlhqgiysrjcua"

akanieski

param (
    [string]$Token = "",
    [string]$OrgUrl = "",
    [switch]$Quiet = $false,
    [string]$MinVersion = ""
)

function Split-VersionString{
    param (
        [string]$versionString

akanieski

use [Tfs_Configuration]

SELECT 
	id.DisplayName as 'KeyOwner',
	access_key.DisplayName as 'KeyName',
	meta.ValidFrom as 'CreatedAt',
	meta.ValidTo as 'ExpiresAt'
FROM dbo.tbl_DelegatedAuthorizationAccessKey as access_key
  left join dbo.tbl_Identity id on id.Id = access_key.IdentityId
  left join dbo.tbl_DelegatedAuthorizationAccess meta on meta.AccessId = access_key.AccessId

akanieski

TfsConfig purgelocalversions /collection:<name> /days:<number>
    Configures the purgelocalversions job for the given
    collection. All workspaces that haven't been used in
    <days> will have their local versions purged.

TfsConfig purgelocalversions /collection:<name> /execute
    Immediately queues the purgelocalversions job to run
    for this collection.

TfsConfig purgelocalversions /collection:<name> /disable