Skip to content

Instantly share code, notes, and snippets.

View d-oderbolz's full-sized avatar

Dr. Daniel C. Oderbolz d-oderbolz

6 followers · 17 following
  • SBB CFF FFS
  • Switzerland
View GitHub Profile
@d-oderbolz
d-oderbolz / Export-to-Confluence.ps1
Last active June 22, 2025 07:20
Turn a couple of *.md Files into a Confluence Table
# @see https://gist.github.com/d-oderbolz/bfcd2c9ac1b02a9ab632c0ebf5a4bccf
# We have a list of Markdown files in a directory.
# We want to convert them to Confluence format and export them to a Confluence space.
# The file names start with an ISO date in the format YYYY-MM-DD, followed by a hyphen delimited name and end with .md.
# We want to loop through each file, convert it to Confluence format, and then create a row in a Confluence table.
# I want to be able to choose the start date and end date for the files to be processed.
# Usage: .\Export-to-Confluence.ps1 -StartDate "2023-01-01" -EndDate "2023-12-31" -Directory "C:\Path\To\MarkdownFiles" -Pattern "^(\d{4}-\d{2}-\d{2})-(.+)\.md$"
@d-oderbolz
d-oderbolz / backup_sh
Last active June 11, 2018 12:54
#/etc/logrotate.d/backup_sh
/var/services/homes/admin/log/backup*.log {
missingok
}
@d-oderbolz
d-oderbolz / backup.sh
Last active June 11, 2018 12:53
#!/bin/bash
# Simple Backup Script (inspried by https://zarino.co.uk/post/synology-rsync-backup/)
rsync -a -v --log-file="/var/services/homes/admin/log/backup.$(date +%Y-%m-%d-%H%M).log" \
--exclude '*@SynoResource' \
--exclude '@eaDir' \
--exclude '*.vsmeta' \
--exclude '.DS_Store' \
/volume1/data/ /volumeUSB2/usbshare/data
@d-oderbolz
d-oderbolz / crontab
Created June 9, 2018 08:56
0 22 * * * root flock -n /var/services/homes/admin/lock/backup.lock /var/services/homes/admin/bin/backup.sh
@d-oderbolz
d-oderbolz / snow_try_catch.js
Created January 19, 2018 10:47
getActiveProductsManagedByUser: function(user_sys_id){
try
{
if (! this.checkSysId(user_sys_id))
{
throw("getProductsManagedByUser: Not a valid sys_id - " + user_sys_id);
}
// Rest of code here
}
@d-oderbolz
d-oderbolz / good_script_include_getPropertyList.js
Created November 13, 2017 11:37
// This is a gist to show how to write a Service Now Script Include to return an array with
// the results of a query
// As an example, I use the sys_properties table, but of course, any table will do
var Toolbox_Functions = Class.create();
Toolbox_Functions.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getPropertyList: function (prefix)
{
// 06.11.2017 - Return a list of System Properties whose name starts with prefix
@d-oderbolz
d-oderbolz / bad_script_include_getPropertyList.js
Created November 13, 2017 11:31
// This is a gist to show how NOT to write a Service Now Script Include to return an array with
// the results of a query
// As an example, I use the sys_properties table, but of course, any table will do (AKA: not work)
var Toolbox_Functions = Class.create();
Toolbox_Functions.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getPropertyList: function (prefix)
{
// 06.11.2017 - Return a list of System Properties whose name starts with prefix
@d-oderbolz
d-oderbolz / compromised_emails.ps1
Last active November 13, 2017 11:27
## This scipt does a check of all the email adresses given in a CSV File
# See also http://www.govcert.admin.ch/blog/20/leaked-mail-accounts
# Written by Daniel C. Oderbolz, 2016 using code by Jon Gurgul
# Blessing from https://github.com/endlesssoftware/sqlite3/blob/master/btree.c
# May you do good and not evil.
# May you find forgiveness for yourself and forgive others.
# May you share freely, never taking more than you give
# When resulting page contains
# <center><h1>Email Address <b>NOT</b> in Database</h1><br /></center>