{"id":437,"date":"2022-09-03T19:09:39","date_gmt":"2022-09-03T07:09:39","guid":{"rendered":"https:\/\/www.howdoiuseacomputer.com\/?p=437"},"modified":"2023-08-04T02:53:27","modified_gmt":"2023-08-03T14:53:27","slug":"export-azure-ad-groups-and-members-to-csv","status":"publish","type":"post","link":"https:\/\/www.howdoiuseacomputer.com\/index.php\/2022\/09\/03\/export-azure-ad-groups-and-members-to-csv\/","title":{"rendered":"Azure AD &#8211; export groups and members #2 &#8211; advanced version!"},"content":{"rendered":"\n<p>Due to the popularity of the initial script (over 5000 views and 3rd in the list on a google search &#8211; hooray!) <a href=\"https:\/\/www.howdoiuseacomputer.com\/index.php\/2021\/09\/12\/azure-ad-output-groups-and-members-to-csv\">Azure AD &#8211; Export Groups and Members to CSV<\/a>, and thanks to David for asking, this script goes next level and will export the groups and the members with properties ObjectID, Display Name, UserPrincipalName and Email Address.  It caters for the main member &#8216;types&#8217;, User, Device, Group, and Contact.  If another type of object is a member the output will say &#8216;Unknown object&#8217;.  This could be a service principal or other object which you can investigate using the ObjectId.  If a group has no members, &#8216;No members&#8217; is output as the member display name.<\/p>\n\n\n\n<p>The script uses the AzAD cmdlets as well as the AzureAD cmdlets, so make sure you have installed and imported them.  <\/p>\n\n\n\n<p>To install them:<\/p>\n\n\n\n<p>     <em>Install-Module Az -SkipPublisherCheck -Force -AllowClobber -Confirm:$false<\/em><\/p>\n\n\n\n<p>     <em>Install-Module AzureAD -SkipPublisherCheck -Force -AllowClobber -Confirm:$false<\/em><\/p>\n\n\n\n<p>To import them:<\/p>\n\n\n\n<p>     <em>Import-Module Az<\/em><\/p>\n\n\n\n<p><em>     Import-Module AzureAD<\/em><\/p>\n\n\n\n<p>Then connect to Azure AD:<\/p>\n\n\n\n<p>Connect-AzureAD<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Enjoy!   &#x1f37b;&#x1f91f;&#x1f642;&#x1f91f;&#x1f37b;  <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$allgroups = Get-AzADGroup\n\n$result = foreach ( $group in $allgroups ) {\n\n    $hash = @{\n        GroupName=$group.DisplayName\n        Member=''\n        Email=''\n        UserPrincipalName=''\n        ObjectId=''\n    }\n    \n    $groupid = $group.id\n    $groupdisplayname = $group.DisplayName\n\n        if ( $members = Get-AzADGroupMember -GroupObjectId $groupid ) {\n\n            foreach ( $member in $members ) {\n\n                if ( $member.OdataType -eq '#microsoft.graph.user' ) {\n\n                    $objectid = $member.Id\n                    $userinfo = Get-AzADUser -ObjectId $objectid\n                    $displayname = $userinfo.DisplayName\n                    $email = $userinfo.Mail\n                    $upn = $userinfo.UserPrincipalName\n                     \n                    $hash.Member = $displayname\n                    $hash.Email = $email\n                    $hash.UserPrincipalName = $upn\n                    $hash.ObjectId = $objectid\n                    New-Object psObject -Property $hash\n                }\n\n                elseif ( $member.OdataType -eq '#microsoft.graph.group' ) {\n\n                    $objectid = $member.Id\n                    $userinfo = Get-AzADGroup -ObjectId $objectid\n                    $displayname = $userinfo.DisplayName\n                    $email = $userinfo.Mail\n                    $upn = 'No UPN - Nested Group'\n                     \n                    $hash.Member = $displayname\n                    $hash.Email = $email\n                    $hash.UserPrincipalName = $upn\n                    $hash.ObjectId = $objectid\n                    New-Object psObject -Property $hash                \n                }\n                \n                elseif ( $member.OdataType -eq '#microsoft.graph.orgContact' ) {\n\n                    $objectid = $member.Id\n                    $userinfo = Get-AzureADContact -ObjectId $objectid\n                    $displayname = $userinfo.DisplayName\n                    $email = $userinfo.Mail\n                    $upn = 'No UPN - Contact'\n                     \n                    $hash.Member = $displayname\n                    $hash.Email = $email\n                    $hash.UserPrincipalName = $upn\n                    $hash.ObjectId = $objectid\n                    New-Object psObject -Property $hash\n                }\n\n                elseif ( $member.OdataType -eq '#microsoft.graph.device' ) {\n\n                    $objectid = $member.Id\n                    $userinfo = Get-AzureADDevice -ObjectId $objectid\n                    $displayname = $userinfo.DisplayName\n                    $email = 'No Email - Device'\n                    $upn = 'No UPN - Device'\n                     \n                    $hash.Member = $displayname\n                    $hash.Email = $email\n                    $hash.UserPrincipalName = $upn\n                    $hash.ObjectId = $objectid\n                    New-Object psObject -Property $hash\n                \n                }\n\n                else {\n                    $objectid = $member.Id\n                    $displayname = 'Unknown object'\n                    $email = 'Unknown object'\n                    $upn = 'Unknown object'\n                     \n                    $hash.Member = $displayname\n                    $hash.Email = $email\n                    $hash.UserPrincipalName = $upn\n                    $hash.ObjectId = $objectid\n                    New-Object psObject -Property $hash\n\n                }\n            }\n        }\n\n        else {\n           $hash.Member = 'No members'\n           $hash.Email = ''\n           $hash.UserPrincipalName = ''\n           $hash.ObjectId = ''\n           New-Object psObject -Property $hash\n\n        }\n}\n\n$result | Export-Csv -Path c:\\temp\\aadgroupsandmembers.csv -NoTypeInformation\n<\/code><\/pre>\n<div class=\"pvc_clear\"><\/div><p id=\"pvc_stats_437\" class=\"pvc_stats all  \" data-element-id=\"437\" style=\"\"><i class=\"pvc-stats-icon small\" aria-hidden=\"true\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" version=\"1.0\" viewBox=\"0 0 502 315\" preserveAspectRatio=\"xMidYMid meet\"><g transform=\"translate(0,332) scale(0.1,-0.1)\" fill=\"\" stroke=\"none\"><path d=\"M2394 3279 l-29 -30 -3 -207 c-2 -182 0 -211 15 -242 39 -76 157 -76 196 0 15 31 17 60 15 243 l-3 209 -33 29 c-26 23 -41 29 -80 29 -41 0 -53 -5 -78 -31z\"\/><path d=\"M3085 3251 c-45 -19 -58 -50 -96 -229 -47 -217 -49 -260 -13 -295 52 -53 146 -42 177 20 16 31 87 366 87 410 0 70 -86 122 -155 94z\"\/><path d=\"M1751 3234 c-13 -9 -29 -31 -37 -50 -12 -29 -10 -49 21 -204 19 -94 39 -189 45 -210 14 -50 54 -80 110 -80 34 0 48 6 76 34 21 21 34 44 34 59 0 14 -18 113 -40 219 -37 178 -43 195 -70 221 -36 32 -101 37 -139 11z\"\/><path d=\"M1163 3073 c-36 -7 -73 -59 -73 -102 0 -56 133 -378 171 -413 34 -32 83 -37 129 -13 70 36 67 87 -16 290 -86 209 -89 214 -129 231 -35 14 -42 15 -82 7z\"\/><path d=\"M3689 3066 c-15 -9 -33 -30 -42 -48 -48 -103 -147 -355 -147 -375 0 -98 131 -148 192 -74 13 15 57 108 97 206 80 196 84 226 37 273 -30 30 -99 39 -137 18z\"\/><path d=\"M583 2784 c-38 -19 -67 -74 -58 -113 9 -42 211 -354 242 -373 16 -10 45 -18 66 -18 51 0 107 52 107 100 0 39 -1 41 -124 234 -80 126 -108 162 -133 173 -41 17 -61 16 -100 -3z\"\/><path d=\"M4250 2784 c-14 -9 -74 -91 -133 -183 -95 -150 -107 -173 -107 -213 0 -55 33 -94 87 -104 67 -13 90 8 211 198 130 202 137 225 78 284 -27 27 -42 34 -72 34 -22 0 -50 -8 -64 -16z\"\/><path d=\"M2275 2693 c-553 -48 -1095 -270 -1585 -649 -135 -104 -459 -423 -483 -476 -23 -49 -22 -139 2 -186 73 -142 361 -457 571 -626 285 -228 642 -407 990 -497 242 -63 336 -73 660 -74 310 0 370 5 595 52 535 111 1045 392 1455 803 122 121 250 273 275 326 19 41 19 137 0 174 -41 79 -309 363 -465 492 -447 370 -946 591 -1479 653 -113 14 -422 18 -536 8z m395 -428 c171 -34 330 -124 456 -258 112 -119 167 -219 211 -378 27 -96 24 -300 -5 -401 -72 -255 -236 -447 -474 -557 -132 -62 -201 -76 -368 -76 -167 0 -236 14 -368 76 -213 98 -373 271 -451 485 -162 444 86 934 547 1084 153 49 292 57 452 25z m909 -232 c222 -123 408 -262 593 -441 76 -74 138 -139 138 -144 0 -16 -233 -242 -330 -319 -155 -123 -309 -223 -461 -299 l-81 -41 32 46 c18 26 49 83 70 128 143 306 141 649 -6 957 -25 52 -61 116 -79 142 l-34 47 45 -20 c26 -10 76 -36 113 -56z m-2057 25 c-40 -58 -105 -190 -130 -263 -110 -324 -59 -707 132 -981 25 -35 42 -64 37 -64 -19 0 -241 119 -326 174 -188 122 -406 314 -532 468 l-58 71 108 103 c185 178 428 349 672 473 66 33 121 60 123 61 2 0 -10 -19 -26 -42z\"\/><path d=\"M2375 1950 c-198 -44 -350 -190 -395 -379 -18 -76 -8 -221 19 -290 114 -284 457 -406 731 -260 98 52 188 154 231 260 27 69 37 214 19 290 -38 163 -166 304 -326 360 -67 23 -215 33 -279 19z\"\/><\/g><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/www.howdoiuseacomputer.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p><div class=\"pvc_clear\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Due to the popularity of the initial script (over 5000 views and 3rd in the list on a google search &#8211; hooray!) Azure AD &#8211; Export Groups and Members to CSV, and thanks to David for asking, this script goes next level and will export the groups and the members with properties ObjectID, Display Name, [&hellip;]<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_437\" class=\"pvc_stats all  \" data-element-id=\"437\" style=\"\"><i class=\"pvc-stats-icon small\" aria-hidden=\"true\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" version=\"1.0\" viewBox=\"0 0 502 315\" preserveAspectRatio=\"xMidYMid meet\"><g transform=\"translate(0,332) scale(0.1,-0.1)\" fill=\"\" stroke=\"none\"><path d=\"M2394 3279 l-29 -30 -3 -207 c-2 -182 0 -211 15 -242 39 -76 157 -76 196 0 15 31 17 60 15 243 l-3 209 -33 29 c-26 23 -41 29 -80 29 -41 0 -53 -5 -78 -31z\"\/><path d=\"M3085 3251 c-45 -19 -58 -50 -96 -229 -47 -217 -49 -260 -13 -295 52 -53 146 -42 177 20 16 31 87 366 87 410 0 70 -86 122 -155 94z\"\/><path d=\"M1751 3234 c-13 -9 -29 -31 -37 -50 -12 -29 -10 -49 21 -204 19 -94 39 -189 45 -210 14 -50 54 -80 110 -80 34 0 48 6 76 34 21 21 34 44 34 59 0 14 -18 113 -40 219 -37 178 -43 195 -70 221 -36 32 -101 37 -139 11z\"\/><path d=\"M1163 3073 c-36 -7 -73 -59 -73 -102 0 -56 133 -378 171 -413 34 -32 83 -37 129 -13 70 36 67 87 -16 290 -86 209 -89 214 -129 231 -35 14 -42 15 -82 7z\"\/><path d=\"M3689 3066 c-15 -9 -33 -30 -42 -48 -48 -103 -147 -355 -147 -375 0 -98 131 -148 192 -74 13 15 57 108 97 206 80 196 84 226 37 273 -30 30 -99 39 -137 18z\"\/><path d=\"M583 2784 c-38 -19 -67 -74 -58 -113 9 -42 211 -354 242 -373 16 -10 45 -18 66 -18 51 0 107 52 107 100 0 39 -1 41 -124 234 -80 126 -108 162 -133 173 -41 17 -61 16 -100 -3z\"\/><path d=\"M4250 2784 c-14 -9 -74 -91 -133 -183 -95 -150 -107 -173 -107 -213 0 -55 33 -94 87 -104 67 -13 90 8 211 198 130 202 137 225 78 284 -27 27 -42 34 -72 34 -22 0 -50 -8 -64 -16z\"\/><path d=\"M2275 2693 c-553 -48 -1095 -270 -1585 -649 -135 -104 -459 -423 -483 -476 -23 -49 -22 -139 2 -186 73 -142 361 -457 571 -626 285 -228 642 -407 990 -497 242 -63 336 -73 660 -74 310 0 370 5 595 52 535 111 1045 392 1455 803 122 121 250 273 275 326 19 41 19 137 0 174 -41 79 -309 363 -465 492 -447 370 -946 591 -1479 653 -113 14 -422 18 -536 8z m395 -428 c171 -34 330 -124 456 -258 112 -119 167 -219 211 -378 27 -96 24 -300 -5 -401 -72 -255 -236 -447 -474 -557 -132 -62 -201 -76 -368 -76 -167 0 -236 14 -368 76 -213 98 -373 271 -451 485 -162 444 86 934 547 1084 153 49 292 57 452 25z m909 -232 c222 -123 408 -262 593 -441 76 -74 138 -139 138 -144 0 -16 -233 -242 -330 -319 -155 -123 -309 -223 -461 -299 l-81 -41 32 46 c18 26 49 83 70 128 143 306 141 649 -6 957 -25 52 -61 116 -79 142 l-34 47 45 -20 c26 -10 76 -36 113 -56z m-2057 25 c-40 -58 -105 -190 -130 -263 -110 -324 -59 -707 132 -981 25 -35 42 -64 37 -64 -19 0 -241 119 -326 174 -188 122 -406 314 -532 468 l-58 71 108 103 c185 178 428 349 672 473 66 33 121 60 123 61 2 0 -10 -19 -26 -42z\"\/><path d=\"M2375 1950 c-198 -44 -350 -190 -395 -379 -18 -76 -8 -221 19 -290 114 -284 457 -406 731 -260 98 52 188 154 231 260 27 69 37 214 19 290 -38 163 -166 304 -326 360 -67 23 -215 33 -279 19z\"\/><\/g><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/www.howdoiuseacomputer.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[8],"tags":[10,119,4,118,19,17,116,18,6,7,117,5,120,121],"class_list":["post-437","post","type-post","status-publish","format-standard","hentry","category-powershell","tag-ad","tag-address","tag-azure","tag-azuread","tag-csv","tag-email","tag-excel","tag-export","tag-groups","tag-members","tag-output","tag-powershell","tag-upn","tag-userprincipalname"],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/www.howdoiuseacomputer.com\/index.php\/wp-json\/wp\/v2\/posts\/437"}],"collection":[{"href":"https:\/\/www.howdoiuseacomputer.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.howdoiuseacomputer.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.howdoiuseacomputer.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.howdoiuseacomputer.com\/index.php\/wp-json\/wp\/v2\/comments?post=437"}],"version-history":[{"count":12,"href":"https:\/\/www.howdoiuseacomputer.com\/index.php\/wp-json\/wp\/v2\/posts\/437\/revisions"}],"predecessor-version":[{"id":607,"href":"https:\/\/www.howdoiuseacomputer.com\/index.php\/wp-json\/wp\/v2\/posts\/437\/revisions\/607"}],"wp:attachment":[{"href":"https:\/\/www.howdoiuseacomputer.com\/index.php\/wp-json\/wp\/v2\/media?parent=437"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.howdoiuseacomputer.com\/index.php\/wp-json\/wp\/v2\/categories?post=437"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.howdoiuseacomputer.com\/index.php\/wp-json\/wp\/v2\/tags?post=437"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}