Virtual servers without a host_name set

A virtual server must have a corresponding host_name entry in the dbo.servers table. This is used for e.g. license calculations.

Hosts can be set in the Performance Store Control Center, see the “Host configuration” section in the Quick Start Guide for details.

To query the Performance Store database for servers with no host_name set in dbo.servers, use:

select s.*
from dbo.v_servers s
where s.is_virtual = 1
and isnull(s.host_name, s.physical_netbios_name) is null

The alert will be visible on the Latest stats dashboard.

To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.