Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $Username = "user"
- $Password = "pass"
- $Server = "DESKTOP-SERVER\SQLEXPRESS"
- $Database = "ServerName"
- $Query = "SELECT TOP 10 * FROM Schema.Table;"
- $Format = @()
- $QueryResult = Invoke-Sqlcmd -Username $Username -Password $Password -ServerInstance $Server -Database $Database -Query "$Query"
- ForEach ($tmp in $QueryResult) {
- $Format = $Format + ($tmp.ItemArray -join ",")
- }
- $EmailFrom = "iv@gmail.com"
- $EmailTo = "iv@gmail.com"
- $Subject = "The subject of your email"
- $Body = $Format
- $SMTPServer = "smtp.gmail.com"
- $SMTPClient = New-Object Net.Mail.SmtpClient($SmtpServer, 587)
- $SMTPClient.EnableSsl = $true
- $SMTPClient.Credentials = New-Object System.Net.NetworkCredential("easy@gmail.com", "easy")
- $SMTPClient.Send($EmailFrom, $EmailTo, $Subject, $Body)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement