get-content "Users.txt" | foreach {
$cnt = (Get-Messagetrackinglog -Sender $_ -start (get-date).adddays(-1) |select messageid -unique | measure-Object).Count
New-Object PSObject @{
UserMail = $_
EmailCount = $cnt
}
} | export-csv -NoType "Result.csv"
get-content C:\Users.txt | foreach {
Get-Messagetrackinglog -Sender $_ -start (get-date).adddays(-1)
Get-Messagetrackinglog -Sender $_ -start (get-date).adddays(-1) |select messageid -unique
(Get-Messagetrackinglog -Sender $_ -start (get-date).adddays(-1) |select messageid -unique | measure-Object).Count
}
This should allow to see whether there is anything executed, and the impact of the most important operations.
get-content "Users.txt" | foreach {
$cntsent = (Get-Messagetrackinglog -Sender $_ -start (get-date).adddays(-1) |select messageid -unique | measure-Object).Count
$cntrcvd = (Get-Messagetrackinglog -Recipient $_ -start (get-date).adddays(-1) |select messageid -unique | measure-Object).Count
New-Object PSObject @{
UserMail = $_
EmailsSent = $cntsent
EmailsRcvd = $cntrcvd
}
} | export-csv -NoType "Result.csv"
If you do not see a username in the "UserMail" column of Result.csv, that is the issue for getting the same counts for different user - there is a format/content error in users.txt, which should just contain one email address per line, and nothing else.
$dt = (get-date).adddays(-1)
get-content "Users.txt" | foreach {
$cntsent = (Get-Messagetrackinglog -Sender $_ -start $dt |select messageid -unique | measure-Object).Count
$cntrcvd = (Get-Messagetrackinglog -Recipient $_ -start $dt |select messageid -unique | measure-Object).Count
New-Object PSObject -Property @{
UserMail = $_
EmailsSent = $cntsent
EmailsRcvd = $cntrcvd
}
} | select UserMail, EmailsRcvd, EmailsSent | export-csv -NoType "Result."+(Get-Date($dt) -Format yyyyMMdd)+".csv"
or store the date in each row:$dt = (get-date).adddays(-1)
get-content "Users.txt" | foreach {
$cntsent = (Get-Messagetrackinglog -Sender $_ -start $dt |select messageid -unique | measure-Object).Count
$cntrcvd = (Get-Messagetrackinglog -Recipient $_ -start $dt |select messageid -unique | measure-Object).Count
New-Object PSObject -Property @{
UserMail = $_
EmailsSent = $cntsent
EmailsRcvd = $cntrcvd
Date = $dt.Date
}
} | select Date, UserMail, EmailsRcvd, EmailsSent | export-csv -NoType "Result.csv"
Adams
Chrisb
Arianm
Get-Content "Location of text file" | Get-Messagetrackinglog -Sender user@domain.com -start (get-date).adddays(-1) |select messageid -unique | measure
- Rancy