WimObiwan’s gists

WimObiwan / CleanupOldFiles.ps1

Last active August 29, 2019 11:58

CleanupOldFiles.ps1

	$folder = 'C:\Temp\', $env:TEMP, '~/Downloads'
	$threshold = (Get-Date).AddMonths(-1.0)
	$ConfirmPreference = 'Low'

	$oldFiles = $folder \| Get-ChildItem -File -Recurse \| ?{ $_.LastAccessTime -lt $threshold }
	$oldFiles \| Sort-Object -Property Length -Descending \| Select -First 25 Length, FullName
	$oldFiles \| Measure-Object -Property Length -Sum -Maximum -Minimum -Average
	$oldFiles \| Remove-Item -Force -Confirm

	$emptyFolders = $folder \| Get-ChildItem -Directory -Recurse `

WimObiwan / ConvertTo-Dictionary.ps1

Created August 26, 2019 14:38

ConvertTo-Dictionary

	function ConvertTo-Dictionary {
	[CmdletBinding()]
	param (

	[Parameter(Mandatory=$true, ValueFromPipeline=$true)]
	$Collection,

	[Parameter(Mandatory=$true)]
	[string]$Key

WimObiwan / Get-WithProgress.ps1

Last active December 16, 2019 09:00

Get-WithProgress.ps1

	function Get-WithProgress {
	param(
	[string] $Activity = 'Processing',
	[int] $Loop = 0
	)
	# v1.0 Initial version
	# v1.1 Only increase progress AFTER processing an item

	# Collect the pipeline input ($Input) up front in an array,
	# using @(...) to force enumeration.

WimObiwan / Check Sql Server file size limit.sql

Last active June 13, 2019 13:37

Check if database files are nearing the SQL Server (Express Edition) limits

	-- To check if database files are nearing the SQL Server (Express Edition) limits

	DECLARE @version varchar(32) = CONVERT(varchar(32), SERVERPROPERTY ('ProductVersion'));
	SELECT @version, @@VERSION;

	DECLARE @limit_GB float;
	IF SERVERPROPERTY('EngineEdition') = 4 -- Express Edition
	BEGIN
	-- SQL Server Express Edition:
	-- Up till SQL Server 2008, limit is 4 GB / file

WimObiwan / Backups per Database (Pivot).sql

Last active November 8, 2019 11:00

	WITH BackupsPerDatabase AS
	(
	SELECT
	--CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS Server,
	db.database_id,
	bs.type,
	MAX(bs.backup_finish_date) AS last_db_backup_date
	FROM sys.databases db
	LEFT OUTER JOIN msdb.dbo.backupset bs ON db.name = bs.database_name
	INNER JOIN msdb.dbo.backupmediafamily bmf ON bmf.media_set_id = bs.media_set_id

WimObiwan / Automatic Autotask logon.html

Created May 6, 2019 18:38

	<html>
	<head>
	<title>Autotask Login Proxy Page</title>
	<script>
	function loginForm() {
	document.myform.submit();
	}
	</script>
	</head>

WimObiwan / mysql backup.sh

Created April 3, 2019 17:47

mysql backup

	#!/usr/bin/env bash

	# First:
	# Create backup user
	# bash> mysql
	# mysql> CREATE USER 'backupuser'@'localhost' IDENTIFIED BY 'p455w0rd';
	# mysql> GRANT SELECT, SHOW VIEW, LOCK TABLES, RELOAD, REPLICATION CLIENT ON . TO 'backupuser'@'localhost';
	# mysql> FLUSH PRIVILEGES;
	# mysql> exit

WimObiwan / Powershell sysadmin cheat sheet.ps1

Created January 25, 2019 14:10

	# system boot time
	[Management.ManagementDateTimeConverter]::ToDateTime((Get-WmiObject Win32_OperatingSystem).LastBootUpTime)

WimObiwan / sp_BackupDatabases.sql

Created January 21, 2019 15:43

sp_BackupDatabases on SQL Express

	USE [master]
	GO
	/**** Object: StoredProcedure [dbo].[sp_BackupDatabases] ****/
	SET ANSI_NULLS ON
	GO
	SET QUOTED_IDENTIFIER ON
	GO

	IF OBJECT_ID('sp_BackupDatabases') IS NOT NULL
	BEGIN

WimObiwan / ScheduledJob.ps1

Created January 21, 2019 14:51

ScheduledJob

	$command = 'C:\SQLBackups\DoBackup.ps1'

	# trigger hourly
	$trigger = New-JobTrigger -Once -At '2015-01-01' -RepetitionInterval (New-TimeSpan -Hour 1) -RepetitionDuration ([TimeSpan]::MaxValue)

	$cred = Get-Credential

	Register-ScheduledJob -FilePath $command -Name SQLBackup -Trigger $trigger -Credential $cred

	$folder = 'C:\Temp\', $env:TEMP, '~/Downloads'
	$threshold = (Get-Date).AddMonths(-1.0)
	$ConfirmPreference = 'Low'

	$oldFiles = $folder \| Get-ChildItem -File -Recurse \| ?{ $_.LastAccessTime -lt $threshold }
	$oldFiles \| Sort-Object -Property Length -Descending \| Select -First 25 Length, FullName
	$oldFiles \| Measure-Object -Property Length -Sum -Maximum -Minimum -Average
	$oldFiles \| Remove-Item -Force -Confirm

	$emptyFolders = $folder \| Get-ChildItem -Directory -Recurse `

Wim Devos WimObiwan