Windows 10 – Disable Automatic Updates

January 26, 2018

How to disable Windows 10 Automatic Updates …

Solution :

1. Open the Registry

Go to Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows

2. Add 2 Keys

Add Key WindowsUpdate and Sub Key AU

3. Add DWORD Value

Value Options are :

2 =  “Notify for download and notify for install.”
3 = “Auto download and notify for install.”
4 = “Auto download and schedule the install.”
5 = “Allow local admin to choose settings.”

Take 2 = “Notify for download and notify for install.”

Result looks like this.


Reboot and this will be applied.

Enjoy !

Windows 10 – How to install Linux Subsystem

January 19, 2018

1. First start activate the Developer mode.

Windows Settings –> Update & Security


Activeate –> Developer Mode


2. Activate the Windows Feature –> Subsystem for Linux


3. Open CMD and run the command BASH


As you can see we don’t have the Linux Subsystem available … ?

4. Start the CMD again as Administrator.

And this command : lxrun /install /y


5. Start the Linux SubSystem using the command BASH


How to install MONO (.NET framework) on Bash – Ubuntu see here :

Windows Core IoT – NodeJS on a Raspberry PI3

January 15, 2018

Running Windows IoT on a RPI3 is just fun.

To get started some of my previous posts here

Anyhow I wanted to run a webserver on the RPI3… I checked around and one of the most obvious is running NodeJS on a RPI3.

The main advantages are that is that NodeJS is cross platform supported and needs a small memory footprint.

Solution :

1 NodeJS-ChaKaCore

Here : //

2. Create a folder on your RPI3

Once download create a connection to your RPI3 and create a folder, like NodeJS

3. After this open the Downloaded ZIP step 1.

    And copy the all the files to the C:\NodeJS on your RPI3, except the SDK folder.


4. Create a JavaScript to start the Webserver.

Save it as Server.js on the C:\NodeJS folder


var http = require('http');

http.createServer(function (req, res) {
    res.writeHead(200, { 'Content-Type': 'text/plain' });
    res.end('Hello World\n');

5. Open the RPI3 Firewall Access

netsh advfirewall firewall add rule name="Node.js" dir=in action=allow program="C:\NodeJS\node.exe" enable=yes 

6. Start the WebServer


.\node.exe .\Server.js 

6. Test the connection to your new RPI3 WebNerver

Open a local Browser and test the connection to your http://RPI3:1337

Installing NodeJS Add-on Packages / Modules

Packages or Modules are extensions for NodeJS, see here for more details.

After installation check the version like this :


.\npm -v

1. Use NMP to download the required Packages or Modules

I tried this using the PowerShell remote connection … but that did not work.

Solution is to install NodeJS on your Local PC and grab the Modules.

Example : upper-case package


Error : ‘node’ is not recognized as an internal or external command


Wen running into this error run the command below.

Solution  : SET PATH=C:\Nodejs;%PATH%

2. Copy to the RPI3 NodeJS\node_modules directory


3. modify the Server.js JavaScript

Example : module upper-case


Notice the extra line require(‘upper-case’)

var http = require('http');
var uc = require('upper-case');

http.createServer(function (req, res) {
    res.writeHead(200, {'Content-Type': 'text/html'});
    res.write(uc("Hello World!"));

4. Test the result


Notice the response is in capital letters !

Enjoy !

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 HW & SW 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 JavaScripts 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

SharePoint–Online Publish a Power BI report (Personal Ed.)

January 5, 2018

Ever wanted to publish a Power BI report to SharePoint Online ?

Which is not out of the box functionality (It is for the PRO version of Power BI)


Solution :

Step 1. Get the link of the report

In your Power BI environment go to the report to publish –> File –> Publish to Web


Next copy the link code ….


Step 2. Create a Web Part Page


Add a Page Viewer Web Part


And add the Report link from Step 1.


Step 3. Save the page and see the result




Of course this does not give you all the full features of the Power BI Pro version.

But can be good enough to do some prototyping or publishing BI information.


Bonus is the fact that it will update automatically based on the Power BI Schedule frequency Smile


PS : Keep in Mind that your Tenant Admin needs to give you permission to Publish to the Web





SharePoint–Online Publish a Power Pivot Excel file using a SalesForce Datasource

January 5, 2018

I was wondering if it was possible to use the (older) Power Pivot that had a SalesForce Datasource.

And publish it to SharePoint Online ?

Step 1. Connect to SalesForce using Power Query

Once the data source is filtered, formatted, …


Safe the Excel file… it stores automatically the data as a Power Pivot Data source.

Step 2. Create a Report Library

In your O365 SharePoint Online create a Report LibrarySs


Step 3. Save the file to the Library



Step 4. Next Create a Web Part Page


And add a Business Data WebPart


Point to the Excel in the Report Library.


Enjoy !