windows:powershell:updatehost
Differences
This shows you the differences between two versions of the page.
| Next revision Both sides next revision | |||
|
windows:powershell:updatehost [2013/10/14 22:13] 127.0.0.1 external edit |
windows:powershell:updatehost [2013/11/04 21:14] haidong Change SysMetrics to JiMetrics |
||
|---|---|---|---|
| Line 6: | Line 6: | ||
| <code powershell updateHost.ps1> | <code powershell updateHost.ps1> | ||
| - | $HostList = Invoke-Sqlcmd -Query "exec Windows.Host_Select_HostID_HostName" -ServerInstance "sql1" -Database "SysMetrics" | + | $HostList = Invoke-Sqlcmd -Query "exec Windows.Host_Select_HostID_HostName" -ServerInstance "sql1" -Database "JiMetrics" |
| $HostList | ForEach-Object { | $HostList | ForEach-Object { | ||
| $HostName = $_.HostName | $HostName = $_.HostName | ||
| Line 46: | Line 46: | ||
| $sql = "EXEC Windows.Host_Update $HostID, '$Domain', '$OS', '$OSArchitecture', '$OSServicePack', '$OSVersionNumber', '$HardwareModel', '$HardwareVendor', $MemorySizeGB, '$CPUType', $CoreCount" | $sql = "EXEC Windows.Host_Update $HostID, '$Domain', '$OS', '$OSArchitecture', '$OSServicePack', '$OSVersionNumber', '$HardwareModel', '$HardwareVendor', $MemorySizeGB, '$CPUType', $CoreCount" | ||
| - | Invoke-Sqlcmd -Query $sql -ServerInstance "sql1" -Database "SysMetrics" | + | Invoke-Sqlcmd -Query $sql -ServerInstance "sql1" -Database "JiMetrics" |
| } | } | ||
| </code> | </code> | ||
windows/powershell/updatehost.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
