Tools

A very quick tip today: When using an Azure Logic App in combination with an Azure SQL Database, filtering rows can be done like here. As example: A T-SQL query as this one… SELECT - FROM [dbo].[Customers] WHERE [StorageDataSentDate] IS NULL ORDER BY [Id] …will be formulated as filter expression with an OData query as here. The definition for the Get_rows_(V2) action looks similar as here: … "Get_rows_(V2)": { "inputs": { "host": {"connection": {"name": "@parameters('$connections')['sql']['connectionId']"} }, "method": "get", "path": "/v2/datasets/@{encodeURIComponent(encodeURIComponent('[someserver].database.windows.net'))}, @{encodeURIComponent(encodeURIComponent('governancetoolkit365'))}/tables/ @{encodeURIComponent(encodeURIComponent('[dbo].[Customers]'))}/items", "queries": {"$filter": "(StorageDataSentDate eq null)", $orderby": "Id"} }, "runAfter": {"Initialize_variable": ["Succeeded"]}, "runtimeConfiguration": { "paginationPolicy": {"minimumItemCount": 5} }, "type": "ApiConnection" }, … Depending on the data size, remember to configure pagination. ...

Delegate365 version 8.4 came up with a lot of improvements and updates. This version recently got another update to speed up the license assignment synchronization operation. See the details here. Delegate365 allows to add sync rules to the sync operation to automate specific operations. In large tenants, the sync can run for a long time since all objects must be queried for changes. To accelerate the sync operation when using license assignment sync rules, we optimized this process as follows: ...

Modern websites and website templates use Cascading Style Sheets (CSS) intensively. To load websites faster, it makes sense to reduce these files to the essential content. You can do that with many tools. PurgeCSS is one of them. See the How To here. I wanted to optimize a small, static one-pager website. I used a HTML5 template with Bootstrap 4. Nothing very fancy, but simple and modern. All my tests ran against my localhost. ...

When installing a new computer, it takes some time to download and install the essential software. This is what Chocolatey is for. Chocolatey is a cost free package manager for Windows using NuGet infrastructure and PowerShell to quickly installing applications and tools that you need. I am using choco since a long time, now I wanted to show my current packaged software for my new computer. See the script here. About and Prerequisites Partly taken from About Chocolatey: Chocolatey CLI aka choco (or choco.exe) is a client that provides the core of Chocolatey and the installation store for locally installed packages. You need to have Windows 7+ or/ Windows Server 2003+ as Operating System and PowerShell v2+ (not PowerShell Core yet though) and the .NET Framework 4+ installed. Just to mention, the installation will attempt to install .NET 4.0 if you do not have it installed, see choco installation and Getting Started. Besides the client, there also exists a Chocolatey GUI and Chocolatey Agent (aka chocolatey-agent) for central administration. ...

Delegate365 v8.4 brings a bunch of new features and improvements. Office 365 Groups management allows to teamify existing groups and to control all Teams settings including policy settings. The Sync Job can send warnings if many objects are deleted, Shared Mailboxes and Resource Mailboxes licenses can be removed, Reports can be directly downloaded, Room Lists are available, License Orders can be exported and much more. See a description of the new features here. ...

Yesterday, I wrote how to Update your Azure CLI with Choco. Today, I needed to renew an existing Service Principal Name in an AAD. A SPN stands for Service Principal Name which is used for automation authentication. The PowerShell az module got some updates (v1.0.0). So, here´s the full step-by-step instruction for renewing a SPN with az ad sp credential. This updates the steps described at How to create or renew Service Principal Names in Azure Active Directory… ...

I use Azure CLI from time to time. So, it´s a good idea to update that module… For example, I use Azure CLI for renewing SPN´s a described at How to create or renew Service Principal Names in Azure Active Directory. When I checked the latest version with az --version , I saw my outdated version: “You have 52 updates available. Consider updating your CLI installation.” So, the best method is to use Chocolatey - The package manager for Windows in an elevated command prompt as described at Azure CLI. To make it short: Simply run ...

The next version of Delegate365 v8.3 is here. This major version brings some new features as “Sync with security group”, bulk assignments, list export, improved OU management, and many further features and fixes. See the details here. Upgrading from Delegate365 version 8.2 does not require running a new setup. Upgrading from any other Delegate365 version, requires to (Re)run the setup. New Sync Rule “Sync with security group”: This new feature in Administration / Sync rules allows to remove users from an OU automatically based on their security group membership. See how this works in detail at Sync with Group. We hope this new sync feature helps improving your users organization based on security group memberships in Delegate365. ...

At Microsoft Ignite conference last September, we demoed an approach for a self-built Office 365 Groups Governance Toolkit. Since Microsoft 365 is an evergreen service and continues to evolve, today we have more group settings available and we extend our provisioning function to work with group naming policies as well. See here how this can be accomplished by including new Graph requests. Foreword You can find the previous articles of our governance story at Provisioning an Office 365 group with an approval flow and Azure functions-part 1, part 2, part 3, part 4, part 5 and part 6 and the source code at martinagrom/Ignite2018GroupsGovernanceToolkit. ...

With Delegate365 v8.3 there comes a new feature in the Sync Rules: Sync with security group allows to automatically remove users from an OU. See how this works here. This is a feature request brought to us by Delegate365 customers: When a user is removed from a security group, he or she should also automatically be removed from the corresponding OU, if the User sync rules are set to “Security group”. So here´s a description of that feature with a sample (improved Delegate365 Admins can have a look at step1 and then continue with step 7)… ...