private/cmhealthutils.ps1
|
function Import-CmHealthSettings { [CmdletBinding()] param ( [parameter()][string] $Primary = "$($env:USERPROFILE)\Desktop\cmhealth.json", [parameter()][string] $Default = "$(Split-Path $(Get-Module cmhealth).Path)\reserve\cmhealth.json" ) try { if (Test-Path $Primary) { Write-Verbose "loading from: $Primary" $result = Get-Content -Path $Primary | ConvertFrom-Json } elseif (Test-Path $Default) { Write-Verbose "loading from: $Default" $result = Get-Content -Path $Default | ConvertFrom-Json } else { throw "cmhealth.json was not found" } } catch { Write-Error $_.Exception.Message } finally { Write-Output $result } } function Get-CmHealthDefaultValue { [CmdletBinding()] param ( [parameter(Mandatory)][ValidateNotNullOrEmpty()][string] $KeySet, [parameter(Mandatory)][ValidateNotNullOrEmpty()] $DataSet ) try { $keydef = $KeySet -split ':' if ($keydef.Count -gt 1) { $keyname = $keydef[0] $value = $keydef[1] $result = $DataSet."$keyname"."$value" } else { $result = $DataSet."$keydef" } } catch { Write-Error $_.Exception.Message } finally { Write-Output $result } } function Get-CmHealthLastTestSet { [CmdletBinding()] param() $filepath = Join-Path -Path $env:USERPROFILE -ChildPath "desktop\cmhealth-lastrun.txt" if (Test-Path $filepath) { Write-Verbose "importing test selection from $filepath" Write-Output $(Get-Content -Path $filepath) } else { Write-Warning "No previous tests have been completed. Run some tests first." } } function Set-CmHealthLastTestSet { [CmdletBinding()] param( [parameter(Mandatory=$True)][string[]] $TestNames, [parameter(Mandatory=$False)][string] $FilePath = "$($env:USERPROFILE)\Desktop\cmhealth-lastrun.txt" ) Write-Verbose "saving test selection to $FilePath" $TestNames | Out-File -FilePath $FilePath -Force } function Get-CmSqlQueryResult { [CmdletBinding()] param ( [parameter(Mandatory=$True)][ValidateNotNullOrEmpty()][string] $Query, [parameter(Mandatory=$True)] $Params ) if ($null -ne $Params.Credential) { Write-Verbose "submitting query with credentials" $result = @(Invoke-DbaQuery -SqlInstance $Params.SqlInstance -Database $Params.Database -Query $Query -SqlCredential $Params.Credential) } else { Write-Verbose "submitting query without credentials" $result = @(Invoke-DbaQuery -SqlInstance $Params.SqlInstance -Database $Params.Database -Query $Query) } $result } function Get-WmiQueryResult { [CmdletBinding()] param ( [parameter(Mandatory=$True)][string] $ClassName, [parameter(Mandatory=$False)][string] $Query = "", [parameter(Mandatory=$False)][string] $NameSpace = "root\cimv2", [parameter(Mandatory=$True)] $Params ) if (![string]::IsNullOrEmpty($Params.Credential)) { Write-Verbose "submitting query with explicit credentials" $cs1 = New-CimSession -Credential $Params.Credential -Authentication Negotiate -ComputerName $Params.ComputerName -ErrorAction Stop if ([string]::IsNullOrEmpty($Query)) { $result = @(Get-CimInstance -CimSession $cs1 -ClassName $ClassName -Namespace $Namespace -ErrorAction Stop) } else { $result = @(Get-CimInstance -CimSession $cs1 -ClassName $ClassName -Namespace $Namespace -Filter $Query -ErrorAction Stop) } $cs1 | Remove-CimSession } else { Write-Verbose "submitting query with implicit credentials" if ([string]::IsNullOrEmpty($Query)) { Write-Verbose "no query. classname = $ClassName. namespace = $Namespace" [array]$result = Get-CimInstance -ClassName $ClassName -Namespace $Namespace -ErrorAction Stop } else { [array]$result = Get-CimInstance -ClassName $ClassName -Namespace $Namespace -Filter $Query -ErrorAction Stop } } $result } function Get-RunTime { param ( [parameter(Mandatory=$True)][datetime] $BaseTime ) $NowTime = (Get-Date) $runTime = $(New-TimeSpan -Start $BaseTime -End $NowTime) $ret = $("{0}h:{1}m:{2}s:{3}ms" -f $($runTime | Foreach-Object {$_.Hours,$_.Minutes,$_.Seconds,$_.Milliseconds})) Write-Output $ret } |