Advertisement
Guest User

Untitled

a guest
Mar 15th, 2019
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. $Username = "user"
  2. $Password = "pass"
  3. $Server = "DESKTOP-SERVER\SQLEXPRESS"
  4. $Database = "ServerName"
  5. $Query = "SELECT TOP 10 * FROM Schema.Table;"
  6. $Format = @()
  7. $QueryResult = Invoke-Sqlcmd -Username $Username -Password $Password -ServerInstance $Server -Database $Database -Query "$Query"
  8.  
  9. ForEach ($tmp in $QueryResult) {
  10. $Format = $Format + ($tmp.ItemArray -join ",")
  11. }
  12.  
  13. $EmailFrom = "iv@gmail.com"
  14. $EmailTo = "iv@gmail.com"
  15. $Subject = "The subject of your email"
  16. $Body = $Format
  17. $SMTPServer = "smtp.gmail.com"
  18. $SMTPClient = New-Object Net.Mail.SmtpClient($SmtpServer, 587)
  19. $SMTPClient.EnableSsl = $true
  20. $SMTPClient.Credentials = New-Object System.Net.NetworkCredential("easy@gmail.com", "easy")
  21. $SMTPClient.Send($EmailFrom, $EmailTo, $Subject, $Body)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement