HR Manager -you got help!

Here is the >PS script to help HR! the Excel file inside Office365 for full control on the users. Get full control on licenses, whos leavin’ (your’ fired!) and whos hired, lisenses and assets.
PART1:

We got an Excel file
image 

Managers can easyli add new users or modify existing users. (also you got versioning and Nintex WorkFlos to support that)
image
Put the users in to that Azure AD as a dude with approp access rights (aka admin guy)
Simply just run this PowerShell script. That uses WebDav to add the Office365 dimenzione to yor laptop.

And offcourse a full data report on the users you entered metadata from AzureAD, huraiiij you can use this to modify users attribs
image

I have no Idea why MS got IsBlackBerryUser attrib inside Azure
image
Here’s the PowerShell script:
#PART 1 – Connect to MSOL
$Cred = Get-Credential # Create a variable $cred
Connect-MsolService -Credential $cred
# E3, E5, Small Business etc
Get-MsolAccountSku
#
# lookilook
# Get-MsolUser

#PART 1 – Connect to MSOL
$Cred = Get-Credential # Create a variable $cred
Connect-MsolService -Credential $cred
# E3, E5, Small Business etc
Get-MsolAccountSku
#  leave those things in your bag
# Set working directory to maped drive
cd i:\
# PART2 Map network drive against O365
$mappath = ‘\\aspc2017.sharepoint.com@SSL\DavWWWRoot\SiteAssets’ #Replace yourtenant
        NET USE I: $mappath /PERSISTENT:YES
        Sleep -seconds 7  # this is just in case it takes a while
# PART 3 Bulkimport Users
# -DisplayName,FirstName,LastName,UserPrincipalName,Department,PassWord,UsageLocation,LicenseAssignment
#
$users = Import-Csv “Users.CSV”
$users | ForEach-Object {
New-MsolUser -DisplayName $_.DisplayName -FirstName $_.FirstName -LastName $_.LastName -UserPrincipalName $_.UserPrincipalName -Department $_.Department -PassWord $_.PassWord -UsageLocation $_.UsageLocation -LicenseAssignment $_.LicenseAssignment } | Export-Csv -Path “\UsersAdded\MatrixUsersCSV.csv” -NoTypeInformation
# PART 3 Bulkimport Users
# -DisplayName,FirstName,LastName,UserPrincipalName,Department,PassWord,UsageLocation,LicenseAssignment
#
$users = Import-Csv “Usersmore.CSV”
$users | ForEach-Object {
New-MsolUser -DisplayName $_.DisplayName -FirstName $_.FirstName -LastName $_.LastName -UserPrincipalName $_.UserPrincipalName -Department $_.Department -PassWord $_.PassWord -UsageLocation $_.UsageLocation -LicenseAssignment $_.LicenseAssignment } | Export-Csv -Path “\UsersAdded\MatrixUsersCSV.csv” -NoTypeInformation
# OPTIONAL PART 4 (Your’ fired says Donald, just simply delete users from the report file > achaaa that’s cool ai???
#####################
#XXX Bulk delete XXXX
#####################
# Remove the # if you like to delete the  users from the export file
#users = Import-Csv \usersadded\MatrixUsersCSV.csv
#$users| foreach-object {
#Remove-MsolUser -UserPrincipalName $_.userprincipalname -Force}
#
####
# XXX Delete non licensed users XXX
# Get-MsolUser -All -UnlicensedUsersOnly | Remove-MsolUser -Force

Thank You! Smilefjes