Link to home
Start Free TrialLog in
Avatar of pramod1
pramod1Flag for United States of America

asked on

powershell, office 365

can i use any powershell commnads to find no.of items in each users calendar on a weekly basis

like how many meetings or appointment they have scheduled.

users are in office 365 portal and are using on premise outlook 2010
Avatar of Bartender_1
Bartender_1
Flag of Canada image

You could run this command on the office 365 exchange server:

Get-Mailbox |Get-MailboxFolderStatistics –FolderScope ‘Calendar’

Open in new window


Hope this helps!

Christopher.
Avatar of pramod1

ASKER

$(Foreach ($User in get-mailbox -resultsize Unlimited) {$User | Select Name,@{N="CalItemsInFolder";E={($_ | Get-MailboxFolderStatistics -FolderScope 'Calendar').ItemsInFolder}}}) | Export-Csv M:\report.csv -NoTypeInformation
Get-Mailbox |Get-MailboxFolderStatistics –FolderScope ‘Calendar’


can I use above also before this command do I need to write anything
You may want "ItemsInFolderAndSubfolders", and you will need to connect to the exchange online server via powershell first, but other than that, you should be fine.

How to connect to exchange online via powershell:
https://docs.microsoft.com/en-us/powershell/exchange/exchange-online/connect-to-exchange-online-powershell/connect-to-exchange-online-powershell?view=exchange-ps

Hope this helps!

Christopher.
Avatar of pramod1

ASKER

I am getting this figure against my name : Pramod Kumar      2 0 199 ( call items in folder)

doesn't know what this means?
Avatar of pramod1

ASKER

I connected online successfully
Avatar of pramod1

ASKER

Get-Mailbox |Get-MailboxFolderStatistics –FolderScope ‘Calendar’

this is not giving what I am looking , I need the number of items in users calendar
Get-Mailbox emailaddressofuser | Get-MailboxFolderStatistics -FolderScope Calendar | Select Name,ItemsinFolder
Avatar of pramod1

ASKER

can I run this command to get list of all users in my company
ASKER CERTIFIED SOLUTION
Avatar of Bartender_1
Bartender_1
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial