# Helper function to translate the scriptblock output into a DataTable
Function Out-DataTable {

  $dt = new-object Data.datatable  
  $First = $true  

  foreach ($item in $input){  
    $DR = $DT.NewRow()  
    $Item.PsObject.get_properties() | foreach {  
      if ($first) {  
        $Col =  new-object Data.DataColumn  
        $Col.ColumnName = $_.Name.ToString()  
        $DT.Columns.Add($Col)       }  
      if ($_.value -eq $null) {  
        $DR.Item($_.Name) = "[empty]"  
      }  
      elseif ($_.IsArray) {  
        $DR.Item($_.Name) =[string]::Join($_.value ,";")  
      }  
      else {  
        $DR.Item($_.Name) = $_.value  
      }  
    }  
    $DT.Rows.Add($DR)  
    $First = $false  
  } 

  return @(,($dt))

} #Out-DataTable

# Get disk space information for each volume (drives and mounts)
Function Get-VolumeSpace ([string]$ServerName="localhost")
{
	$wql="Select SystemName, Name, Capacity, FreeSpace From Win32_Volume Where DriveType=2 or DriveType=3"
	$volSpace=Get-WmiObject -ComputerName $ServerName -Query $wql 
	$volSpace | Select SystemName, Name, Capacity, FreeSpace
} #Get-VolumeSpace


$dataTable = Get-VolumeSpace | Out-DataTable

$connectionString = "Data Source=Server1\Instance1;Integrated Security=true;Initial Catalog=DBA;"
$bulkCopy = new-object ("Data.SqlClient.SqlBulkCopy") $connectionString
$bulkCopy.DestinationTableName = "VolumeSpace"
$bulkCopy.WriteToServer($dataTable)

quote:

---

Originally posted by tkizer

I hate cross posters, such a waste of time for us.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

---

quote:

---

Originally posted by tkizer

I have a PS script as well for this. I had to roll my own as none of the ones I found on the Internet worked on all of our servers.

Here's my PS script:

# Helper function to translate the scriptblock output into a DataTable
Function Out-DataTable {

  $dt = new-object Data.datatable  
  $First = $true  

  foreach ($item in $input){  
    $DR = $DT.NewRow()  
    $Item.PsObject.get_properties() | foreach {  
      if ($first) {  
        $Col =  new-object Data.DataColumn  
        $Col.ColumnName = $_.Name.ToString()  
        $DT.Columns.Add($Col)       }  
      if ($_.value -eq $null) {  
        $DR.Item($_.Name) = "[empty]"  
      }  
      elseif ($_.IsArray) {  
        $DR.Item($_.Name) =[string]::Join($_.value ,";")  
      }  
      else {  
        $DR.Item($_.Name) = $_.value  
      }  
    }  
    $DT.Rows.Add($DR)  
    $First = $false  
  } 

  return @(,($dt))

} #Out-DataTable

# Get disk space information for each volume (drives and mounts)
Function Get-VolumeSpace ([string]$ServerName="localhost")
{
	$wql="Select SystemName, Name, Capacity, FreeSpace From Win32_Volume Where DriveType=2 or DriveType=3"
	$volSpace=Get-WmiObject -ComputerName $ServerName -Query $wql 
	$volSpace | Select SystemName, Name, Capacity, FreeSpace
} #Get-VolumeSpace


$dataTable = Get-VolumeSpace | Out-DataTable

$connectionString = "Data Source=Server1\Instance1;Integrated Security=true;Initial Catalog=DBA;"
$bulkCopy = new-object ("Data.SqlClient.SqlBulkCopy") $connectionString
$bulkCopy.DestinationTableName = "VolumeSpace"
$bulkCopy.WriteToServer($dataTable)

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

---

quote:

---

Originally posted by future_is_me

How can I make use of this script? If I put this script in action part of a basic task wizard (task scheduler) would this send me an email whenever the size falls below a specific value?

---