Differences

This shows you the differences between two versions of the page.

--- windows:powershell:insertdbfilestats [2013/10/15 03:13] – external edit 127.0.0.1
+++ windows:powershell:insertdbfilestats [2018/05/15 03:00] (current) – external edit 127.0.0.1
@@ Line 43: / Line 43: @@
 function storeDbFileInfo($sql)
 {
-    $serverResults = Invoke-Sqlcmd -ServerInstance "sql1" -Database "SysMetrics" -Query $sql
+    $serverResults = Invoke-Sqlcmd -ServerInstance "sql1" -Database "JiMetrics" -Query $sql
     $serverResults | forEach {
     $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
                 $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"
             } } } } }