sqlwatch

>= 8760 then [day] //if window >= 1 year, aggregate over 1 day
>= 168 then [1_hour] //if window >= 1 week, aggregate over 1 hour
> 24 then [15_minutes] //if window > 24 hours, aggregate over 15 minutes
> 1 then [5_minutes] //if window > 1 hour, aggregate over 5 minutes
> 0 then [time] //if window > 0 hours, no aggregation

sqlwatch

select @output=min(free_space_percentage) 
from dbo.vw_sqlwatch_report_dim_os_volume 
where sql_instance = @@SERVERNAME
and free_space_percentage is not null

sqlwatch

exec msdb.dbo.sp_send_dbmail
   @recipients = 'dba@yourcompany.com',
   @subject = '{SUBJECT}',
   @body = '{BODY}',
   @profile_name='SQLWATCH',
   @body_format = 'HTML'

sqlwatch

Send-MailMessage `
   -From 'DBA <dba@yourcompany.com>' `
   -To 'dba@yourcompany.com' `
   -Subject "{SUBJECT}" `
   -Body "{BODY}" `
   -SmtpServer "smtp.yourcompany.com"

sqlwatch

$uri = "https://api.pushover.net/1/messages.json"
$parameters = @{
   token = "YOUR_TOKEN"
   user = "USER_TOKEN"
   message = "{SUBJECT} {BODY}"
}
$parameters | Invoke-RestMethod -Uri $uri -Method Post

sqlwatch

"{BODY}" | Out-File -FilePath \\yourshare\Folder\trigger.dat

sqlwatch

Invoke-Sqlcmd `
   -ServerInstance localhost `
   -Database SQLWATCH `
   -Query "{BODY}" `
| C:SQLWATCHPSUpload-AzMonitorLog.ps1 `
   -WorkspaceId YOURWORKSPACEID `
   -WorkspaceKey YOURWORKSPACEKEY `
   -LogTypeName "{SUBJECT}" `
   -AddComputerName

sqlwatch

Install-DbaSqlWatch -SqlInstance SQLSERVER1,SQLSERVER2,SQLSERVER3 -Database SQLWATCH