Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

export statistics of meeting room mailbox on exchange 2013 get organizator and participant of meeting

Posted on 2016-10-10
4
Medium Priority
?
237 Views
Last Modified: 2016-10-14
hello,

i have this script and need to get other information like meeting organizator and participant.
its a powershell export information from outlook calendar

((New-object -comobject outlook.application).GetNameSpace("MAPI")).Folders | 
	?{$_.Name -notmatch "Public Folders"}| %{
	$RoomName = $_.Name
	Write-host "Getting Calendar Info from $RoomName" -B Green
	$_.Folders.Item("Calendar").Items| Select-Object @{N="Room";E={$RoomName}},Subject, Start,End,Duration,Location
} | Export-Csv C:\Temp\report.csv -nti

Open in new window


thanks
0
Comment
Question by:cawasaki
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 

Author Comment

by:cawasaki
ID: 41837959
any help please?
0
 
LVL 18

Expert Comment

by:xtermie
ID: 41838192
0
 
LVL 40

Accepted Solution

by:
Subsun earned 2000 total points
ID: 41839663
Change line 5 to following to add Attendees and Organizer properties
$_.Folders.Item("Calendar").Items| Select-Object @{N="Room";E={$RoomName}},Subject, Start,End,Duration,Location,OptionalAttendees,RequiredAttendees,Organizer

Open in new window

1
 

Author Closing Comment

by:cawasaki
ID: 41843157
thank you :)
0

Featured Post

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you troubleshoot Outlook for clients, you may want to know a bit more about the OST file before doing your next job. IMAP can cause a lot of drama if removed in the accounts without backing up.
The core idea of this article is to make you acquainted with the best way in which you can export Exchange mailbox to PST format.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question