PowerShell – Get Boot Time of Computer Writer #1, 2016-03-18 Show Date/Time Of Last Boot Get-WmiObject -class Win32_OperatingSystem | Select-Object __SERVER,@{label='LastBootUpTime';expression={$_.ConvertToDateTime($_.LastBootUpTime)}} Continue Reading
PowerShell – Scripts Not Allowed To Run Writer #1, 2016-03-18 If PowerShell is not allowing you to run scripts then you might need to set… Continue Reading
PowerShell – Get All SQL Server Instances In Environment Writer #1, 2016-03-18 cls import-module failoverclusters Import-Module -Name SQLPS -DisableNameChecking $servers = “comma”,”separated”,”server”,”list” foreach($server in $servers) { try… Continue Reading
PowerShell – Fast Ping Writer #1, 2016-03-18 Source: https://gist.github.com/mbrownnycnyc/9913361 This is a very fast way to ping a server using PowerShell. #… Continue Reading
PowerShell – Get SQL Server Info Writer #1, 2016-03-18 $assemblylist = “Microsoft.SqlServer.Management.Common”, “Microsoft.SqlServer.Smo”, “Microsoft.SqlServer.Dmf “, “Microsoft.SqlServer.Instapi “, “Microsoft.SqlServer.SqlWmiManagement “, “Microsoft.SqlServer.ConnectionInfo “, “Microsoft.SqlServer.SmoExtended “, “Microsoft.SqlServer.SqlTDiagM… Continue Reading
PowerShell – Replace All Instances Of Something In All Files In Directory Writer #1, 2016-03-18 This script searches every file in a directory for a particular string and replaces it… Continue Reading
Powershell – Finding the most recent backup file in a parent directory Writer #1, 2015-12-01 Having to sift through a large directory to get the latest file can be tedious. … Continue Reading