SharePoint – Online ActiveX in Chrome Browser

January 8, 2018

Since I migrated my Hard and Software Inventory Scripts to SharePoint Online.

I felt the need to check if I could run it in the Chrome Browser as well … ?

Solution :

Step 1. Is to configure Chrome to accept ActiveX Scripts

Open Chrome and go to Settings –> Advanced Options –> Proxy Settings


Go to the Security Tab –> Add you SharePoint Online site to the TRUSTED Sites

Next go to Custom Level –> Change the following ActiveX settings


Safe and restart Chrome

Step 2. Is to download IETab Extension for Chrome


Once installed is will ask you to run a local exe called ietabhelper.exe

And it will show you the Extension Icon here :


Step3. Run it and test the Result

Go to the Hardware Inventory Tool in SharePoint Online and click Get Info


As you can see it retrieved all the details, to be saved in the SharePoint Online Cloud using the Chrome Browser

How cool is that Smile Smile


SharePoint – Online Computer Inventory

January 8, 2018

Nearly 5 years ago I converted the Outlook forms to an on premise SharePoint 2010 Foundation version

But now it’s time to migrate to Office365 – SharePoint Online !

Basically all of the scripting done in SP 2010 can be reused in the Online version.

Solution :

Step 1. I created a new Custom List in SP Online

With the exact same fields and field names as in SP 2010.

Step 2. I created the new SP Online Custom Forms

These where created from scratch again

Step 3. I migrated the JavaScript / JQuery Scripts

I adjusted the scripts where needed (very little efforts neededs)

Step 4. Tested the results

New Form :


When pressing Get Info, it will check if it can find the PC or Server in your network.

If the field is blank it will present an error message and the button will go RED.

In the other occasion the button will show GREEN.


Extra logic in the script will check disk Capacity and show RED if below 10 % free space.

Edit Form :


Using the EDIT form you can just refresh the data at all times, even if you make a remote VPN to your network.

GREEN means all data has been updated.

Display Form :


Once all Hardware is loaded you can have the bonus effect to have this info available using the SharePoint Mobile App.

So all the data is at your fingertips wherever you are.

Migrating and reusing this logic from MS Exchange Forms to SharePoint Online over more then 15 years, is very rewarding.

Isn’t that cool Smile

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 – 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 !