internal/dynamicparams/alert.ps1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 |
#region Initialize Cache if (-not [Sqlcollaborative.Dbatools.TabExpansion.TabExpansionHost]::Cache["alert"]) { [Sqlcollaborative.Dbatools.TabExpansion.TabExpansionHost]::Cache["alert"] = @{ } } #endregion Initialize Cache #region Tepp Data return $ScriptBlock = { param ( $commandName, $parameterName, $wordToComplete, $commandAst, $fakeBoundParameter ) $start = Get-Date [Sqlcollaborative.Dbatools.TabExpansion.TabExpansionHost]::Scripts["alert"].LastExecution = $start $server = $fakeBoundParameter['SqlInstance'] if (-not $server) { $server = $fakeBoundParameter['Source'] } if (-not $server) { $server = $fakeBoundParameter['ComputerName'] } if (-not $server) { return } try { [DbaInstanceParameter]$parServer = $server | Select-Object -First 1 } catch { [Sqlcollaborative.Dbatools.TabExpansion.TabExpansionHost]::Scripts["alert"].LastDuration = (Get-Date) - $start return } if ([Sqlcollaborative.Dbatools.TabExpansion.TabExpansionHost]::Cache["alert"][$parServer.FullSmoName.ToLower()]) { foreach ($name in ([Sqlcollaborative.Dbatools.TabExpansion.TabExpansionHost]::Cache["alert"][$parServer.FullSmoName.ToLower()] | Where-DbaObject -Like "$wordToComplete*")) { New-DbaTeppCompletionResult -CompletionText $name -ToolTip $name } [Sqlcollaborative.Dbatools.TabExpansion.TabExpansionHost]::Scripts["alert"].LastDuration = (Get-Date) - $start return } try { $serverObject = Connect-SqlInstance -SqlInstance $parServer -SqlCredential $fakeBoundParameter['SqlCredential'] -ErrorAction Stop foreach ($name in ([Sqlcollaborative.Dbatools.TabExpansion.TabExpansionHost]::Cache["alert"][$parServer.FullSmoName.ToLower()] | Where-DbaObject -Like "$wordToComplete*")) { New-DbaTeppCompletionResult -CompletionText $name -ToolTip $name } [Sqlcollaborative.Dbatools.TabExpansion.TabExpansionHost]::Scripts["alert"].LastDuration = (Get-Date) - $start return } catch { [Sqlcollaborative.Dbatools.TabExpansion.TabExpansionHost]::Scripts["alert"].LastDuration = (Get-Date) - $start return } } Register-DbaTeppScriptblock -ScriptBlock $ScriptBlock -Name alert #endregion Tepp Data return #region Update Cache $ScriptBlock = { [Sqlcollaborative.Dbatools.TabExpansion.TabExpansionHost]::Cache["alert"][$FullSmoName] = $server.JobServer.Alerts.Name } Register-DbaTeppInstanceCacheBuilder -ScriptBlock $ScriptBlock #endregion Update Cache |