Author: mattkirbylondon

  • Remote Desktop web client errors after TLS/SSL certificate update – how to fix

    We make heavy use of Remote Desktop web and the HTML 5 client. However – whenever the TLS/SSL certificate is updated, we used to get service desk calls saying people can’t login, with the error “Your session ended because an unexpected server authentication certificate was received from the remote PC”: The usual “fix” offered is…

    Screenshot of error message from Remote Desktop Web
  • Hide Automate Button in SharePoint List CommandBar with JSON

    , ,

    A while ago I was playing with a Sharepoint list for generating data sharing contracts, and added a context-sensitive button in a column to trigger a flow. This would send the data to AdobeSign to fill into a template, and set off a signing process. Since then I’ve found a whole collection of JSON snippets…

    Screenshot of menu option in a SharePoint list
  • Enhance SharePoint Lists with JSON Snippets for Advanced Formatting

    , ,

    This will be less of a blog post – and more of a place for me to save a useful resource so I can find it again: https://github.com/pnp/List-Formatting This is a collection of JSON snippets to add enhanced formatting for SharePoint lists. Why? Let me give you an example. Currently I’m moving our cyber risk…

    Screenshot of SharePoint list showing custom formatting for a "high medium low" option
  • CrowdStrike – there but for the grace…

    , ,

    I’m writing this a few days after the global IT outage that pulled TV stations off the air, grounded planes, and made it tricky to purchase your morning coffee. And more seriously prevented 911 calls from working in Alaska. Where I work was largely unaffected. Our servers kept running, payments kept being processed, and staff…

  • Power Automate and the missing headers

    ,

    I’ve been using Power Automate with a Custom Connector to our on-prem CRM to do various automation things. We recently ran a CRM update – which necessitated creating a new Power Automate custom connector as the API definition changed. Our CRM does provide a Swagger file – but it’s too large for Power Automate (around…

    Screenshot of JSON header details
  • Disable “stale” user accounts for Office 365 and on-prem hybrid

    , ,

    We recently had a cyber audit at work – and one of the recommendations was to ensure that any user accounts not used within 90 days were disabled. Prior to us moving to Office 365 hybrid we did have an on-prem tool that would do this for us, checking on-prem domain controllers for last login…

    Screenshot of Notepad++ showing the code for my DisableStaleAccounts.ps1 script
  • When product renaming and auto-updating f**k things up

    A quick and dirty post today – in short – if you think you are using Azure App Proxy, and all-of-a-sudden your users are reporting Gateway Timeout error – check if your on-prem Azure App Proxy services are stuck. Kill any errant processes, you’ll see these stuck services disappear, and then you’ll have new services…

    Screenshot of a Gateway Timeout error message
  • SQL backup to Azure URL Blob: “Operating system error 50(The request is not supported.)”

    ,

    I wanted to setup an on-premises SQL server to backup directly to Azure Blob storage, using Microsoft’s walk-through: https://learn.microsoft.com/en-us/sql/relational-databases/tutorial-use-azure-blob-storage-service-with-sql-server-2016?view=sql-server-ver16. However, there is a mistake in the provided Powershell script – so things won’t work as expected. TLDR; Script truncates Shared Access Signature – add “s” at start of SECRET The script on the above page…

    Snippet of code
  • Should we sell an NFT?

    ,

    No. Or at least that’s my opinion! NFTs are the new thing – and there’s money to be made – so should cultural organisations be “minting” NFTs? NF what? Firstly – what is an NFT? “Non-fungible tokens” are an attempt to offer a way of proving ownership over a digital asset. Proving ownership over physical…

    Some Bored Apes
  • My supplier has been compromised – should I still use them?

    , ,

    One of our suppliers was recently hit with a ransomware attack (or “cyber incident” as the new euphemism has it). As a result their systems were offline for several weeks. During this time they were relatively open to their customers about what had happened – they acknowledged it was ransomware, that they were in discussions…