ARCM Mailbox Folder Size Report

ARCM Mailbox Folder Size Report

ARCM requested BCT to create a script that will generate a report detailing the size in GB of folders in users' mailboxes.  Will need to perform this at least every 2 months for internal Evalution.

The script is located on SharePoint (CreateExchangeMailboxReport.ps1):


In order to run the script you first need to install the ExchangeOnlineManagement PowerShell module. Open a new PowerShell window and run the following two commands. Copy line 1 below, paste into your PowerShell window, and press enter, then copy line 2, paste into your PowersShell window and press enter.
  1. Install-Module ExchangeOnlineManagement -Scope CurrentUser
  2. Set-ExecutionPolicy RemoteSigned -Scope CurrentUser
Change directory to the folder location of the script
Warning
Change the part in quotes to the path to the script on YOUR machine
  1. cd "C:\Users\paul.mendoza\Bare Cove Technology\Bare Cove Team Portal - Clients\ARCM\Support\Scripts\CreateExchangeMailboxReport"
Run the script and change the ExportPath and UserlistTextFilePath to match the folder paths on your machine:

  1. .\CreateExchangeMailboxReport.ps1 -ClientCode arcm -ExchangeOnlineAdminUPN exchange.reader@arcmcap.com -ExportPath "C:\Users\paul.mendoza\OneDrive - Bare Cove Technology\Desktop" -UserlistTextFilePath "C:\Users\paul.mendoza\Bare Cove Technology\Bare Cove Team Portal - Clients\ARCM\Support\Scripts\CreateExchangeMailboxReport\users.txt"
Warning
You need to change the ExportPath and UserlistTextFilePath to the folder values for your own computer
The UserlistTextFilePath should point to a .txt file with one user login name per line e.g.:


There is a users.txt file on SharePoint in the same folder as the script which you can use.

When the script runs, it will prompt you to sign in to a Microsoft account. Sign in with the exchange.reader@arcmcap.com email address, password and OTP, located in devolutions under ARC -> Systems -> Software Development Exchange Reader and Exchange Reader - OTP:





Warning
ARCM has trusted locations enabled, so you will only be able to run this script from a trusted location, e.g. the BCT office, ARCM PMM server, etc. Otherwise, the exchange.reader@arcmcap.com sign in will be blocked.
The script will result in a zip file being created in the ExportPath you specified. The contents of the folder include a consolidated_mailbox_stats file which has all users and their mailbox stats. The folder also creates an individual file for each user specified in the users.txt list, in case the client needs to share the results to only that user.

In the csv file, you will see the username, the FolderPath which represents the folder path within their Outlook, the FolderName which represents just the folder name, and the FolderAndSubFolderSizeInGB which represents the size of the folder and it's subfolders in GB:


You can add filters and sorters using excel to explore the report in more detail if required.

    • Related Articles

    • ARCM | Geneva Support Information

      Purpose Geneva Support Information Client: ARCM Category: Troubleshooting, Error, General Information Steps 1. If we encounter reports from users in ARCM with regards to Geneva application below are the support help line. Reference ticket

    • ARCM | How to disable Access Card in HK Office

      Purpose Purpose of the article is to show how to disable access cards for ARCM HK Office. Client: ARCM Category: General Information Steps 1. Log into ARC-WDT1-PD1 with barecove account and MSTSC to 172.26.2.62. Credentials can be found in DVLS. 2. ...

    • ARCM SharePoint Cheat Sheet

      Purpose Purpose of the article is to assist SD/CSA to identify if a user has access or not in a SharePoint folder. The Cheat Sheet is continuously being updated to contain the current folder permissions. Client: ARCM Category: Troubleshooting, ...

    • Citrix Workspace Remote Desktop/Apps | Tips in troubleshooting

      Purpose: This article will show you some tips that will help your troubleshooting with Citrix Workspace Remote Desktop/ App issues. Client: ARCM, LCA, VAM Category: Troubleshooting, General Information Keep in mind that any changes you make, (e.g. ...

    • ARCM | How to handle Geneva Service Manager restart request

      Purpose Purpose of the article is to inform us how to handle Geneva Service Manager restart request from ARCM users. Client: ARCM Category: General Information Important Information/ Note/Warning -Review the ticket carefully and make sure that the ...