Office 365 in Arabic - Arabization – Part V

Article
02/09/2015

In the previous part I’ve explained the Arabic dynamic distribution groups, in this part we will discuss the reporting.

Reporting

First question you will get after setting up the tenant and create the users will be: I need list of all users with a specific parameter.

The main cmdlet here is Export-Csv this cmdlet can be used to export the result to the CSV file:

I need list of all licensed users

Get-MsolUser | Where-Object {$_.isLicensed -eq "TRUE"} | Export-Csv d:\licensedUsers.csv

In the above cmdlet:

1. First part we are getting all users.

2. Second part is to filter users with parameter islicensed=true

3. Export the list of users to the CSV file.

Let’s open the result file in notepad:

We have a lot of problems:

1. Arabic is “?????” so the file isn’t useful. The default format is ASCII so we need to make it Unicode.

2. The first line is listing the .Net Object Type.

3. Also there a lot of not needed values like the first column.

So let’ make some modification to the cmdlet:

Get-MsolUser | Where-Object {$_.isLicensed -eq "TRUE"} | Select-Object -property "UserPrincipalName" | Export-Csv -Encoding unicode d:\licensedUsers.csv -NoTypeInformation

In the above cmdlet:

1. The third part is added for the filtered users we select the following properties: UserPrincipalName and Department.

2. In the last part for the exported CSV file we set the encoding to Unicode instead of ASCII (the default value).

3. And to remove the .Net value we have added –NoTypeInformation

And the result as follows:

Now the file can be useful for reporting, so let’s see more examples:

I need List of all users with department “ ????? ”:

Don’t forget that you will need PowerShell ISE for Arabic support (review the previous parts).

Get-MsolUser -Department "?????" -all | Select-Object -Property "*princip*",displayname,department |Export-Csv -Encoding unicode -Path d:\?????.csv -NoTypeInformation

All the attributes can be used in Select-Object so we can decide what will be exported.

Let’s add Exchange to the equation:

I need list of users with department “ ????? ” and with mailbox size for each one:

First we will need to connect to Exchange Online as explained in the previous part (Part IV: Dynamic Distribution Group)

Let’s try the following cmdlet:

Get-MsolUser -Department "?????" -all | ForEach-Object {Get-MailboxStatistics -Identity $_.userprincipalname} | Select-Object -Property displayname,"lastlogo*",totalitemsize,storagelimit* | Export-Csv -Path d:\?????.csv -NoTypeInformation -Encoding unicode

Note the following:

1. –all in the first part to get all users, when you have large number of users.

2. Second part we executed get-mailboxstatistics which will return a lot of information.

3. Third part we will select from the returned result only lastlogon and totatitemsize and storagelimit.

Let’s check the result: