Office 365: How to export all the Active Directory licensed users via PowerShell
In many case, it could be useful to export in CSV all the licensed users existing into the Azure ActiveDirectory. I create that script to run this kind of request adding the following properties (you can easily adapt it if you need more): UserPrincipalName: Tenant login DisplayName: User Display Name AADCountryName: Countryname defined in Azure AD UserLocationCountryName: Country name of the AAD property UsageLocation UsageLocationCountryCode: ISO Format of the AAD property UsageLocation [string]$username = "YourAdminAccount@YourTenant.onmicrosoft.com" [string]$PwdTXTPath = "D:\SECUREDPWD\ExportedPWD-$($username).txt" $isoCountries = @{ "AF" = "Afghanistan"; "AX" = "Aland Islands"; "AL" = "Albania"; "DZ" = "Algeria"; "AS" = "American Samoa"; "AD" = "Andorra"; "AO" = "Angola"; "AI" = "Anguilla"; "AQ" = "Antarctica"; "AG" = "Antigua And Barbuda"; "AR" = "Argentina"; "AM" = "Armenia"; "AW" = "Aruba"; "AU" = "Australia"; "AT" = "Austria"; "AZ" = "Azerbaijan"; "BS" = "Bahamas"; "BH" = "Bahrain"; "BD" = "Bangladesh"; "BB" = "Barbados"; "BY" = "Belarus"; "BE" = "Belgium"; "BZ" = "Belize"; "BJ" = "Benin"; "BM" = "Bermuda"; "BT" = "Bhutan"; "BO" = "Bolivia"; "BA" = "Bosnia And Herzegovina"; "BW" = "Botswana"; "BV" = "Bouvet Island"; "BR" = "Brazil"; "IO" = "British Indian Ocean Territory"; "BN" = "Brunei Darussalam"; "BG" = "Bulgaria"; "BF" = "Burkina Faso"; "BI" = "Burundi"; "KH" = "Cambodia"; "CM" = "Cameroon"; "CA" = "Canada"; "CV" = "Cape Verde"; "KY" = "Cayman Islands"; "CF" = "Central African Republic"; "TD" = "Chad"; "CL" = "Chile"; "CN" = "China"; "CX" = "Christmas Island"; "CC" = "Cocos (Keeling) Islands"; "CO" = "Colombia"; "KM" = "Comoros"; "CG" = "Congo"; "CD" = "Congo, Democratic Republic"; "CK" = "Cook Islands"; "CR" = "Costa Rica"; "CI" = "Cote D'Ivoire"; "HR" = "Croatia"; "CU" = "Cuba"; "CY" = "Cyprus"; "CZ" = "Czech Republic"; "DK" = "Denmark"; "DJ" = "Djibouti"; "DM" = "Dominica"; "DO" = "Dominican Republic"; "EC" = "Ecuador"; "EG" = "Egypt"; "SV" = "El Salvador"; "GQ" = "Equatorial Guinea"; "ER" = "Eritrea"; "EE" = "Estonia"; "ET" = "Ethiopia"; "FK" = "Falkland Islands (Malvinas)"; "FO" = "Faroe Islands"; "FJ" = "Fiji"; "FI" = "Finland"; "FR" = "France"; "GF" = "French Guiana"; "PF" = "French Polynesia"; "TF" = "French Southern Territories"; "GA" = "Gabon"; "GM" = "Gambia"; "GE" = "Georgia"; "DE" = "Germany"; "GH" = "Ghana"; "GI" = "Gibraltar"; "GR" = "Greece"; "GL" = "Greenland"; "GD" = "Grenada"; "GP" = "Guadeloupe"; "GU" = "Guam"; "GT" = "Guatemala"; "GG" = "Guernsey"; "GN" = "Guinea"; "GW" = "Guinea-Bissau"; "GY" = "Guyana"; "HT" = "Haiti"; "HM" = "Heard Island & Mcdonald Islands"; "VA" = "Holy See (Vatican City State)"; "HN" = "Honduras"; "HK" = "Hong Kong"; "HU" = "Hungary"; "IS" = "Iceland"; "IN" = "India"; "ID" = "Indonesia"; "IR" = "Iran, Islamic Republic Of"; "IQ" = "Iraq"; "IE" = "Ireland"; "IM" = "Isle Of Man"; "IL" = "Israel"; "IT" = "Italy"; "JM" = "Jamaica"; "JP" = "Japan"; "JE" = "Jersey"; "JO" = "Jordan"; "KZ" = "Kazakhstan"; "KE" = "Kenya"; "KI" = "Kiribati"; "KR" = "Korea"; "KW" = "Kuwait"; "KG" = "Kyrgyzstan"; "LA" = "Lao People's Democratic Republic"; "LV" = "Latvia"; "LB" = "Lebanon"; "LS" = "Lesotho"; "LR" = "Liberia"; "LY" = "Libyan Arab Jamahiriya"; "LI" = "Liechtenstein"; "LT" = "Lithuania"; "LU" = "Luxembourg"; "MO" = "Macao"; "MK" = "Macedonia"; "MG" = "Madagascar"; "MW" = "Malawi"; "MY" = "Malaysia"; "MV" = "Maldives"; "ML" = "Mali"; "MT" = "Malta"; "MH" = "Marshall Islands"; "MQ" = "Martinique"; "MR" = "Mauritania"; "MU" = "Mauritius"; "YT" = "Mayotte"; "MX" = "Mexico"; "FM" = "Micronesia, Federated States Of"; "MD" = "Moldova"; "MC" = "Monaco"; "MN" = "Mongolia"; "ME" = "Montenegro"; "MS" = "Montserrat"; "MA" = "Morocco"; "MZ" = "Mozambique"; "MM" = "Myanmar"; "NA" = "Namibia"; "NR" = "Nauru"; "NP" = "Nepal"; "NL" = "Netherlands"; "AN" = "Netherlands Antilles"; "NC" = "New Caledonia"; "NZ" = "New Zealand"; "NI" = "Nicaragua"; "NE" = "Niger"; "NG" = "Nigeria"; "NU" = "Niue"; "NF" = "Norfolk Island"; "MP" = "Northern Mariana Islands"; "NO" = "Norway"; "OM" = "Oman"; "PK" = "Pakistan"; "PW" = "Palau"; "PS" = "Palestinian Territory, Occupied"; "PA" = "Panama"; "PG" = "Papua New Guinea"; "PY" = "Paraguay"; "PE" = "Peru"; "PH" = "Philippines"; "PN" = "Pitcairn"; "PL" = "Poland"; "PT" = "Portugal"; "PR" = "Puerto Rico"; "QA" = "Qatar"; "RE" = "Reunion"; "RO" = "Romania"; "RU" = "Russian Federation"; "RW" = "Rwanda"; "BL" = "Saint Barthelemy"; "SH" = "Saint Helena"; "KN" = "Saint Kitts And Nevis"; "LC" = "Saint Lucia"; "MF" = "Saint Martin"; "PM" = "Saint Pierre And Miquelon"; "VC" = "Saint Vincent And Grenadines"; "WS" = "Samoa"; "SM" = "San Marino"; "ST" = "Sao Tome And Principe"; "SA" = "Saudi Arabia"; "SN" = "Senegal"; "RS" = "Serbia"; "SC" = "Seychelles"; "SL" = "Sierra Leone"; "SG" = "Singapore"; "SK" = "Slovakia"; "SI" = "Slovenia"; "SB" = "Solomon Islands"; "SO" = "Somalia"; "ZA" = "South Africa"; "GS" = "South Georgia And Sandwich Isl."; "ES" = "Spain"; "LK" = "Sri Lanka"; "SD" = "Sudan"; "SR" = "Suriname"; "SJ" = "Svalbard And Jan Mayen"; "SZ" = "Swaziland"; "SE" = "Sweden"; "CH" = "Switzerland"; "SY" = "Syrian Arab Republic"; "TW" = "Taiwan"; "TJ" = "Tajikistan"; "TZ" = "Tanzania"; "TH" = "Thailand"; "TL" = "Timor-Leste"; "TG" = "Togo"; "TK" = "Tokelau"; "TO" = "Tonga"; "TT" = "Trinidad And Tobago"; "TN" = "Tunisia"; "TR" = "Turkey"; "TM" = "Turkmenistan"; "TC" = "Turks And Caicos Islands"; "TV" = "Tuvalu"; "UG" = "Uganda"; "UA" = "Ukraine"; "AE" = "United Arab Emirates"; "GB" = "United Kingdom"; "US" = "United States"; "UM" = "United States Outlying Islands"; "UY" = "Uruguay"; "UZ" = "Uzbekistan"; "VU" = "Vanuatu"; "VE" = "Venezuela"; "VN" = "Viet Nam"; "VG" = "Virgin Islands, British"; "VI" = "Virgin Islands, U.S."; "WF" = "Wallis And Futuna"; "EH" = "Western Sahara"; "YE" = "Yemen"; "ZM" = "Zambia"; "ZW" = "Zimbabwe" }; function GetCountryName ([string] $countryCode) { if ($isoCountries.Contains($countryCode)) { return $isoCountries[$countryCode].ToLower(); } else { return $countryCode.ToLower(); } } #GetCountryName "FR" import-module MSOnline $secureStringPwd = ConvertTo-SecureString -string (Get-Content $PwdTXTPath) $creds = New-Object System.Management.Automation.PSCredential -ArgumentList $username, $secureStringPwd connect-msolservice -credential $creds Get-MsolUser -All | Where-Object {$_.isLicensed -eq "True"} |Select-Object -Property UserPrincipalName, DisplayName, @{name='AADCountryName';Expression={$_.Country.ToLower()}}, @{name='UserLocationCountryName';Expression={GetCountryName($_.UsageLocation)}}, @{name='UsageLocationCountryCode';Expression={$_.UsageLocation}} | Export-Csv -Path "Office365AzureADLicensedAccounts.csv" You will have the CSV file to use as you need into your favorite Excel tool. Fabrice Romelard [MVP]
Where to create an Office 365 group?
Right now there are LOTS of places you can create a new 365 Group from. Just to name a few I know of: Azure AD - Directly create a group SharePoint Team Site - Creates a group along with the site Microsoft Teams - Creates a group along with the team (can also make team from existing group) There are quite a few more ways that groups can get instanced, but the real issue here is the lack of symmetry. When a group is created, it gets a SharePoint Team Site regardless of where you make it, but if you make the group as a part of the process of making a new team site you can also select a site design to apply to that site. I have read that site designs can be applied to existing modern sites, but have yet to find out how to do that. If you create a group in Teams, a team is added and linked to the group, but if you create a group anywhere else no team is added! I am trying to build a system where a new Office 365 Group for a new project is created, a specific SharePoint site design/template is provisioned, and a Team is provisioned. Some other configurations are done using the site design script -> launch a flow feature. Can anyone help me understand where the "proper" place to first create a group is? Especially so that there are no lingering loose connections between services? This all seems like a bit of a mess right now.
