SOLVED

Get the all info for "Additional Information" attributes for all meeting rooms - PowerShell

%3CLINGO-SUB%20id%3D%22lingo-sub-2661594%22%20slang%3D%22en-US%22%3EGet%20the%20all%20info%20for%20%22Additional%20Information%22%20attributes%20for%20all%20meeting%20rooms%20-%20PowerShell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2661594%22%20slang%3D%22en-US%22%3E%3CDIV%3EHi%20Tech%20Folks%2C%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EI%20am%20trying%20to%20get%20the%20info%20%3CEM%3E%3CU%3E%3CSTRONG%3Eaudio%2C%20video%2C%20display%2C%20tags%2C%3C%2FSTRONG%3E%20etc.%3C%2FU%3E%3C%2FEM%3E%20which%20is%20located%20under%20each%20meeting%20room%20or%20basically%20a%20resource%20which%20the%20type%20is%20Room.%3CBR%20%2F%3E%3CBR%20%2F%3E%26nbsp%3BExchange%20Admin%20Center%20--%26gt%3B%20Resources%20--%26gt%3B%20Select%20Any%20Meeting%20Room%20(TYPE%3AROOM)%20--%26gt%3B%20Additional%20Information%3CBR%20%2F%3E%3CBR%20%2F%3E%3CDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22AliFadavinia_0-1629305493623.jpeg%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F304139i07873B66FF743D07%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22AliFadavinia_0-1629305493623.jpeg%22%20alt%3D%22AliFadavinia_0-1629305493623.jpeg%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3EI%20used%20this%20command%20which%20is%20working%20fine%20and%20reveals%20everything%20about%20the%20room%20and%20its%20properties%20%2C%20but%20NOT%20those%20above%20info%20I%20m%20looking%20for%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSTRONG%3E%3CEM%3EGet-Mailbox%20-Filter%20'(RecipientTypeDetails%20-eq%20%22RoomMailBox%22)'%20%7C%20Select%20*%20%7C%20Format-list%26nbsp%3B%3CBR%20%2F%3E%3C%2FEM%3E%3C%2FSTRONG%3E%3CEM%3E%3CBR%20%2F%3EAny%20thoughts%3F%3CBR%20%2F%3E%3C%2FEM%3E%3CBR%20%2F%3EThanks%20for%20your%20inputs%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2661594%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExchange%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExchange%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExchange%20Server%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20shell%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Erooms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2662388%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20the%20all%20info%20for%20%22Additional%20Information%22%20attributes%20for%20all%20meeting%20rooms%20-%20Power%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2662388%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F132157%22%20target%3D%22_blank%22%3E%40Ali%20Fadavinia%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20never%20tried%20it%20myself%20but%20I%20would%20start%20my%20experiments%20around%20those%20cmdlets%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%5BPS%5D%20C%3A%5C%26gt%3BSet-ResourceConfig%20-ResourcePropertySchema%20%22Room%2FWhiteboard%22%0A%5BPS%5D%20C%3A%5C%26gt%3BGet-ResourceConfig%0AName%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20ResourcePropertySchema%0A----%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20----------------------%0AResource%20Schema%20%20%20%20%20%20%20%20%20%20%20%7BRoom%2FWhiteboard%7D%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3Eand%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%5BPS%5D%20C%3A%5C%26gt%3BSet-ResourceConfig%20-ResourcePropertySchema%20%40%7BAdd%3D%22Room%2FVideoConferencing%22%7D%0A%5BPS%5D%20C%3A%5C%26gt%3BGet-ResourceConfig%0AName%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20ResourcePropertySchema%0A----%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20----------------------%0AResource%20Schema%20%20%20%20%20%20%20%20%20%20%20%7BRoom%2FVideoConferencing%2C%20Room%2FWhiteboard%7D%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%5BPS%5D%20C%3A%5C%26gt%3BSet-Mailbox%20%22Brisbane%20Lvl%201%20Conference%20Room%22%20-ResourceCustom%20%40%7BAdd%3D%22VideoConferencing%22%7D%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20in%20order%20to%20GET%20info%20you%20have%20to%20somehow%20reverse%20the%20process.%3CBR%20%2F%3ESorry%20for%20not%20being%20able%20to%20give%20you%20a%20concrete%20solution.%20Hope%20it%20helps%20nevertheless.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2663916%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20the%20all%20info%20for%20%22Additional%20Information%22%20attributes%20for%20all%20meeting%20rooms%20-%20Power%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2663916%22%20slang%3D%22en-US%22%3EUse%20the%20Get-Place%2FSet-Place%20cmdlets%2C%20or%20the%20Graph%20API%20endpoints%20directly%3A%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fgraph%2Fapi%2Fplace-get%3Fview%3Dgraph-rest-1.0%26amp%3Btabs%3Dhttp%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fgraph%2Fapi%2Fplace-get%3Fview%3Dgraph-rest-1.0%26amp%3Btabs%3Dhttp%3C%2FA%3E%3C%2FLINGO-BODY%3E
Contributor
Hi Tech Folks,
 
I am trying to get the info audio, video, display, tags, etc. which is located under each meeting room or basically a resource which the type is Room.

 Exchange Admin Center --> Resources --> Select Any Meeting Room (TYPE:ROOM) --> Additional Information

 
AliFadavinia_0-1629305493623.jpeg

 

I used this command which is working fine and reveals everything about the room and its properties , but NOT those above info I m looking for:

Get-Mailbox -Filter '(RecipientTypeDetails -eq "RoomMailBox")' | Select * | Format-list 

How can I get those Additional Attributes by that PS command?

Any thoughts?

Thanks for your inputs
3 Replies

@Ali Fadavinia 

I never tried it myself but I would start my experiments around those cmdlets:

 

[PS] C:\>Set-ResourceConfig -ResourcePropertySchema "Room/Whiteboard"
[PS] C:\>Get-ResourceConfig
Name                      ResourcePropertySchema
----                      ----------------------
Resource Schema           {Room/Whiteboard}

and

[PS] C:\>Set-ResourceConfig -ResourcePropertySchema @{Add="Room/VideoConferencing"}
[PS] C:\>Get-ResourceConfig
Name                      ResourcePropertySchema
----                      ----------------------
Resource Schema           {Room/VideoConferencing, Room/Whiteboard}

 

[PS] C:\>Set-Mailbox "Brisbane Lvl 1 Conference Room" -ResourceCustom @{Add="VideoConferencing"}

 

So in order to GET info you have to somehow reverse the process.
Sorry for not being able to give you a concrete solution. Hope it helps nevertheless.

 

best response confirmed by Ali Fadavinia (Contributor)
Solution

@Ali Fadavinia 

I finally ended up figuring it out by combining get-mailbox & get-place together. It works great for such a bulk operation, saved me a lot of time!

 

$rooms= get-mailbox -RecipientTypeDetails roommailbox

 

Foreach($mailbox in $rooms)

{

$roomname=$mailbox.identity

Get-place -identity $roomname | select * | export-csv C:\roomdetails.csv -append
}