Laim

strName = "." 'Computer name, if local just use a period.

Set objWMI = GetObject("winmgmts:" & "{impersonationLevel=impersonate}!\\" & strName & "\root\cimv2")

For Each obj in objWMI.ExecQuery ("Select * from Win32_SystemEnclosure")
    For Each strChassisType in obj.ChassisTypes
        Wscript.Echo strChassisType
    Next
Next

Laim

-- Take the database offline before restoring
ALTER DATABASE [DatabaseName] 
SET OFFLINE WITH ROLLBACK IMMEDIATE

-- Restore the database
RESTORE DATABASE DatabaseName FROM DISK = '\\FileServer\directory\servername\database\database_backup.bak'

-- Bring it back online, this should be automatic but just incase.
ALTER DATABASE [DatabaseName] 
SET ONLINE

Laim

<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
  <channel>
    <title>{{ site.name | xml_escape }}</title>
    <description>{{ site.description | xml_escape }}</description>
    <link>{{ site.url }}</link>
    <atom:link href="{{ site.url }}/feed.xml" rel="self" type="application/rss+xml" />
    {% for post in site.posts limit:10 %}
      <item>
        <title>{{ post.title }}</title>

Laim

/*
	Author: Laim McKenzie
	Date: 30-04-2021
	Updated: 07-05-2021
	https://laim.scot
*/

/* Create temp table to populate with data */
CREATE TABLE #sp_who2 
	(

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

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

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

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

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
	
	Modified version of https://sqlgeekspro.com/script-to-delete-sql-agent-jobs/
*/

DECLARE @SQLStatement VARCHAR(200)
DECLARE @jobName SYSNAME