Separate the domain from the node name

IF you have the SAM module and are using Asset Inventory you will get those columns.

Check out:

select

  hostname,

  SystemName,

  Domain,

  DNSName

from [AssetInventory_ServerInformation]

Of coarse that only work for nodes with asset inventory, would be nice to have [domain] in the nodesdata table also/instead

Just to let people know if they don't already,  the way that caption resolution works is that when you add the node Orion will initially try to use whatever method you are polling with to capture the hostname value of the machine.  If you put the fqdn as your hostname then that's what you will get in Orion.

If SNMP/WMI/etc isn't working or is not available then the next step is Orion tries to do a reverse DNS lookup based on the polled IP.

If none of those work then the Caption will just be the IP address you are polling.

In all of those cases once the node has been added the Caption is set and it will not automatically update itself again unless you manually edit it, the idea is that this will prevent Orion from over-writing any changes you make to the names.  For example if you add in a SQL AG listener address the hostname would show up as the active primary member, so you usually need to edit the caption to give it some kind of naming convention that lets you know this is a cluster VIP and not actually the address to poll that host on.

Also, there is already a DNS field (this does get automatically updated periodically) that contains the full FQDN based on the poller trying to resolve the IP in DNS. 

Could be nice if there was an option you could set on a per node basis to have Orion attempt to automatically update Captions as necessary.  And then maybe also an option to globally remove FQDN names.  That would be a killer for anyone who actually uses periods anywhere in their names, but that's probably a far off edge case compared to the 99.9% of environments where it would be safe to trim away anything to the right of period.