Powershell script to run a SQL query and send the output in an email

 Here's an example script to run an SQL query and send the results in an email using PowerShell:

$connection = New-Object System.Data.SqlClient.SqlConnection $connection.ConnectionString = "Server=<server_name>;Database=<database_name>;Integrated Security=True;" $command = New-Object System.Data.SqlClient.SqlCommand $command.Connection = $connection $command.CommandText = "<SQL_Query>" $connection.Open() $reader = $command.ExecuteReader() $table = New-Object System.Data.DataTable $table.Load($reader) $connection.Close() $smtp = New-Object Net.Mail.SmtpClient("<smtp_server>") $mailMessage = New-Object Net.Mail.MailMessage $mailMessage.From = "<from_email_address>" $mailMessage.To.Add("<to_email_address>") $mailMessage.Subject = "<email_subject>" $mailMessage.Body = $table | Out-String $smtp.Send($mailMessage)

Note that you'll need to replace <server_name>, <database_name>, <SQL_Query>, <smtp_server>, <from_email_address>, <to_email_address>, and <email_subject> with the appropriate values for your environment.