24 hour user report that emails .csv attachment. - PowerShellCommunity.org - Windows PowerShell Discussion Forums - Using PowerShell

24 hour user report that emails .csv attachment.

Last Post 17 Aug 2011 05:20 PM by Marco Shaw. 1 Replies.

Sort:

	Prev Next
You are not authorized to post a reply.

Author

Messages

FuriouS

New Member
Posts:3
Avatar

15 Aug 2011 08:39 AM
I am pretty new to PowerShell and wanted some peer review on these scripts. I am playing around with some easy to run message log reporting scripts that allow admins with a lesser understanding of PowerShell and Exchange to easily pull reports and get the results in email. I have shortcuts to these scripts on the desktop of a CAS/HUB server that allows any admin with RDP access to easily run the reports. These scripts prompt for the user name to run the report on and then for the the username of the intended recipient of the report. I opted to attach a .csv file instead of text to allow easy sorting of the data in excel. The script is currently designed for domain user support only, usernames will need to be formatted as first.last. A few tweaks to it would easily allow for complete email address checks or for a different domain username standard. If possible, having this script pop up a calendar that users can select the date range form would be ideal. Any peer review is appreciated here. As I said, I am new to powershell and appreciate all insights 24 hour sent. #Add Snapin# Add-PSSnapin Microsoft.Exchange.Management.PowerShell.Admin #Define Variables# $start = ((get-date).AddHours(-24)) $end = get-date $sender = read-host "Enter Senders Username (first.last)" $reportaddress = read-host "Enter Your Username(first.last)" $filename = "C:\temp\$sender{0:yyyyMMdd-HHmm}.csv" -f (get-date) #Command# Get-TransportServer \| Get-MessageTrackingLog -resultsize unliminted -Sender $sender@domain.com -Start $start -End $end \| ?{$_.EventID -eq 'RECEIVE'} \| Select-Object Timestamp,MessageSubject,{$_.Recipients} \| Sort-Object -Property Timestamp \| Export-Csv -NoTypeInformation $filename #Email# $EmailFrom = "sendingaddress@domain.com" $EmailTo = "$reportaddress@domain.com" $EmailSubject = "$sender Email Report" $SMTPServer = "" $emailattachment = $filename $mailmessage = New-Object system.net.mail.mailmessage $mailmessage.from = ($emailfrom) $mailmessage.To.add($emailto) $mailmessage.Subject = $emailsubject $mailmessage.Body = $emailbody $attachment = New-Object System.Net.Mail.Attachment($emailattachment, 'text/plain') $mailmessage.Attachments.Add($attachment) #$mailmessage.IsBodyHTML = $true $SMTPClient = New-Object Net.Mail.SmtpClient($SmtpServer, 25) $SMTPClient.Credentials = New-Object System.Net.NetworkCredential("$SMTPAuthUsername", "$SMTPAuthPassword") $SMTPClient.Send($mailmessage) 24 hour received #Add Snapin# Add-PSSnapin Microsoft.Exchange.Management.PowerShell.Admin #Define Variables# $start = ((get-date).AddHours(-24)) $end = get-date $recipient = read-host "Enter Recipients Username (first.last)" $reportaddress = read-host "Enter Your Username(first.last)" $filename = "C:\temp\$sender{0:yyyyMMdd-HHmm}.csv" -f (get-date) #Command# Get-TransportServer \| Get-MessageTrackingLog -resultsize unlimited -Recipient $recipient@domain.com -Start $start -End $end \| ?{$_.EventID -eq 'DELIVER'} \| Select-Object Timestamp,MessageSubject,Sender \| Sort-Object -Property Timestamp \| Export-Csv -NoTypeInformation $filename #Email# $EmailFrom = "sendingaddress@domian.com" $EmailTo = "$reportaddress@domain.com" $EmailSubject = "$recipient Email Report" $SMTPServer = "" $emailattachment = $filename $mailmessage = New-Object system.net.mail.mailmessage $mailmessage.from = ($emailfrom) $mailmessage.To.add($emailto) $mailmessage.Subject = $emailsubject $mailmessage.Body = $emailbody $attachment = New-Object System.Net.Mail.Attachment($emailattachment, 'text/plain') $mailmessage.Attachments.Add($attachment) #$mailmessage.IsBodyHTML = $true $SMTPClient = New-Object Net.Mail.SmtpClient($SmtpServer, 25) $SMTPClient.Credentials = New-Object System.Net.NetworkCredential("$SMTPAuthUsername", "$SMTPAuthPassword") $SMTPClient.Send($mailmessage)

Marco Shaw User is Offline

Veteran Member
Posts:1684
Avatar

17 Aug 2011 05:20 PM
Sorry, I just don't have enough free time to look at this in detail, but thought I'd point out this PowerShell calendar blog post that I remembered: http://mow001.blogspot.com/2006/10/...n-gui.html

You are not authorized to post a reply.

Forums > Using PowerShell > Peer Review

Active Forums 4.3