windows:powershell:updateinstance
Differences
This shows you the differences between two versions of the page.
| Next revision Both sides next revision | |||
|
windows:powershell:updateinstance [2013/10/15 15:45] haidong created |
windows:powershell:updateinstance [2013/11/04 21:22] haidong Change SysMetrics to JiMetrics |
||
|---|---|---|---|
| Line 6: | Line 6: | ||
| <code powershell updateInstance.ps1> | <code powershell updateInstance.ps1> | ||
| - | $InstanceList = Invoke-Sqlcmd -Query "exec Windows.Instance_Select_InstanceID_InstanceName" -ServerInstance "sql1" -Database "SysMetrics" | + | $InstanceList = Invoke-Sqlcmd -Query "exec Windows.Instance_Select_InstanceID_InstanceName" -ServerInstance "sql1" -Database "JiMetrics" |
| $InstanceList | ForEach-Object { | $InstanceList | ForEach-Object { | ||
| Line 25: | Line 25: | ||
| $sql = "EXEC Windows.Instance_Update $InstanceID, | $sql = "EXEC Windows.Instance_Update $InstanceID, | ||
| '$InstanceEdition', '$InstanceEditionID', '$InstanceVersion', '$InstanceServicePack'" | '$InstanceEdition', '$InstanceEditionID', '$InstanceVersion', '$InstanceServicePack'" | ||
| - | Invoke-Sqlcmd -Query $sql -ServerInstance "sql1" -Database "SysMetrics" | + | Invoke-Sqlcmd -Query $sql -ServerInstance "sql1" -Database "JiMetrics" |
| } | } | ||
| Catch { Return } | Catch { Return } | ||
| } | } | ||
| </code> | </code> | ||
windows/powershell/updateinstance.txt ยท Last modified: 2018/05/14 22:00 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
