Martin Miles MartinMiles
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Invoke-Sqlcmd -ServerInstance "." ` | |
| -Username "sa" ` | |
| -Password "SA_PASSWORD" ` | |
| -Query "SELECT GETDATE() AS TimeOfQuery" |
MartinMiles
/ StringReplace-ConfigLine.ps1
Created
April 1, 2019 17:54
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| (Get-Content Web.config).replace('<add key="role:define" value="ContentDelivery" />', '<add key="role:define" value="ContentDelivery" /><add key="localenv:define" value="PreProd" />') | Set-Content Web.config |
MartinMiles
/ UploadFTP-File.ps1
Created
April 1, 2019 19:10
Uploads local file to remote FTP from PowerShell
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $File = "c:\Projects\output.zip" | |
| $ftp = "ftp://erad-test-sitecore-615907-single\eradFTP:PA55W0RD@waws-prod-ln1-013.ftp.azurewebsites.windows.net/site/deployments/output.zip" | |
| "ftp url: $ftp" | |
| $webclient = New-Object System.Net.WebClient | |
| #$uri = New-Object System.Uri($ftp) | |
| $uri = [uri]::EscapeUriString($ftp) |
MartinMiles
/ Remove-SolrCores.ps1
Created
April 8, 2019 09:49
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| stop-service solr6 | |
| get-childitem -path c:\Solr\6.6.2\server\solr\Platform*\Data -recurse | remove-item -force -recurse | |
| start-service solr6 | |
| Restart-WebAppPool platform.dev.local |
MartinMiles
/ TransformWithMsConfig.bat
Created
April 8, 2019 11:33
That is how MsConfig performs config transformation
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| "C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\MSBuild\15.0\Bin\amd64\MSBuild.exe" /nologo /maxcpucount /nodeReuse:False /property:Configuration=Debug /property:Platform="Any CPU" /property:WebConfigToTransform=C:\inetpub\wwwroot\Platform.dev.local\ /property:TransformFile=C:\Projects\Platform.dev.local\src\Project\Careers\code\web.config.xdt /property:FileToTransform=web.config /target:ApplyTransform /toolsversion:15.0 /verbosity:minimal C:\Projects\Platform.dev.local\scripts\applytransform.targets |
MartinMiles
/ CallSitecorePowerShellExternally.ps1
Created
April 8, 2019 11:36
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #Set-ExecutionPolicy "RemoteSigned" -Scope Process -Confirm:$false | |
| #Set-ExecutionPolicy "RemoteSigned" -Scope CurrentUser -Confirm:$false | |
| Set-ExecutionPolicy Unrestricted | |
| Import-Module -Name SPE | |
| $session = New-ScriptSession -Username admin -Password b -ConnectionUri http://platform.dev.local | |
| Invoke-RemoteScript -ScriptBlock { |
MartinMiles
/ ExpanderCollapser.js
Created
April 8, 2019 11:37
Adding Expand / Collapse buttons to Experience Editor (Sitecore 9)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* Adds Expand all and Collapse all buttons to Content Editor */ | |
| scContentEditor.prototype.onDomReady = function (evt) { | |
| this.addCollapser(window.jQuery || window.$sc); | |
| }; | |
| scContentEditor.prototype.addCollapser = function ($) { | |
| $ = $ || window.jQuery || window.$sc; | |
| if (!$) { return; } |
MartinMiles
/ Install-Solr.ps1
Created
April 15, 2019 07:13
This script installs Solr as service, downloads Java if required, creates certificates and patches solr.in.cmd for SSL
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Param( | |
| $installFolder = "c:\solr", | |
| $solrPort = "8721", | |
| $solrHost = "solr", | |
| $solrSSL = $true, | |
| $downloadFolder = "$PSScriptRoot" | |
| ) | |
| $solrVersion = "7.2.1" | |
| $solrName = "solr-$solrVersion" |
MartinMiles
/ Execute-Remote.ps1
Last active
July 25, 2019 16:29
This is a sample of WinRm code execution in a context of remote machine
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $pass = ConvertTo-SecureString -AsPlainText '123' -Force | |
| $Cred = New-Object System.Management.Automation.PSCredential -ArgumentList 'Martin',$pass | |
| Invoke-Command -ComputerName 192.168.173.14 -ScriptBlock { Get-ChildItem C:\ } -credential $Cred |
MartinMiles
/ Copy-ToRemote.ps1
Last active
July 25, 2019 16:29
This copies a local file to the remote machine using PowerShell remote session with credentials provided
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $pass = ConvertTo-SecureString -AsPlainText '123' -Force # 123 - actual password | |
| $Cred = New-Object System.Management.Automation.PSCredential -ArgumentList 'Martin',$pass # Martin - actual username | |
| $Session = New-PSSession -ComputerName 192.168.173.14 -Credential $Cred # IP address of remote machine | |
| $remotePath = Invoke-Command -Session $session -ScriptBlock { New-Item -ItemType Directory -Force -Path Sifon } #Get-Location | |
| Copy-Item -Path "c:\Some\Path\To\Local\Script.ps1" -Destination $remotePath.FullName -ToSession $session | |
| Remove-PSSession $Session |
OlderNewer