Create a .txt file with all of your server name and save it in a safe location, like C:\ServerList.
Copy the above script and update it with your desire location for the output file, Like C:\HardDriveSpaceDetail.txt
Attached that file to your email and send it to your boss. I used Gmail as the SMTP, but you should use your corporate email service or SMTP.
Create a windows task to run the PS script before you have your morning coffee.
#Hard drive space detail
Clear-Host
$OutArray = @()
$serverList = Get-Content 'C:\ServerList.txt'
foreach($svr in $serverList )
{
$server = Get-WmiObject -ComputerName $svr -class win32_volume | select @{LABEL='Server';EXPRESSION={($_.SystemName)}},`
@{LABEL='Drive';EXPRESSION={$_.DriveLetter}},`
@{LABEL='Label';EXPRESSION={$_.label}},`
@{LABEL='Capacity (MB)';EXPRESSION={[decimal]("{0:N0}" -f($_.Capacity/1mb))}},`
@{LABEL='Free Space (MB)';EXPRESSION={[decimal]("{0:N0}"-f($_.freeSpace/1mb))}},`
@{LABEL='% Free';EXPRESSION={("{0,6:P0}" -f(($_.freeSpace/1mb) / ($_.Capacity/1mb)))}}| Format-Table -AutoSize -Wrap;
$OutArray+= $server;
$server = $null
}
$outarray | Out-File 'C:\HardDriveSpaceDetail.txt';
$From = "mashrur.shuvo@gmail.com"
$To = "xxxxxxx@yyyyyy.com"
$Subject = "HardDriveSpaceDetail"
$Body = "Please Check the following .txt attachment. Its not a virus, its your detail Hard drive space report of all servers."
$SMTPServer = "smtp.gmail.com"
$SMTPPort = "587"
$attachment = 'C:\HardDriveSpaceDetail.txt'
Send-MailMessage -From $From -to $To -Subject $Subject `
-Body $Body -SmtpServer $SMTPServer -port $SMTPPort -UseSsl -Attachments $attachment `
-Credential (Get-Credential) 
Part 11 of our series on "Microsoft Windows PowerShell and SQL Server 2008 AMO" discusses how to generate a script for given dimension of the Analysis Service database to XMLA format file.
2009-05-01
2,122 reads
To continue this series on Introduction to Windows PowerShell for the SQL Server DBA, this tip will look at the pipeline and output processing.
2009-03-23
3,574 reads
Learn how to restore an Analysis Services database to the same or different location, from a database backup file with password protection.
2009-02-24
1,756 reads
Part 8 of our discussion on how to check SQL Server using Windows PowerShell examines how to get the SQL Server connection information.
2008-11-12
2,668 reads
For all of us who learn best by trying out examples, Bob Sheldon produces a PowerShell script file for SQL Server that can be used in either SQL Server 2005 or 2008, has error handling and prompts for user-input, is easily extended and, does something useful. He then explains how to run it and what each line does.
2008-11-04
2,834 reads