OutlookFolderSize.sh

#!/bin/sh
#set -x

TOOL_NAME="Microsoft Outlook Local Folders Size Extension Attribute"
TOOL_VERSION="1.0"

## Copyright (c) 2020 Microsoft Corp. All rights reserved.
## Scripts are not supported under any Microsoft standard support program or service. The scripts are provided AS IS without warranty of any kind.
## Microsoft disclaims all implied warranties including, without limitation, any implied warranties of merchantability or of fitness for a 
## particular purpose. The entire risk arising out of the use or performance of the scripts and documentation remains with you. In no event shall
## Microsoft, its authors, or anyone else involved in the creation, production, or delivery of the scripts be liable for any damages whatsoever 
## (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary 
## loss) arising out of the use of or inability to use the sample scripts or documentation, even if Microsoft has been advised of the possibility
## of such damages.
## Feedback: pbowden@microsoft.com

# Function to determine the logged-in state of the Mac
function DetermineLoginState() {
	USERNAME=$(/usr/bin/last -1 -t ttys000 | /usr/bin/awk '{print $1}')
	CMD_PREFIX="sudo -u ${USERNAME} "
}

# Function to determine which Outlook profile is in use
function DetermineOutlookProfile() {
	PROFILE_NAME=$( defaults read "/Users/${USERNAME}/Library/Group Containers/UBF8T346G9.Office/OutlookProfile.plist" Default_Profile_Name )
}

# Function to determine the path to the Outlook database
function DetermineOutlookDB() {
	OUTLOOK_DB="/Users/${USERNAME}/Library/Group Containers/UBF8T346G9.Office/Outlook/Outlook 15 Profiles/${PROFILE_NAME}/Data/Outlook.sqlite"
	OUTLOOK_FOLDER="/Users/${USERNAME}/Library/Group Containers/UBF8T346G9.Office/Outlook/Outlook 15 Profiles/${PROFILE_NAME}/Data/"
}

# Function to get the list of local messages from the Outlook database, and get the file size on disk
function GetLocalMessages() {
	OMCSIZE=0
	local MSGRESULT=$(sqlite3 "${OUTLOOK_DB}" "SELECT PathToDataFile from Mail WHERE Record_AccountUID='0'")
	declare -a MSGARRAY
	SAVEIFS=$IFS
	IFS=$'\n'
	MSGARRAY=(${MSGRESULT})
	IFS=$SAVEIFS
	for msg in "${MSGARRAY[@]}"
	do
		MSGSIZE=$(/usr/bin/stat -qf%z "${OUTLOOK_FOLDER}${msg}")
		OMCSIZE=$(($OMCSIZE + $MSGSIZE))
	done
}

# Function to convert message size to megabytes
function ConvertSizeToMB() {
	FINALSIZE=$(/usr/bin/awk "BEGIN {printf \"%.2f\n\", ${OMCSIZE}/1000/1000}")
}

## MAIN
DetermineLoginState
DetermineOutlookProfile
DetermineOutlookDB
GetLocalMessages
ConvertSizeToMB

/bin/echo "<result>${FINALSIZE} MB</result>"

exit 0