Andy P. MagicAndi

## Organise-Photos.ps1
# =============================================================================
#
# Script Name: 		Organise-Photos
#
# Author: 			Andy Parkhill
#
# Date Created: 	09/07/2021
#
# Description: 		A script to organize my photos (and backups) into a coherent
#                   file structure, and remove duplicates, etc.

## Install-ProgramsTemplate.ps1
# ==========================================================================
#
# 	Script Name:  	Install-ProgramsTemplate.ps1
#
# 	Author:         Andy Parkhill
#
# 	Date Created:   07/10/2019
#
# 	Description:    A template setup script for Windows 10 PCs. Take the template
#                   and create a specific setup script for each new PC.

## Simple-SleepTimer.ps1

function Start-SleepTimer
{
    param
    (
        [Alias('s')]
        [int] $seconds
    )

    for($index = $seconds; $index -gt 0; $index--)

## ListSiteCollectionsAndContentDatabases.ps1
Get-SPSite -limit all -WebApplication <Web Application URL> | Select Url, ContentDatabase

## Install-ProgramsForWindws10.ps1
# ==========================================================================
#
# 	Script Name:  	Install-ProgramsForWindows10.ps1
#
# 	Author:         Andy Parkhill
#
# 	Date Created:   22/09/2016
#
# 	Description:    A simple environment setup script for Windows 10 PCs.
#

## List-InstalledPrograms.ps1
Get-ItemProperty HKLM:\Software\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall\* | Select-Object DisplayName, DisplayVersion, Publisher, InstallDate | Sort-Object DisplayName | Export-CSV -Path C:\Temp\InstalledPrograms.csv  -NoTypeInformation -Delimiter "|" | foreach { $_ -replace '^"','' -replace "`"|`"", "|" -replace '"$','' }

## ResetComputerPassword.bat
netdom.exe resetpwd /s:<server> /ud:<user> /pd:<password>

## LisFoldersToSetDepth.bh
tree -d -L 3 -N > /mnt/c/Temp/FolderListing.txt

## ListFoldersToSetDepth.ps1
Get-ChildItem -Recurse -Directory -Depth 2 | Out-File C:\Temp\FolderListing.txt

## RetrieveSqlQueries.sql
SELECT	 execquery.last_execution_time AS [Date Time]
		,execsql.text AS [Script]
FROM	sys.dm_exec_query_stats AS execquery
		CROSS APPLY sys.dm_exec_sql_text(execquery.sql_handle) AS execsql
WHERE	execsql.text LIKE '%<text to search for>%'
ORDER BY execquery.last_execution_time DESC
	# =============================================================================
	#
	# Script Name: Organise-Photos
	#
	# Author: Andy Parkhill
	#
	# Date Created: 09/07/2021
	#
	# Description: A script to organize my photos (and backups) into a coherent
	# file structure, and remove duplicates, etc.
	# ==========================================================================
	#
	# Script Name: Install-ProgramsTemplate.ps1
	#
	# Author: Andy Parkhill
	#
	# Date Created: 07/10/2019
	#
	# Description: A template setup script for Windows 10 PCs. Take the template
	# and create a specific setup script for each new PC.

	function Start-SleepTimer
	{
	param
	(
	[Alias('s')]
	[int] $seconds
	)

	for($index = $seconds; $index -gt 0; $index--)
	# ==========================================================================
	#
	# Script Name: Install-ProgramsForWindows10.ps1
	#
	# Author: Andy Parkhill
	#
	# Date Created: 22/09/2016
	#
	# Description: A simple environment setup script for Windows 10 PCs.
	#
	SELECT execquery.last_execution_time AS [Date Time]
	,execsql.text AS [Script]
	FROM sys.dm_exec_query_stats AS execquery
	CROSS APPLY sys.dm_exec_sql_text(execquery.sql_handle) AS execsql
	WHERE execsql.text LIKE '%<text to search for>%'
	ORDER BY execquery.last_execution_time DESC