Bienvenue à Blogs CodeS-SourceS Identification | Inscription | Aide

Blog Technique de Romelard Fabrice

Les dernières Actualités de Romelard Fabrice (Alias fabrice69 ou F___) principalement autour des technologies Microsoft

Actualités

  • Toutes les actualités et informations sur les technologies Microsoft principalement autour de .NET et SQL Server

Archives

Office 365: Comment exporter tous les comptes Azure Active Directory ayant une license via PowerShell

Basé sur les pages suivantes:

Voici un script PowerShell permettant de sortir un fichier CSV ayant tous les comptes utilisateurs de votre tenant avec les propriétés suivantes (vous pouvez l’adapter selon votre besoin):

  • 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"

Excel sera alors votre meilleur ami pour travailler ce fichier selon votre besoin.

English version available here:

Fabrice Romelard [MVP]

Ce post vous a plu ? Ajoutez le dans vos favoris pour ne pas perdre de temps à le retrouver le jour où vous en aurez besoin :
Posted: jeudi 17 mai 2018 13:46 par ROMELARD Fabrice

Commentaires

Pas de commentaires

Les commentaires anonymes sont désactivés

Les 10 derniers blogs postés

- Reprise des articles Codes-Sources de 2011 à 2013 par Blog de Jérémy Jeanson le 08-21-2018, 16:08

- Office 365: Modifier les jeux de couleur dans les Thèmes des pages classiques de SharePoint Online par Blog Technique de Romelard Fabrice le 08-08-2018, 17:27

- Office 365: Modifier les jeux de couleur dans les Thèmes des pages modernes de SharePoint Online par Blog Technique de Romelard Fabrice le 07-04-2018, 13:26

- Office 365: Script PowerShell pour fixer le Quota Warning de toutes les collections d’un tenant par Blog Technique de Romelard Fabrice le 07-03-2018, 14:16

- MVP Award 2018-2019 par Blog de Jérémy Jeanson le 07-02-2018, 20:39

- Reprise des articles de 2014 à aujourd’hui par Blog de Jérémy Jeanson le 06-20-2018, 13:00

- Office 365: Comment créer un sous-plan dans Office 365 Planner par Blog Technique de Romelard Fabrice le 06-14-2018, 17:19

- Office 365: Script PowerShell de création de sous-sites basés sur CSOM ou PnP par Blog Technique de Romelard Fabrice le 06-12-2018, 14:58

- Office 365: Comment exporter tous les comptes Azure Active Directory ayant une license via PowerShell par Blog Technique de Romelard Fabrice le 05-17-2018, 13:46

- PowerShell: Comment avoir le Country Name depuis un Country Code par Blog Technique de Romelard Fabrice le 05-17-2018, 13:20