{"id":2642,"date":"2019-11-22T20:35:46","date_gmt":"2019-11-22T19:35:46","guid":{"rendered":"https:\/\/laurentvanacker.com\/?p=2642"},"modified":"2022-12-09T09:50:13","modified_gmt":"2022-12-09T08:50:13","slug":"taux-dutilisation-des-salles-de-reunion-avec-office-365-et-powershell-meeting-rooms-utilization-rate-with-office-365-and-powershell","status":"publish","type":"post","link":"https:\/\/laurentvanacker.com\/index.php\/2019\/11\/22\/taux-dutilisation-des-salles-de-reunion-avec-office-365-et-powershell-meeting-rooms-utilization-rate-with-office-365-and-powershell\/","title":{"rendered":"Taux d&rsquo;utilisation des salles de r\u00e9union avec Office 365 et Powershell \/ Meeting Rooms Utilization Rate with Office 365 and Powershell \/"},"content":{"rendered":"<p><a href=\"#en-us\" name=\"fr-fr\">Go to English version<\/a><\/p>\n<p>Il y a quelques mois \u00e0 la demande d&rsquo;un client, j&rsquo;ai r\u00e9alis\u00e9 un script pour connaitre le taux d&rsquo;utilisation des ses salles de r\u00e9union (en France uniquement &#8211; les salles fran\u00e7aises appartenant toutes \u00e0 une m\u00eame \u00ab\u00a0RoomList\u00a0\u00bb Exchange). Le client avait besoin de rationaliser son espace pour accueillir de nouveaux collaborateurs. Le but \u00e9tant de transformer les salles les moins utilis\u00e9es en espace de travail. L&rsquo;analyse a \u00e9t\u00e9 faite sur un an et sur la plage horaire 08:00 &#8211; 18:00 (Tout est param\u00e9trable).<\/p>\n<p>La demande \u00e9tait au d\u00e9part sur du Exchange \u00ab\u00a0onPrem\u00a0\u00bb. Par plaisir j&rsquo;ai d\u00e9cid\u00e9 de faire \u00e9voluer ce script pour <a href=\"https:\/\/www.office365.com\">Office 365<\/a>\u00a0 (Mode d&rsquo;authentification en <a href=\"https:\/\/gsexdev.blogspot.com\/2019\/10\/using-msal-microsoft-authentication.html\">ADAL<\/a>). Je vous partage donc le <a href=\"https:\/\/github.com\/lavanack\/laurentvanacker.com\/blob\/master\/Windows%20Powershell\/Exchange%20Online\/Get-MeetingRoomUtilizationRate.ps1\">script<\/a>.<\/p>\n<p>Le r\u00e9sultat(*) est un fichier CSV par salle (une ligne = 1 jour):<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2649\" src=\"https:\/\/laurentvanacker.com\/wp-content\/uploads\/2019\/11\/meetingroom.png\" alt=\"\" width=\"1180\" height=\"332\" srcset=\"https:\/\/laurentvanacker.com\/wp-content\/uploads\/2019\/11\/meetingroom.png 1180w, https:\/\/laurentvanacker.com\/wp-content\/uploads\/2019\/11\/meetingroom-300x84.png 300w, https:\/\/laurentvanacker.com\/wp-content\/uploads\/2019\/11\/meetingroom-1024x288.png 1024w, https:\/\/laurentvanacker.com\/wp-content\/uploads\/2019\/11\/meetingroom-768x216.png 768w\" sizes=\"auto, (max-width: 1180px) 100vw, 1180px\" \/><\/p>\n<p>et un fichier CSV(*) de consolidation (sur un an dans le cas pr\u00e9sent) pour toutes les salles :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2650\" src=\"https:\/\/laurentvanacker.com\/wp-content\/uploads\/2019\/11\/consolidated.png\" alt=\"\" width=\"841\" height=\"406\" srcset=\"https:\/\/laurentvanacker.com\/wp-content\/uploads\/2019\/11\/consolidated.png 841w, https:\/\/laurentvanacker.com\/wp-content\/uploads\/2019\/11\/consolidated-300x145.png 300w, https:\/\/laurentvanacker.com\/wp-content\/uploads\/2019\/11\/consolidated-768x371.png 768w\" sizes=\"auto, (max-width: 841px) 100vw, 841px\" \/><\/p>\n<p>(*) R\u00e9sultat filtr\u00e9 et anonymis\u00e9 pour des raisons de lecture et confidentialit\u00e9.<\/p>\n<p>Ce dernier fichier permet donc de voir rapidement les salles les moins utilis\u00e9es.<\/p>\n<p>Quelques liens utiles :<\/p>\n<ul>\n<li><a href=\"https:\/\/gsexdev.blogspot.com\/2019\/10\/using-msal-microsoft-authentication.html\">https:\/\/gsexdev.blogspot.com\/2019\/10\/using-msal-microsoft-authentication.html<\/a><\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"http:\/\/laurentvanacker.com\/wp-content\/uploads\/2017\/01\/012717_1333_Fusionnerde1.png\" alt=\"\" \/><\/p>\n<p><a href=\"#fr-FR\" name=\"en-us\">Aller \u00e0 la version fran\u00e7aise<\/a><\/p>\n<p>A few months ago, I made a script for a customer to know the utilization rate of its meeting rooms (in France only &#8211; all the rooms belonged to the same Exchange RoomList). This customer needed to rationalize his space to accommodate new employees. The goal was to transform the less used rooms into workspaces. The analysis was done over one year and on the time slot 08:00AM &#8211; 06:00 PM (Everything is configurable).<\/p>\n<p>The request was initially for \u00ab\u00a0onPrem\u00a0\u00bb Exchange. For pleasure I decided to upgrade this script for <a href=\"https:\/\/www.office365.com\">Office 365<\/a>\u00a0 (authentication mode in <a href=\"https:\/\/www.office365.com\">Office 365<\/a> ). So I share the <a href=\"https:\/\/github.com\/lavanack\/laurentvanacker.com\/blob\/master\/Windows%20Powershell\/Exchange%20Online\/Get-MeetingRoomUtilizationRate.ps1\">script<\/a>.<\/p>\n<p>The result (*) is a CSV file per room (one line = 1 day):<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2649\" src=\"https:\/\/laurentvanacker.com\/wp-content\/uploads\/2019\/11\/meetingroom.png\" alt=\"\" width=\"1180\" height=\"332\" srcset=\"https:\/\/laurentvanacker.com\/wp-content\/uploads\/2019\/11\/meetingroom.png 1180w, https:\/\/laurentvanacker.com\/wp-content\/uploads\/2019\/11\/meetingroom-300x84.png 300w, https:\/\/laurentvanacker.com\/wp-content\/uploads\/2019\/11\/meetingroom-1024x288.png 1024w, https:\/\/laurentvanacker.com\/wp-content\/uploads\/2019\/11\/meetingroom-768x216.png 768w\" sizes=\"auto, (max-width: 1180px) 100vw, 1180px\" \/><\/p>\n<p>and a consolidation CSV (*) file (over one year in this case) for all rooms:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2650\" src=\"https:\/\/laurentvanacker.com\/wp-content\/uploads\/2019\/11\/consolidated.png\" alt=\"\" width=\"841\" height=\"406\" srcset=\"https:\/\/laurentvanacker.com\/wp-content\/uploads\/2019\/11\/consolidated.png 841w, https:\/\/laurentvanacker.com\/wp-content\/uploads\/2019\/11\/consolidated-300x145.png 300w, https:\/\/laurentvanacker.com\/wp-content\/uploads\/2019\/11\/consolidated-768x371.png 768w\" sizes=\"auto, (max-width: 841px) 100vw, 841px\" \/><\/p>\n<p>(*) Filtered and anonymized result for reading and confidentiality purposes.<\/p>\n<p>This last file makes it possible to quickly see the least used rooms.<\/p>\n<div class=\"tlid-input input\">\n<div class=\"source-wrap\">\n<div class=\"input-full-height-wrapper tlid-input-full-height-wrapper\">\n<div class=\"source-input\">\n<div class=\"source-footer-wrap source-or-target-footer\">\n<div class=\"character-count tlid-character-count\">Some useful links:<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"tlid-results-container results-container\">\n<div class=\"tlid-result result-dict-wrapper\">\n<div class=\"result tlid-copy-target\">\n<div class=\"text-wrap tlid-copy-target\">\n<ul>\n<li class=\"result-shield-container tlid-copy-target\" tabindex=\"0\"><a href=\"https:\/\/gsexdev.blogspot.com\/2019\/10\/using-msal-microsoft-authentication.html\"><span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">https:\/\/gsexdev.blogspot.com\/2019\/10\/using-msal-microsoft-authentication.html<\/span><\/span><\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>Laurent.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Go to English version Il y a quelques mois \u00e0 la demande d&rsquo;un client, j&rsquo;ai r\u00e9alis\u00e9 un script pour connaitre le taux d&rsquo;utilisation des ses [&#8230;]<\/p>\n","protected":false},"author":2,"featured_media":2463,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,6,19],"tags":[51,50,48,49,39],"class_list":["post-2642","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ews","category-exchange","category-powershell","tag-ews","tag-exchange","tag-github","tag-office-365","tag-powershell"],"_links":{"self":[{"href":"https:\/\/laurentvanacker.com\/index.php\/wp-json\/wp\/v2\/posts\/2642","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/laurentvanacker.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/laurentvanacker.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/laurentvanacker.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/laurentvanacker.com\/index.php\/wp-json\/wp\/v2\/comments?post=2642"}],"version-history":[{"count":14,"href":"https:\/\/laurentvanacker.com\/index.php\/wp-json\/wp\/v2\/posts\/2642\/revisions"}],"predecessor-version":[{"id":2901,"href":"https:\/\/laurentvanacker.com\/index.php\/wp-json\/wp\/v2\/posts\/2642\/revisions\/2901"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/laurentvanacker.com\/index.php\/wp-json\/wp\/v2\/media\/2463"}],"wp:attachment":[{"href":"https:\/\/laurentvanacker.com\/index.php\/wp-json\/wp\/v2\/media?parent=2642"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/laurentvanacker.com\/index.php\/wp-json\/wp\/v2\/categories?post=2642"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/laurentvanacker.com\/index.php\/wp-json\/wp\/v2\/tags?post=2642"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}