Skip to main content


Showing posts from February, 2020

Importing Data from Bromcom directly into a Google Sheet and updating it automatically

I support one school in the Trust that used Bromcom and was finding it a bit tricky to get the data directly into Sheets. However, I've sorted this now and thought this might prove useful to someone. Step 1 - The Bromcom Report Write your report (or pick an existing one). Click Run Report and then select “Live Data Feed”. Copy the URL it gives you. Step 2 - Your user name and password to access the report You need the site ID which is the username. You also need your “User Access Key”. To get this click top right and “My account” and you will see a box with this in. Make a note of these. Step 3 - Setup the Google Sheet Make a Google Sheet that is going to receive the data. Click on “Tools” then Script and paste in this code: function populateSheetWithCSV(sheet, csvUrl, user, pw) {   var resp = UrlFetchApp.fetch(csvUrl, {     headers: {       // use basic auth       'Authorization': 'Basic ' + Utilities.base64Encode(       user + &

Google MDM for Windows 10 Devices - a more in depth look.

In my previous blog post, I gave an overview of Google's new mobile device management for Windows 10 devices. A few weeks in now, we have a number of users using Windows computers managed this way. So below is a more detailed video look at deploying policies followed by some of the policies and how to configure them that we have used to date. Policy Settings It's important to note that unlike ChromeOS devices, you don't put machines into OUs, but the machines pick up policy based on the OU of the user used to enrol the device. OMA-URI policies we use: AllowManualMDMUnenrollment ./Device/Vendor/MSFT/Policy/Config/Experience/AllowManualMDMUnenrollment Integer 0 This prevents users from unenrolling a device. AllowVPN ./Device/Vendor/MSFT/Policy/Config/Settings/AllowVPN Integer 0 Prevents editing the VPN settings PageVisibilityList ./Device/Vendor/MSFT/Policy/Config/Settings/PageVisibilityList string hide:network-vpn Can be used to hide bits of the set