SQLDBATools

0.0.9

Dependencies/Read-Me.ps1

                                # Cleanup

Get-Variable Sdt* | Remove-Variable

Remove-Module SQLDBATools

# Copy files from b/w directories. Ensure not to add '\' at end of path

cls

$srcPath = "C:\Users\$($env:USERNAME)\Documents\WindowsPowerShell\Modules\SQLDBATools"

#$dstPath = "C:\Program Files\WindowsPowerShell\Modules\SQLDBATools\0.0.7"

#$srcPath = "C:\Users\Public\Documents\GitHub\SQLDBATools"

#$dstPath = "C:\Users\$($env:USERNAME)\Documents\WindowsPowerShell\Modules\SQLDBATools"

#$dstPath = "C:\Users\Public\Documents\WindowsPowerShell\Modules\SQLDBATools"

$dstPath = "C:\Users\adwivedi\Documents\SQLDBATools"

robocopy $srcPath $dstPath /e /is /it /MT:4 /XD Private Logs

# Import module by manual path specification

Import-Module SQLDBATools -DisableNameChecking

Import-Module "C:\Program Files\WindowsPowerShell\Modules\SQLDBATools\0.0.7\SQLDBATools" -DisableNameChecking

Import-Module "C:\Users\$($env:USERNAME)\Documents\WindowsPowerShell\Modules\SQLDBATools" -DisableNameChecking

# Unblock files if getting untrusted non signed warnings

Get-ChildItem -Recurse | Unblock-File

# Test function

Get-SdtServers -Verbose

cls

& 'C:\Users\Public\Documents\GitHub\SQLDBATools\Wrapper\Wrapper-SdtTestCommand.ps1' -ComputerName 'SqlProd2' -Verbose

cls

& 'C:\Users\Public\Documents\GitHub\SQLDBATools\Wrapper\Wrapper-SdtDiskSpace.ps1' `

        -DelayMinutes 2 -WarningThresholdPercent 50 -CriticalThresholdPercent 85 `

        -Verbose -Debug

cls

$servers = @($SdtInventoryInstance,'SqlProd1')

& 'C:\Users\Public\Documents\WindowsPowerShell\Modules\SQLDBATools\Wrapper\Wrapper-SdtDiskSpace.ps1' `

        -ComputerName $servers -DelayMinutes 2 `

        -WarningThresholdPercent 50 -CriticalThresholdPercent 85 `

        -Verbose -Debug

cls

$servers = @($SdtInventoryInstance)

Alert-SdtDiskSpace -ComputerName $servers -WarningThresholdPercent 20 -CriticalThresholdPercent 50 -DelayMinutes 5 -Verbose -Debug

# CmdExec Step Type with below format of Script Call. Try both of these methods in command prompt first

powershell.exe -executionpolicy bypass -Noninteractive C:\Program` Files\WindowsPowerShell\Modules\SQLDBATools\0.0.8\Wrapper\Wrapper-SdtDiskSpace.ps1 -WarningThresholdPercent 30 -CriticalThresholdPercent 50 -DelayMinutes 2

powershell.exe -executionpolicy bypass C:\Program` Files\WindowsPowerShell\Modules\SQLDBATools\0.0.8\Wrapper\Wrapper-SdtTestCommand.ps1 -ComputerName 'SqlProd1'

# Powershell Step Type with below format of Script Call => Working

Invoke-Command -ScriptBlock { & "C:\Users\Public\Documents\WindowsPowerShell\Modules\SQLDBATools\Wrapper\Wrapper-SdtTestCommand.ps1" -ComputerName 'SqlProd1'}

Invoke-Command -ScriptBlock { & 'C:\Program Files\WindowsPowerShell\Modules\SQLDBATools\0.0.8\Wrapper\Wrapper-SdtDiskSpace.ps1' -WarningThresholdPercent 30 -CriticalThresholdPercent 50 -DelayMinutes 5 }

<#

use DBA

go

select GETDATE() as srv_time, GETUTCDATE() as utc_time, *

from dbo.sdt_server_inventory

go

select DATEDIFF(minute,last_notified_date_utc,GETUTCDATE()) as last_notified_minutes, 

        [is_suppressed_valid] = case when state = 'Suppressed' and (GETUTCDATE() between a.suppress_start_date_utc and a.suppress_end_date_utc) then 1 else 0 end,

        *

--update a set [state] = 'Suppressed', suppress_start_date_utc = GETUTCDATE(), suppress_end_date_utc = DATEADD(minute,20,GETUTCDATE())

--update a set [state] = 'Suppressed', suppress_end_date_utc = DATEADD(minute,2,suppress_start_date_utc)

from dbo.sdt_alert a with (nolock)

where alert_key = 'Alert-SdtDiskSpace'

order by created_date_utc desc

go

#>