SOLVED

i need to export users in powershell with centricaplc.onmicrosoft.com domain and are licenced

Copper Contributor

i need to export users in powershell with centricaplc.onmicrosoft.com domain and are licenced

 

i tried this command doesnt work

 

Get-MsolUser -All | Where-Object {$_.Domain -eq "centricaplc.onmicrosoft.com"} | Export-CSV c:\support\cloud.csv

 

i tried doing this via the admin portal but that does not work!

4 Replies

You are comparing against a "domain" property, which does not exist. Try something like this instead:

 

Get-MsolUser -All | ? {$_.UserPrincipalName.Split("@")[1] -eq "centricaplc.onmicrosoft.com"}

 

 

best response confirmed by pardeep soba (Copper Contributor)
Solution

You can try this script

 

Get-MsolUser -All |Where-Object {$_.UserPrincipalName -like "*centricaplc.onmicrosoft.com" -and $_.isLicensed -eq $true } |Export-csv c:\support\cloud.csv -NoTypeInformation

how do i also include the account skuid information?

1 best response

Accepted Solutions
best response confirmed by pardeep soba (Copper Contributor)
Solution

You can try this script

 

Get-MsolUser -All |Where-Object {$_.UserPrincipalName -like "*centricaplc.onmicrosoft.com" -and $_.isLicensed -eq $true } |Export-csv c:\support\cloud.csv -NoTypeInformation

View solution in original post