Skip to content

Instantly share code, notes, and snippets.

View clowa's full-sized avatar
🀯

Cedric Ahlers clowa

🀯
View GitHub Profile
@clowa
clowa / Workspace Usage Dashboard.lvdash.json
Created March 26, 2025 20:44
Databricks Workspace Usage Dashboard
{
"datasets": [
{
"name": "static_text",
"displayName": "static_text",
"query": "select\n 'Usage Analysis: Tag Matching' as title_tags,\n 'Usage Analysis: Top Spending' as title_top\n"
},
{
"name": "select_yes_no_tag_show_mismatch",
"displayName": "select_yes_no_tag_show_mismatch",
@clowa
clowa / Increase_LVM_on_existing_device_or_partition.md
Created February 18, 2025 17:21
Increase LVM on existing device or partition
  1. Increase the virtual hard drive
  2. Connect to the VM
  3. Check the increased disk by running sudo fdisk -l /dev/sdX
  4. Grow the disk/partion via growpart /dev/sdX Y
  5. Resize the Physical Volume (PV) to recognize the new space pvresize /dev/sdXY
  6. Extend the Logical Volume (LV) using all available free space: lvresize -l +100%FREE /dev/mapper/ubuntu--vg-ubuntu--lv
  7. Increase file system (ext4) via resize2fs /dev/mapper/ubuntu--vg-ubuntu--lv
  8. Check that the volume group has been grown with lvdisplay
@clowa
clowa / gist:f8f8c8eaaeea57fd6f3c3d2ce7398c18
Created October 6, 2024 13:16 — forked from rxaviers/gist:7360908
Complete list of github markdown emoji markup

People

:bowtie: :bowtie: πŸ˜„ :smile: πŸ˜† :laughing:
😊 :blush: πŸ˜ƒ :smiley: ☺️ :relaxed:
😏 :smirk: 😍 :heart_eyes: 😘 :kissing_heart:
😚 :kissing_closed_eyes: 😳 :flushed: 😌 :relieved:
πŸ˜† :satisfied: 😁 :grin: πŸ˜‰ :wink:
😜 :stuck_out_tongue_winking_eye: 😝 :stuck_out_tongue_closed_eyes: πŸ˜€ :grinning:
πŸ˜— :kissing: πŸ˜™ :kissing_smiling_eyes: πŸ˜› :stuck_out_tongue:
@clowa
clowa / update_conbe_firmware.md
Created April 9, 2024 15:39
Update ConBee Firmware

How to update Conbee Firmware

  1. Open Instructions at Update deCONZ manually - Update in Windows
  2. Download GCFFlasher here
  3. Download latest availabe firmware here
  4. Verify download via comparing the md5 hash. You can use the following Powershell commands:
    PS > Get-Content .\deCONZ_ConBeeIII_0x26500900.bin.GCF.md5
    42fd59db76e93d4c2042c4e6b383212c  deCONZ_ConBeeIII_0x26500900.bin.GCF
    PS > Get-FileHash -Algorithm MD5 -Path .\deCONZ_ConBeeIII_0x26500900.bin.GCF
@clowa
clowa / Openmediavault_7_on_Debian_12.md
Last active May 30, 2025 20:12
Install Openmediavault 7 on Debian 12

Overview

This instruction describes how to install openmediavault 7 (sandworm) on the newly released debian 12 (bookworm). Nearly all of the steps are copied from the original installation page, only the repositories are adjusted to openmediavault 7

Installation

Install the openmediavault keyring manually:

apt-get install --yes gnupg
@clowa
clowa / azure_databricks_personal_access_token.md
Last active October 13, 2023 15:10
Azure Databricks: Create a personal access token for a Service Principal via PowerShell

Create a personal access token for a Service Principal via PowerShell

Prerequisite

  • An existing Azure Databricks Workspace
  • Administrator Access to your Databricks Workspace
  • An existing Databricks Service Principal with a corresponding Azure AD App Registration. Identified by the matching Client ID and UUID. See here for more information on how to set this up.
  • A client Secret of the App Registration of the Service Principal

Create a Personal Access Token

@clowa
clowa / TF AzAPI Maintenance Configuration Dynamic Scope.md
Last active March 26, 2024 16:36
Terraform Azure Update Manager Maintenance Configuration Dynamic Scope

Terraform Azure Update Manager Maintenance Configuration Dynamic Scope assignment to all subscriptions

This gist used the terraform azapi provider to directly interact with the ARM API, because the azurerm provider currently doesn't support this resource nativly.

You have to prepare the Azure VM first for Customer Managed Schedules Patch orchestration.

resource "azurerm_maintenance_configuration" "example" {
  name                = "example-mc"
  resource_group_name = azurerm_resource_group.example.name
@clowa
clowa / get service principal id.md
Last active April 26, 2023 18:00
How to get the Service Principal ID of an App Registration, even as Guest.

Get Service Principal ID of an App Registration

This procedure relies on the login as the App Registration, therefore you require the following information:

  • Name of the App Registration
  • Tenant ID of the App Registration
  • Client ID of the App Registration
  • Client Secret of the App Registration
  1. Login as the App Registration via Azure CLI