View powershell_messaging_system.ps1
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<# | |
.SYNOPSIS | |
Sends a message to an external provider such as Discord or Telegram | |
.DESCRIPTION | |
Script that allows sending a pre-defined message to Discord or Telegram. Useful for Handbrake when conversions are completed. | |
.PARAMETER messageSystem | |
Which message system you want to use, Discord or Telegram. |
View org_rules.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
Author: Laim McKenzie | |
URL: https://gist.github.com/Laim/dee0e030cc6b452d1eafb4b7e48ca9c5 | |
Date: 14-03-2022 | |
*/ | |
SELECT |
View handbrakePresets.json
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"PresetList": [ | |
{ | |
"ChildrenArray": [ | |
{ | |
"AlignAVStart": true, | |
"AudioCopyMask": [ | |
"copy:aac" | |
], | |
"AudioEncoderFallback": "av_aac", |
View SSLlabs-powershellscan.ps1
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<# | |
.NOTES | |
Version : 1.0 | |
Author : Laim McKenzie | |
Creation Date : 17.05.2021 | |
Purpose : Automation of SSLLabs SSLtests. | |
Credits : Modified version of script by /u/tramperdk | |
#> | |
View lmu_del_sql_jobs.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
Author: Laim McKenzie | |
Website: https://laim.scot | |
Version: 1.0 | |
Modified version of https://sqlgeekspro.com/script-to-delete-sql-agent-jobs/ | |
*/ | |
DECLARE @SQLStatement VARCHAR(200) | |
DECLARE @jobName SYSNAME |
View CopyLogFiles.ps1
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#<-----------------------------------------># | |
# > Author: Laim McKenzie | |
# > Date: 29-07-2021 | |
# > Description: This script can be ran under a Scheduled Task and collect log files from the Source Directory and copy to the Destination Directory | |
# > Pre-requisites: | |
# > 1. You need to ensure the Source Directory exists | |
# > 2. You need to ensure the Desitnation Directory exists | |
# > 3. The account running the scheduled task (if ran under one) needs to have access to both directories | |
# > Copyright (c) 2021 Laim McKenzie | |
#<-----------------------------------------># |
View hide_unassigned.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
Author: Laim McKenzie | |
Website: https://laim.scot | |
Version: 1.0 | |
You can view the Hidden Software count using this script | |
SELECT COUNT(*) FROM SnowLicenseManager.dbo.tblSoftware WHERE IsHidden = 1 | |
*/ |
View snow_stuff.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Custom Fields | |
SELECT C.Name, COUNT(CF.CID) AS [CustomFieldCount] FROM SnowLicenseManager.dbo.tblCustomField CF | |
INNER JOIN SnowLicenseManager.dbo.tblCID C ON CF.CID = C.CID | |
GROUP BY C.Name | |
-- Custom Compare Values | |
SELECT C.Name, COUNT(CCV.CID) AS [CCVCount] FROM SnowLicenseManager.dbo.tblCustomCompareValues CCV | |
INNER JOIN SnowLicenseManager.dbo.tblCID C ON CCV.CID = C.CID | |
GROUP BY C.Name |
View versions.ps1
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# START : Get SQL Instance Version # | |
cls # prevents the script itself from echoing out into ISE | |
"---------------------------------------------------------------------" | |
$inst = (get-itemproperty 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server').InstalledInstances # Gets the installed SQL instances | |
$sqlInstanceCount = 0; # loop for the foreach | |
foreach ($i in $inst) |
View backuprestoreprocess.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
Modified version of https://blog.sqlauthority.com/2017/03/12/get-status-running-backup-restore-sql-server-interview-question-week-113/ | |
Author: Laim McKenzie | |
Available from https://gist.github.com/laim | |
Copyright (c) 2021 laim.scot | |
*/ | |
SELECT r.session_id AS [Session_Id] | |
,r.command AS [command] |
NewerOlder