TomerAdmon

require 'octokit'
require 'csv'
require 'date'

# Export Issue list from GitHub in a CSV form. 
# mistone will be taken from the milestone column or will set to tentative is such label exist.
# the labels bug, technical, test plan needed and test plan ready will be set in the type column.

#GitHub credentials
USERNAME="USER"

TomerAdmon

##$secpasswd = ConvertTo-SecureString “PASSWORD” -AsPlainText -Force
##$mycreds = New-Object System.Management.Automation.PSCredential (“USERNAME”, $secpasswd)

$TEAMCITY_URL = "http://tc"
$FEATURE_NAME = "jetbrains.agent.free.space"
$mycreds = Get-Credential

$builds = [xml](Invoke-RestMethod -Method Get ($TEAMCITY_URL + "/httpAuth/app/rest/buildTypes") -Credential $mycreds)
foreach ($build in $builds.buildTypes.buildType)
{

TomerAdmon

$TEAMCITY_URL = "http://tc"

##$secpasswd = ConvertTo-SecureString “PASSWORD” -AsPlainText -Force
##$mycreds = New-Object System.Management.Automation.PSCredential (“USERNAME”, $secpasswd)

$mycreds = Get-Credential

$builds = [xml](Invoke-RestMethod -Method Get ($TEAMCITY_URL + "/httpAuth/app/rest/buildTypes") -Credential $mycreds)
foreach ($build in $builds.buildTypes.buildType)

TomerAdmon

$TEAMCITY_URL = "http://tc"
$BUILD_TYPE = "BuildType"

##$secpasswd = ConvertTo-SecureString “PASSWORD” -AsPlainText -Force
##$mycreds = New-Object System.Management.Automation.PSCredential (“USERNAME”, $secpasswd)
$mycreds = Get-Credential

$builds = [xml](Invoke-RestMethod -Method Get ($TEAMCITY_URL + "/httpAuth/app/rest/buildTypes/id:" + $BUILD_TYPE + "/builds/?locator=count:1000000") -Credential $mycreds)

TomerAdmon

$TEAMCITY_URL = "http://tc"
$AGENT_REQUIREMENT = "DotNetFramework4.5_x86"

#$secpasswd = ConvertTo-SecureString “PASSWORD” -AsPlainText -Force
#$mycreds = New-Object System.Management.Automation.PSCredential (“USERNAME”, $secpasswd)

mycreds = Get-Credential

$builds = [xml](Invoke-RestMethod -Method Get ($TEAMCITY_URL + "/httpAuth/app/rest/buildTypes") -Credential $mycreds)

TomerAdmon

$FOLDER_NAME = "DownlodedFiles"
$TEAM_CITY = 'http://TC'
$BUILD_TYPE_ID = "Trunk_Ci_FastCi_Build"
$FILES_TO_DOWNLOAD = ".zip"

$folderName = (".\" + $FOLDER_NAME)
If (Test-Path $folderName){
	Remove-Item $folderName
}

TomerAdmon

declare
    @cols nvarchar(max),
       @sele nvarchar(max),
    @stmt nvarchar(max)

select @cols = isnull(@cols + ', ', '') + '[' + T.ReleasedVersion + ']' from (select distinct ReleasedVersion from DriversAndLibraries Where ReleasedVersion <> '') as T
select @sele = isnull(@sele + ', ', '') + 'max([' + T.ReleasedVersion + ']) AS ' + '[' + T.ReleasedVersion + ']'  from (select distinct ReleasedVersion from DriversAndLibraries Where ReleasedVersion <> '') as T
PRINT @sele

select @stmt = '

TomerAdmon

<!--
     Hi, 
     This is a TeamCity meta-runner that can be added to any TeamCity server for retry a command line task till success.
     This meta-runner come usuful with command line utilities line npm where we see unstableness from time to time.
     This meta-runner will get only two parameter by default: the command and the working directory to run the commnad from.
     The code will then retry the command from 3 times till exit-code of 0 is reached.
-->
<?xml version="1.0" encoding="UTF-8"?>
<meta-runner name="RetryCommandLine">
  <description>TeamCity custom Meta-Runner that uses PowerShell to retry a command line action till success</description>

TomerAdmon

$user_names = "My User", "Another User"
$search_since = "2017-03-01"

$global:zendesk_user_name = "username"
$global:zendesk_password = "password"
$global:zendesk_address = "zendesk_address"

function CreateAuthorizationHeader()
{
    $pair = "$($zendesk_user_name):$($zendesk_password)"

TomerAdmon

sudo yum install httpd -y
sudo systemctl enable httpd.service
sudo systemctl restart httpd.service