Hi all,

I’m battling a bit with PowerShell… 🙁

I have written the following scripts – One for SQL 2012 and the other for SQL 2014

The bit I’m struggling with is to get the memory allocated to that server hosting the SQL instance

The memory can be called from the following class:-
get-scomclass -name ‘Microsoft.Windows.Server.OperatingSystem’

Script 1

Script 2

clarkd answered