PowerShell Custom Reports - Message Tracking
SELECT Timestamp,MessageID,Sender,Recipients,RecipientCount FROM OpenExchangePSQuery( POWERSHELL, ' Get-MessageTrackingLog -ResultSize unlim...
Thu, 29 Jun, 2017 at 3:04 PM
SELECT Name,Count FROM OpenExchangePSQuery( POWERSHELL, ' $distlist = Get-DistributionGroup -resultsize unlimited Foreach ($dl in $distlist) { $n...
Thu, 29 Jun, 2017 at 5:10 PM
$Mailboxes = Get-Mailbox -ResultSize unlimited | Get-MailboxStatistics | where {$_.LastLogonTime -le "mm/dd/yyyy"} foreach ($m in $mailboxes) ...
Thu, 29 Jun, 2017 at 5:50 PM
SELECT Name,Count FROM OpenExchangePSQuery( POWERSHELL, ' $maillist = Get-Mailbox ReplaceWithServerName Foreach ($mbx in $maillist) ...
Thu, 29 Jun, 2017 at 5:55 PM
SELECT Name,LastMessageReceived FROM OpenExchangePSQuery( POWERSHELL, ' $distlist = Get-DistributionGroup -resultsize unlimited Foreach ($dl i...
Thu, 29 Jun, 2017 at 6:51 PM
SELECT DisplayName,EmailAddress,LastMessageReceived FROM OpenExchangePSQuery( POWERSHELL, ' $Mailboxes=Get-Mailbox -ResultSize Unlimited | Where {$_....
Thu, 29 Jun, 2017 at 6:55 PM
SELECT DisplayName,EmailAddress,LastMessageSent FROM OpenExchangePSQuery( POWERSHELL, ' $Mailboxes=Get-Mailbox -ResultSize Unlimited | Where {$_.Reci...
Thu, 29 Jun, 2017 at 7:01 PM
IF object_id('tempdb..#Counter') IS NOT NULL BEGIN DROP TABLE #Counter END CREATE TABLE #Counter ( S5KB VARC...
Mon, 10 Jul, 2017 at 3:04 PM