Advertisement
Guest User

Untitled

a guest
Jan 11th, 2018
157
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.     results = Invoke-SqlCmd -Query "SELECT DB_NAME(smf.database_id) AS db__name, CONVERT(DECIMAL(18,0), ((smf.size * 8192.0) / POWER(1,20))) AS Size_In_Bytes, smf.* FROM sys.master_files AS smf;";
  2.     foreach ($Item in $results){
  3.  
  4.             $name = $item.Name
  5.             $length = $item.size_in_bytes
  6.             write-host "sql-$name-Database $length"
  7.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement