/
26_6.ps1
29 lines (29 loc) · 1.11 KB
/
26_6.ps1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
function Import-DiskInfoFromSQL {
[CmdletBinding()]
Param()
$conn = New-Object System.Data.SqlClient.SqlConnection
$conn.ConnectionString = $DiskInfoSqlConnection
$conn.Open()
$cmd = New-Object System.Data.SqlClient.SqlCommand
$cmd.Connection = $conn
$sql = @"
SELECT ComputerName,DiskSize,DriveType,FreeSpace,
DriveID,DateAdded
FROM DiskInfo
ORDER BY DateAdded ASC
"@
$cmd.CommandText = $sql
$reader = $cmd.ExecuteReader()
# spin through the results
while ($reader.read()) { #A
$props = @{'ComputerName' = $reader['ComputerName']
'Size' = $reader['DiskSize']
'DriveType' = $reader['DriveType']
'FreeSpace' = $reader['FreeSpace']
'Drive' = $reader['DriveId']
'DateAdded' = $reader['DateAdded']}
New-Object -TypeName PSObject -Property $props
}
$conn.Close()
}
#A Loops through the results, and creates a custom object