Office 365 – Email Usages Reports in the Admin Portal

November 24, 2017

When running Email usage reports in the Office 365  Admin Portal.

Gives you the names of the users in a disguised format by default.


You can change this : Settings –> Services & Add-Ins –> Reports

Read the rest of this entry »


SharePoint – Enable Special Characters for OneDrive4Business Sync

November 14, 2017

When you have users that have Errors syncing file using the latest OD4B client.

It might be that there are some special characters like # and %.

That are in the file name, and are not supported by default.



Connect to the SharePoint Online Management Shell Using PowerShell.

These commands require version 16.0.6323.1200 of the SharePoint Online Management Shell or greater.

Run this command to see the current status



When you see NoPreference, you need to run this command.

Set-SPOTenant -SpecialCharactersStateInFileFolderNames Allowed


Keep in mind that it will about 2 hours or more before it gets active ….

If it still does not work you can run this procedure to force it :

If OneDrive sync seems to be stuck for a long time and nothing else is working, try a reset.

Be aware that resetting OneDrive re-syncs all your OneDrive files, which could take some time depending on how many files you’re syncing.
Press  WinKey + R

In the Run window, enter: %localappdata%\Microsoft\OneDrive\onedrive.exe /reset

After reset the OneDrive, files with special characters (# %) were synced properly.


PS : See here for more info

Enjoy !

MS SQL – Query & Reporting Tools

November 11, 2017

Getting data out of a Database hasn’t been easier these days. Giving all the tools you have at your disposal…

Giving the fact that all the fuss about BI and Cloud Storage, Big Data etc. We seem to loose feeling with all the o


Here are a few examples we can use for simple and complex query and reporting purposes.

1. Query using the MS SQL SSMS

It’s obvious that SQL SSMS offers all the functionality you need to get the data out of the database.

This example shows a combination of Common Table Expression (CTE) Query combined with the PIVOT function, to generate you dataset.


2. Using PowerShell – Query

Re-using this quite complex Query using Scripting language is quite Powerful.



3. Excel – Query

Using Excel combined with MS Query we can re-use the same Query





4. Access – Pass-Through Query

Re-using the complex query using MS Access in a Pass-Through Query Statement.




5. MS SQL Reporting Services

Re-using the complex query using MS SQL Reporting Services & Report Builder



6. MS PowerPivot – Excel Addin

Re-using the complex query using MS Power Pivot – Addin






7. MS Power BI

Re-using the complex query using MS Power BI



This is not a limit list of tools you have a hand. There many more which you might overlook …

QlikView Client

MS Power Query

– …

For getting data out of a database you need to the proper tools, but this is not a constraint at the moment.

What is, is being able to manage all these different applications and technologies.

Bottom-line is that one you spend efforts in getting your queries right you can re-use them most any tool that comes around Smile

PowerShell – Azure Cloud Shell for PowerShell and Bash

November 3, 2017

Microsoft recently released a new feature called Azure Cloud Shell (for PowerShell and Bash).

To get started you need to log into the Azure Portal.

1. Click this icon


2. Choose Bash or PowerShell


3. Subscribe

This wil create an Azure File Storage to store your scripts


File Storage

Azure Files offers fully managed file shares in the cloud that are accessible via the industry standard Server Message Block (SMB) protocol.

Azure File shares can be mounted concurrently by cloud or on-premises deployments of Windows, macOS, and Linux.

Azure Files enable sharing files between applications running in your virtual machines using familiar Windows APIs or File REST API. Additionally,

Azure File Sync allows caching and synchronization of Azure Files shares on Windows Servers for local access.


Once created you can access all Azure resource using PowerShell or Bash resources.

And the scripts will be available online using your PC or even on a Mobile device !


Read more here :

Or watch this movie


PowerShell – Import-Pssession is not Importing Cmdlets for O365 Exchange Online

August 30, 2017


I noticed that after connecting to O365 Exchange Online using PowerShell, the connection was done OK.

But I could recognize any of the Cmdlets after connecting Sad smile



$LiveCred = Get-Credential -credential ""
   $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri -Credential $LiveCred -Authentication Basic -AllowRedirection
Import-Module (Import-PSSession $Session -WarningAction SilentlyContinue -AllowClobber) -Global 


As you can notice you need to add the Import-Module( … –AllowClobber) –Global Command and Parameters …

Enjoy !

QlikView – How to get MS Azure – Office365 BI Reports

February 3, 2016

QlikView Desktop is one of the leading BI In Memory Visualization Tools.

As I have shown in previous posts, this contains a VBScript host engine. And as well the Desktop Client is fully COM Compatible.

Giving these 2 nice bonus points for us scripters Smile

Let see how to use QlikView to provide BI Insights in your MS Azure and Office365 environment.

In the Office365 Admin portal, you can get nice statistics to analyze issues and performance if needed.


But QlikView can serve you better ! Because it is all centralized in your dashboard that is fully customizable Winking smile


Since it is all in memory, it is lightning fast to do your analysis. If you schedule the QVW you have it all ready each morning.

I built this proof of concept, and will be gradually ad more statistics.

See here for more info on Office365 Reporting web service

Happy Scripting !

Windows – AD Sync Msoidentitycrl Tracing Growing Rapidly

June 3, 2015

At some point I was surprised to see that my C: Drive on the production server was filling up rapidly ? Sad smile


After a quick analysis I saw that the reason was 40 Gb of msoidtrace tracing log files ?


After checking a bit deeper I could see that these where coming from the AD Sync Services we had installed lately.

Solution :

After applying the proper registry keys


And restarting the service “Microsoft Online Services Sign-in Assistant”


The problems where gone Smile

Read more here.

Enjoy !