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
function Compare-ObjectEquivalence { | |
[CmdletBinding(DefaultParameterSetName='Deserialized')] | |
param( | |
[Parameter(Position=0, Mandatory=$true)] | |
[ValidateNotNull()] | |
[System.Object] | |
$OriginalObject, | |
[Parameter(Position=1, Mandatory=$true, ParameterSetName='Deserialized')] | |
[ValidateNotNull()] |
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 | |
( | |
[String] [Parameter(Mandatory)] | |
$SolutionFile, | |
#this is the evironment that is in the Solution config to read where things need to go (TEST/DEV/QA/Prodution) | |
#for example - C:\tfs2013\Test Automated Deployment Sharepoint.rptproj | |
[string] [Parameter(Mandatory)] $Environment, | |
#this is the name of the Datasource as it exists in Sharepoint without the .rsds extension | |
[string] [Parameter(Mandatory)] $DataSource, | |
#This is the connection string that will be set for the report data source. |
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
function Write-User | |
{ | |
param( | |
[parameter(mandatory)] | |
[string]$fileName | |
) | |
write-output "Username: $env:UserName" | tee-object -filepath $filename | |
write-output "Current Command: $($MyInvocation.MyCommand.Path)" | tee-object -filepath $filename | |
write-output "Current Script: $($MyInvocation.MyCommand.ScriptName)"| tee-object -filepath $filename |
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($websitename = 'TEst' ,$resourceGroup = 'SchuTest',$slot = 'production', $appSettings ='{"AppSettings:testkey1": "45test","AppSettings:TestId": "This is a Test Key 28"}') | |
#https://stackoverflow.com/questions/8800375/merging-hashtables-in-powershell-how | |
Function Merge-Hashtables([ScriptBlock]$Operator) { | |
$Output = @{} | |
ForEach ($Hashtable in $Input) { | |
If ($Hashtable -is [Hashtable]) { | |
ForEach ($Key in $Hashtable.Keys) {$Output.$Key = If ($Output.ContainsKey($Key)) {@($Output.$Key) + $Hashtable.$Key} Else {$Hashtable.$Key}} | |
} | |
} | |
If ($Operator) {ForEach ($Key in @($Output.Keys)) {$_ = @($Output.$Key); $Output.$Key = Invoke-Command $Operator}} |
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($tnsnamesPath = 'c:\tns\tnsnames.ora',$username = 'user',$password = 'gotmehere', $connectionName = 'mustard', $query = 'Select sysdate from dual') | |
$simplySQLPath = (Get-Module -ListAvailable simplySQL).ModuleBase | |
if($simplySQLPath -and (test-path $tnsnamesPath -PathType Leaf) -and (![string]::IsNullOrEmpty($node))) | |
{ | |
[System.Reflection.Assembly]::LoadFile("$simplySQLPath\DataReaderToPSObject.dll") | OUT-NULL | |
Import-Module SimplySql -Force | |
$parsedTN = (get-content $tnsnamesPath -raw) -replace '(.*\=.*|\n.*\=)(.*|\n.*)\(DESCRIPTION*.\=' ,'Data Source = (DESCRIPTION =' | |
$splitTN = $parsedTN -split '(?=.*Data Source = \(DESCRIPTION \=)' | |
$tnsnames = $splitTN |?{$_ -like "*$connectionName*"} | |
$connstring = "$tnsnames;User Id=$username;Password=$password" |
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
function Update-PAzureAlertEmail | |
{ | |
<# | |
.SYNOPSIS | |
This function either adds or removes an email from Alerts in azure | |
.DESCRIPTION | |
This function will remove the enclosed email from all the alerts in an azure subscription. | |
If ADD is specified it will add the email to the all the alerts in an azure subscription. | |
When this function is called it will return an object of the items that were added or removed. | |
.EXAMPLE |
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
Add-Type –Path 'C:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\ISAPI\Microsoft.SharePoint.Client.dll' | |
Add-Type –Path 'C:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\ISAPI\Microsoft.SharePoint.Client.Runtime.dll' | |
#http://www.codeproject.com/Articles/990131/CRUD-Operation-to-List-Using-SharePoint-Rest-API | |
#https://msdn.microsoft.com/en-us/library/office/fp142380. | |
#http://paulryan.com.au/2013/odata-in-sharepoint/ | |
#https://wmostafaw.wordpress.com/2012/11/17/odata-in-sharepoint-2013-lists-and-items/ | |
#http://blogs.msdn.com/b/uksharepoint/archive/2013/02/22/manipulating-list-items-in-sharepoint-hosted-apps-using-the-rest-api.aspx | |
#http://www.odata.org/getting-started/basic-tutorial/ | |
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
# SQLReporting.psm1 Version 0.9 | |
# Written by Trond Hindenes | |
#http://hindenes.com/powershell/SQLReporting.psm1 | |
#Import-Module Pester | |
#http://stackoverflow.com/questions/9178685/change-datasource-of-ssrs-report-with-powershell | |
<# | |
.SYNOPSIS | |
Gets SSRS instances on ComputerName | |
.DESCRIPTION |
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
#http://nakedalm.com/powershell-tfs-2013-api-1-get-tfscollection-and-tfs-services/ | |
#http://blogs.msdn.com/b/alming/archive/2013/03/07/using-powershell-and-tfs-api-to-list-users-in-tfs-2010.aspx | |
#http://www.mikepoulson.com/2014/04/enumerating-tfs-permissions-for-items.html | |
function Connect-ToTfs | |
{ | |
Param([string] $Collectionurl) | |
#the collection url will be cast as a uri to the getteamproject collection. | |
write-host $Collectionurl | |
if ($CollectionUrl -ne '') | |
{ |
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
function findit | |
{ | |
param | |
( | |
[Parameter(Mandatory=$True,Position=0)][string]$SearchString, | |
[Parameter(Mandatory=$False)]$Path = "$env:USERPROFILE\Documents", | |
[Parameter(Mandatory=$False)]$Filter = "*.ps1" | |
) | |
Get-ChildItem -Path $Path -Filter $Filter -Recurse | Select-String $SearchString | select path, @{n="MatchingLines";e={"$($_.LineNumber.tostring("000")): $($_.Line -replace "^[ \t]*",'')"}} | group path | select name, @{n="Matches";e={$_.Group.MatchingLines | Out-String}} | Out-GridView -PassThru | %{notepad -filenames $_.name} | |
} |