Powershell 磁盘使用空间监控，并使用dbmail发送邮件

时间:2012-12-29 08:41来源:未知作者:admin 点击: 次

分享到：

本文章简单的介绍了一个Powershell 磁盘使用空间监控，并使用dbmail发送邮件实例有需要的朋友可以参考一下。代码如下 $server = (local) $uid = sa $db=master $pwd=fanzhouqi $mailprfname = sina $recipien

本文章简单的介绍了一个Powershell 磁盘使用空间监控，并使用dbmail发送邮件实例有需要的朋友可以参考一下。

代码如下

$server = "(local)"
$uid = "sa"
$db="master"
$pwd="fanzhouqi"
$mailprfname = "sina"
$recipients = "XXXX@qq.com"
$subject = 'disk usage monitor'
function sendmail($message)
{
    $SqlConnection = New-Object System.Data.SqlClient.SqlConnection
    $CnnString ="Server = $server; Database = $db;User Id = $uid; Password = $pwd"
    $SqlConnection.ConnectionString = $CnnString
    $CC = $SqlConnection.CreateCommand();
    if (-not ($SqlConnection.State -like "Open")) { $SqlConnection.Open() }

    $cc.CommandText=" EXEC msdb..sp_send_dbmail
            @profile_name = '$mailprfname'
            ,@recipients = '$recipients'
            ,@body = '$message'
            ,@subject = '$subject'
"
    $cc.ExecuteNonQuery()|out-null
    $SqlConnection.Close();
}

$output = Get-WmiObject -Class Win32_LogicalDisk -Filter "DriveType=3" -ComputerName . | Format-Table deviceid,@{Label="free(GB)"; Expression={$_.freespace/1024/1024/1024}},@{Label="size(GB)"; Expression={$_.size/1024/1024/1024}} -AutoSize | Out-String
sendmail $output

并创建计划任务执行：

bat 脚本 powershell.exe -File "F:Disk Usage Monitor.ps1" -nointeractive