If you haven't guessed, I'm Dave Harris and I'll happily blog about anything, but you'll find a lot of sysadmin stuff, X10 and home automation, product reviews, hedgehog related stuff, DIY and car stuff on here.
Hopefully you will find some of it interesting and possibly even helpful, if you do, perhaps you could buy me a beer or a coffee (see links on right), nobody has yet, but I'm sure one day it will happen!
Have a look around and let me know what you think. Cheers, Dave.
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.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 |
--/////////////////////////////////////////////////////////////////////////////////////////// --////////////////////// Filespace Used and Free ////////////////////////////////////////// IF (OBJECT_ID('tempdb..#tmpDbSpace') IS NOT NULL) DROP TABLE #tmpDbSpace CREATE TABLE #tmpDbSpace ( [DBname] varchar (126) NULL, [LogicalFileName] varchar (126) NULL, [IsLogFile] tinyint NULL, [IsPrimaryFile] tinyint NULL, [IsReadOnly] tinyint NULL, [FileSizeMB] numeric (12, 2) NULL, [SpaceUsedMB] numeric (12, 2) NULL, [Growth] varchar (50) NULL) DECLARE @TSQL varchar (max) SET @TSQL = 'USE [?]; INSERT INTO #tmpDbSpace SELECT [DBName]=DB_NAME(DB_ID()), [LogicalFileName]=[name], [IsLogFile]=FILEPROPERTY([name], ''IsLogFile''), [IsPrimaryFile]=FILEPROPERTY([name], ''IsPrimaryFile''), [IsReadOnly]=FILEPROPERTY([name], ''IsReadOnly''), [FileSizeMB]=([Size]*8)/1024, -- In pages of 8 Kb [SpaceUsedMB]=(FILEPROPERTY([name], ''SpaceUsed'')*8)/1024, -- In pages of 8 Kb [Growth] = CASE status & 0x100000 WHEN 0x100000 THEN CONVERT(VARCHAR(15), growth) + ''%'' ELSE CONVERT(VARCHAR(15), CONVERT (BIGINT, growth) * 8) + '' KB'' END FROM sys.sysfiles' --Print the command to be issued against all databases PRINT @TSQL --Run the command against each database EXEC sp_MSforeachdb @TSQL SELECT [DBname], [LogicalFileName], [FileType]=CASE WHEN [IsLogFile]=1 THEN 'Log' WHEN [IsLogFile]=0 AND [IsPrimaryFile]=1 THEN 'Primary' ELSE 'Data' END, [FileSizeMB], [SpaceUsedMB], [FreeSpacePercent]=CASE WHEN [FileSizeMB] = 0 THEN 0 ELSE CAST((([FileSizeMB]-[SpaceUsedMB])/[FileSizeMB])*100 AS numeric (12, 2)) END, [Growth] FROM #tmpDbSpace ORDER BY [DBname], [IsLogFile] --/////////////////////////////////////////////////////////////////////////////////////////// |
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++ …