This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
windows:powershell:insertdbfilestats [2013/10/14 22:13] 127.0.0.1 external edit |
windows:powershell:insertdbfilestats [2018/05/14 22:00] (current) |
||
---|---|---|---|
Line 43: | Line 43: | ||
function storeDbFileInfo($sql) | function storeDbFileInfo($sql) | ||
{ | { | ||
- | $serverResults = Invoke-Sqlcmd -ServerInstance "sql1" -Database "SysMetrics" -Query $sql | + | $serverResults = Invoke-Sqlcmd -ServerInstance "sql1" -Database "JiMetrics" -Query $sql |
$serverResults | forEach { | $serverResults | forEach { | ||
$InstanceName, $InstanceID = $_.InstanceName, $_.InstanceID | $InstanceName, $InstanceID = $_.InstanceName, $_.InstanceID | ||
Line 61: | Line 61: | ||
$FileLogicalName, $FilePhysicalName, $FileGroupName, $FileSizeInMB, $FreeSizeInMB, $max_size, $growth, $is_percent_growth = $_.FileLogicalName, $_.FilePhysicalName, $_.FileGroupName, $_.FileSizeInMB, $_.FreeSizeInMB, $_.max_size, $_.growth, $_.is_percent_growth | $FileLogicalName, $FilePhysicalName, $FileGroupName, $FileSizeInMB, $FreeSizeInMB, $max_size, $growth, $is_percent_growth = $_.FileLogicalName, $_.FilePhysicalName, $_.FileGroupName, $_.FileSizeInMB, $_.FreeSizeInMB, $_.max_size, $_.growth, $_.is_percent_growth | ||
$sql = "EXEC Windows.DbFileStats_Insert $InstanceID, '$DbName', '$FileLogicalName', '$FilePhysicalName', '$FileGroupName', $FileSizeInMB, $FreeSizeInMB, $max_size, $growth, '$is_percent_growth'" | $sql = "EXEC Windows.DbFileStats_Insert $InstanceID, '$DbName', '$FileLogicalName', '$FilePhysicalName', '$FileGroupName', $FileSizeInMB, $FreeSizeInMB, $max_size, $growth, '$is_percent_growth'" | ||
- | Invoke-Sqlcmd -Query $sql -ServerInstance "sql1" -Database "SysMetrics" | + | Invoke-Sqlcmd -Query $sql -ServerInstance "sql1" -Database "JiMetrics" |
} } } } } | } } } } } | ||