SQL Script to show available space for all Databases

22 May

Quick little script to return the space available on all databases. I linked this into PRTG Network Monitor to make sure that none of them were too low. –/////////////////////////////////////////////////////////////////////////////////////////// –////////////////////// Filespace Used and Free ////////////////////////////////////////// IF (OBJECT_ID(‘tempdb..#tmpDbSpace’) IS NOT NULL) DROP TABLE … Read More »

Powershell Script to check all Automatic Services with PRTG Network Monitor

22 May

I can check specified services with PTRG, but also wanted a a way to make sure all automatic services were running on a remote server. My first attempt at a script for this was: $machinename=$args[0] $sscount = 0 $ss = Get-WmiObject -Class Win32_Service -Filter “StartMode=’Auto’ AND State=’Stopped’” -computer $machinename foreach ($objItem in $ss) { $sscount++ … Read More »