Skip to content

Instantly share code, notes, and snippets.

@MikeFal
Created May 25, 2017 17:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save MikeFal/6d8daf5191bd316c2de797dbf33215f7 to your computer and use it in GitHub Desktop.
Save MikeFal/6d8daf5191bd316c2de797dbf33215f7 to your computer and use it in GitHub Desktop.
$sql='
SELECT
@@SERVERNAME as ServerName
,SERVERPROPERTY('ProductVersion') as SQLVersion
,db.name
,db.recovery_model_desc
,sum(mf.size/128.0) as DBTotalSizeMB
from sys.databases db
join sys.master_files mf on db.database_id = mf.database_id
left join LogBackupInfo lbi on db.name = lbi.database_name
left join FullBackupInfo fbi on db.name = fbi.database_name
group by
db.name
,db.recovery_model_desc'
$servers = @('VADER','TARKIN','THRAWN')
$outfile = 'C:\Temp\out.csv'
$servers | ForEach-Object {Invoke-SqlCmd -ServerInstance $_ -Database TempDB -Query $sql |
ConvertTo-CSV -NoTypeInformation |
Select-Object -Skip 1 |
Out-File $outFile -Append}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment