Bulk or Mass Update Node Name (Caption) with Host SysName in SolarWinds Orion散裝或大規模更新節點名稱（標題）與主機SysName在獵戶座SolarWinds
SolarWinds Orion is a network performance monitoring system that easy to use yet powerful. SolarWinds獵戶座是一個網絡性能監測系統，易於使用且功能強大。 The SolarWinds Orion NPM or NMS allows users add nodes or devices for statistics polling and availability tracking.獵戶座的SolarWinds故宮或網管系統允許用戶新增節點或設備的統計投票站和可用性跟踪。 For device or system with SNMP enabled, Orion will automatically assign the host name or device name as the display name (aka node name) in Orion Web Console or System Manager, although users also have ability to change and assign whatever name they want.對於設備或系統的SNMP啟用，獵戶座會自動分配主機名稱或設備名稱作為顯示名稱（又名節點名稱）在獵戶座Web控制台或系統管理員，但用戶也有能力改變，並指派任何名義他們想要的。
Over the time, when administrator updates, changes or edit the hostname of the systems or device name for network nodes, the actual name of the system or device will be different and not the same with node name displayed on Orion.在時間，當管理員更新，變更或修改的主機系統或設備名稱為網絡節點，實際的名稱，系統或設備會有所不同，而不是同樣的節點名稱上顯示的獵戶座。
SolarWinds Orion has rediscovery feature that continuously poll the monitored switch, router, firewall, computer, and other devices for it’s current hostname. SolarWinds獵戶座已再現功能，不斷地調查監測交換機，路由器，防火牆，計算機和其它設備為它目前的主機名。 However, the rediscovering function will only update the SysName field in the Solarwinds database, and not the Caption field which represents the node name to display in Orion.然而，重新發現功能將只更新SysName領域中的Solarwinds的數據庫，而不是字幕外地代表節點的名字顯示在獵戶座。
Administrators who want to maintain the same node name between the host name of actual physical device and Orion node name can either manually change the node name in Orion, or use the trick below to let Orion automatically uses the latest and current name as node name: Go to System Manager , right click the node to change name, and then click on Node Details .管理員誰要保持同樣的節點之間的主機名稱的實際物理設備和Orion節點名稱可以手動更改名稱的節點在獵戶座，或使用下面的伎倆，讓獵戶座自動使用最新的和現有的名稱節點名稱：進入系統管理器中，右鍵單擊節點，以改變名稱，然後按一下節點詳細信息。 Delete and empty the current Name text box, and then hit Enter .刪除和清空當前的名稱文本框中 ，然後按下 Enter鍵即可。 Orion will obtain the new hostname of the device from SysName field in database.獵戶座將獲得新的主機設備由SysName領域的數據庫。 Save the new name by clicking on Apply Changes .保存的新名稱按一下套用變更 。
Above trick works on change of name on a few nodes.上述伎倆工程更改名稱的幾個節點。 However, if the number of devices is huge and many, it’s possible to mass or bulk change using the SQL manipulation queries directly in the Orion database.但是，如果一些設備是巨大的，許多，很可能大規模或批量改變使用SQL查詢直接操縱在獵戶座的數據庫。 To do so, users have to use Database Manager or SQL Server Management Studio to run the SQL statements.為了做到這一點，用戶必須使用數據庫管理器或SQL Server Management Studio中運行SQL語句。
Note: Users using SolarWinds Orion NPM prior to version 9 have to Network Performance Monitor service prior to running the SQL update statement to update the caption.注：用戶使用SolarWinds獵戶座故宮前的版本有9對網絡性能監測服務之前運行SQL更新語句，以更新標題。
SQL Query to Check for Nodes with Different or Not Matching Caption and SysName (To Update Caption) SQL查詢來檢查節點不同或不匹配的字幕和SysName （更新字幕）
SELECT Caption, SysName, IP_Address FROM Nodes選擇標題， SysName ，從節點的IP地址
WHERE ((Caption <> SysName) AND (SysName <> ”))在哪裡（ （標題“ ” SysName ）項和（ SysName “ ” “ ） ）
ORDER BY Caption命令標題
SQL Command to Update the Node Caption Field with Value from SysName Field (Current Host Name) SQL命令，以更新的節點標題場SysName價值從外地（當前主機名）
UPDATE Nodes最新節點
SET Caption = SysName設置標題= SysName
WHERE Caption in (SELECT Caption FROM Nodes WHERE ((Nodes.Caption <> Nodes.SysName) AND (Nodes.SysName <> ”)))在哪裡字幕（字幕選擇從節點在哪裡（ （ Nodes.Caption “ ” Nodes.SysName ）項和（ Nodes.SysName “ ” “ ） ） ）
Both SQL statements above exclude nodes that have blank SysName field, which is normally the case for devices that are monitored as ICMP only (ping).這兩個SQL語句上述排除節點已SysName領域的空白，這是通常的情況設備，監測的ICMP只（平） 。 All other SNMP nodes, including nodes that have been manually renamed, will have a overwritten and updated node name according to the SysName after running the update command.所有其他SNMP的節點，包括節點已改名為手動，將有一個覆蓋和更新節點名稱根據SysName後，運行更新命令。
IMPORTANT : This is a machine translated page which is provided "as is" without warranty. 重要說明：這是一台機器翻譯網頁這是“原樣”提供，無保修。 Machine translation may be difficult to understand.機器翻譯可能很難理解。 Please refer to請參閱 original English article英文原文的文章 whenever possible.只要有可能。
Share and contribute or get technical support and help at共享和貢獻或獲得技術支持和幫助 My Digital Life Forums 我的數字生活論壇 . 。
Related Articles相關文章
- Windows Update or Office Update Encounters 0×80070643 Failed Update Error Windows Update或Office Update遭遇0 × 80070643無法更新錯誤
- Cannot FTP to Web Host or Server running cPanel/WHM不能的FTP到Web主機或服務器運行的cPanel /的WHM
- How to Change Hostname in cPanel Web Host如何更改主機的網絡主機的cPanel
- Top 10 Consumer Electronic Gadgets that Going to be Mass Popular十大消費電子小工具將大規模流行
- Create and Host Website for Free at Weebly建立和主機網站免費在Weebly
- Samsung Announces 128GB MLC-Based SSD Now In Mass Production三星宣布128GB剛果解放運動為基礎的SSD目前在大規模生產
- Caption Disabler WordPress Plugin to Disable and Remove Captions Functionality標題Disabler WordPress的插件禁用和刪除字幕功能
- Host Your Domain Email with Google on Gmail Technology主機您的網域電子郵件，谷歌在Gmail技術
- Auto Delete Forwarded Emails in cPanel Web Host自動刪除轉發電子郵件的cPanel的網頁主機
- New TANDBERG E20 Video VoIP Phone For Enterprise Mass Deployment新泰德E20視頻網絡電話為企業大規模部署
