Laim

<#

.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.

Laim

/*

	Author: Laim McKenzie
	URL: https://gist.github.com/Laim/dee0e030cc6b452d1eafb4b7e48ca9c5
	Date: 14-03-2022

*/

SELECT 

Laim

{
  "PresetList": [
    {
      "ChildrenArray": [
        {
          "AlignAVStart": true,
          "AudioCopyMask": [
            "copy:aac"
          ],
          "AudioEncoderFallback": "av_aac",

Laim

<#
.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
#>

Laim

/*
	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

Laim

#<----------------------------------------->#
# > 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
#<-----------------------------------------># 

Laim

/*
	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

*/

Laim

-- 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

Laim

# 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)

Laim

/*
	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]