![\"https___portal_office_com_default_aspx_AllReportsRootV2\"](\"http:\/\/blogs.kent.ac.uk\/unseenit\/files\/2014\/08\/https___portal_office_com_default_aspx_AllReportsRootV2.png\")
<\/a><\/p>\nIn order to retrieve these data over time programatically, I’ve written a Powershell script to grab the data from the Get-MailboxActivityReport cmdlet and store it in a date stamped CSV. This requires a password to be stored (securely) but can then be invoked manually or from Task Scheduler automatically \ud83d\ude42<\/p>\n
<\/p>\n
Script<\/h1>\nParam(\r\n[Parameter(Mandatory=$True)] [string] $User,\r\n[Parameter(Mandatory=$True)] [string] $CredentialFile,\r\n[Parameter(Mandatory=$True)] [string] $CSVBase\r\n)\r\n\r\n$now = get-date -UFormat \"%Y-%m-%dT%H%M%S\"\r\n\r\nWrite-Verbose \"Setting up credential object for $user using $credentialfile\"\r\n$password = get-content $CredentialFile -ErrorAction Stop | ConvertTo-SecureString -ErrorAction stop\r\n$cred = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList $User, $password\r\n\r\nWrite-Verbose \"Setting up PowerShell\"\r\nImport-Module MSOnline -ErrorAction stop\r\n\r\nWrite-Verbose \"Connecting to MSFT\"\r\nConnect-MsolService -Credential $cred -ErrorAction stop\r\n$global:PSSession = New-PSSession -ErrorAction stop -ConfigurationName Microsoft.Exchange `\r\n -ConnectionUri https:\/\/ps.outlook.com\/powershell `\r\n -Credential $cred `\r\n -Authentication Basic `\r\n -AllowRedirection\r\n\r\nImport-PSSession $PSSession -CommandName Get-MailboxActivityReport -ErrorAction stop\r\n\r\nWrite-Verbose \"Requesting data\"\r\n$data = Get-MailboxActivityReport\r\n\r\nWrite-Verbose \"Exporting data\"\r\n$data | export-csv -LiteralPath $CSVBase\"-\"$now\".csv\"\r\n<\/pre>\nStoring the password securely<\/h2>\n
Invoke the following as the user you’re going to run this as:<\/p>\n
\r\nread-host -assecurestring | convertfrom-securestring | out-file cred.txt\r\n<\/pre>\nInvoking the script<\/h1>\n\r\ngetmailboxstats.ps1 -user admin@example.com -CredentialFile .\\cred.txt -CSVBase mailboxstats\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
Storing the password securely<\/h2>\n
Invoke the following as the user you’re going to run this as:<\/p>\n
\r\nread-host -assecurestring | convertfrom-securestring | out-file cred.txt\r\n<\/pre>\nInvoking the script<\/h1>\n
\r\ngetmailboxstats.ps1 -user admin@example.com -CredentialFile .\\cred.txt -CSVBase mailboxstats\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"