powershell tips, ccna tips, tech videos, learn tech
Finally I have been trying to figure out a way to use the standard cmdlt Send-MailMessage using a userid and password that is saved in the script so that it does not prompt me for the credentials. I cam across a great PowerShell Scripting WebSite from Kotesh Bandhamravuri: PowerShell Guru Here is the Script I am [...]
Question: How do you use Powershell to edit an excel file automatically? That is the question I asked myself when my boss asked me for a dynamic monthly report from a couple systems. I query a database and capture the results. Then I put in the excel file with the correct formatting and save it. [...]
How do you send a file using Powershell 2.0 and a gmail account? Answer: $filename = “c:\scripts_scott\test9999.xls” $smtpserver = “smtp.gmail.com” $msg = new-object Net.Mail.MailMessage $att = new-object Net.Mail.Attachment($filename) $smtp = new-object Net.Mail.SmtpClient($smtpServer ) $smtp.EnableSsl = $True $smtp.Credentials = New-Object System.Net.NetworkCredential(“username”, “password_here”); # Put username without the @GMAIL.com or – @gmail.com $msg.From = “username@gmail.com” $msg.To.Add(”boss@job.com”) $msg.Subject [...]
This is how you fix the Microsoft Update Failures that show error code 0×80070005. I believe this fix will fix any type of Windows Update Failures. I did this on Windows Server 2003. 1. After you see the failures write down the KB# for example it should like KB979482. 2. Then go to google.com and do [...]
This script was brought to my attention from the Script Repository and was developed by Ben Wilkinson. I changed the script a bit in order for it to work with a SMTP Server that needs authentication for sending. This is the only way to send email using Google’s E-mail Server. From Tech junkie Powershell Pics [...]