Differences

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

--- windows:powershell:insertinstanceconfig [2013/11/05 17:33] – created haidong
+++ windows:powershell:insertinstanceconfig [2018/05/15 03:00] (current) – external edit 127.0.0.1
@@ Line 4: / Line 4: @@
 <code powershell insertInstanceConfig.ps1>
-function getInstanceConfig($ServerInstance)
+function getInstanceConfig($ServerInstance) {
-{
     $InstanceConfigQuery = @"
        SELECT  [configuration_id]
@@ Line 21: / Line 20: @@
         $myHashtable = @{Configuration_Id = $_.configuration_id;  Name =
         $_.name; Value = $_.value; ValueInUse = $_.value_in_use}
-        [void] $dataIndexArray.add($myHashtable)
+        [void] $dataIndexArray.add($myHashtable)}
-    }
+    $dataIndexArray}
-    $dataIndexArray
-}
+function insertInstanceConfigSQL($instanceConfig, $instanceID) {
+	$ConfigurationId, $Name, $Value, $ValueInUse =
+        $instanceConfig.Configuration_Id, $instanceConfig.Name, $instanceConfig.Value, $instanceConfig.ValueInUse
+	$sql = "EXEC Windows.InstanceConfig_Insert $InstanceID, $ConfigurationId, '$Name', '$Value', '$ValueInUse'"
+    return $sql}
 $InstanceList = Invoke-Sqlcmd -Query "exec Windows.Instance_Select_InstanceID_InstanceName" -ServerInstance "sql1" -Database "JiMetrics"
@@ Line 32: / Line 35: @@
     $InstanceID = $_.InstanceID
-        Try {
+    Try {
            $InstanceConfigArray = getInstanceConfig($InstanceName)
            $InstanceConfigArray | ForEach-Object {
-               $ConfigurationId, $Name, $Value, $ValueInUse =
+               $sql = insertInstanceConfigSQL $_ $InstanceID
-               $_.Configuration_Id, $_.Name, $_.Value, $_.ValueInUse
+               Invoke-Sqlcmd -Query $sql -ServerInstance "sql1" -Database "JiMetrics"}}
+    Catch [Exception] { Continue }}
-               $sql = "EXEC Windows.InstanceConfig_Insert $InstanceID,
-               $ConfigurationId, '$Name', '$Value', '$ValueInUse'"
-                Invoke-Sqlcmd -Query $sql -ServerInstance "sql1" -Database "JiMetrics"
-           }
-        }
-    Catch { Return }
-}
 </code>