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视频网络电话为企业大规模部署
