Skip to main content
How can we help?
< All Topics
Print

Virtual servers with no matching entry in dbo.hosts

A virtual server must have a corresponding host entry in the dbo.hosts 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 virtual servers that do not have a corresponding entry in dbo.hosts, use:

select s.server_name
from dbo.v_servers s
left join dbo.hosts h on h.host_name =
case
	when s.host_name is not null then s.host_name
	when s.physical_netbios_name is not null then s.physical_netbios_name
end
where s.is_virtual = 1
group by s.server_name

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.

Table of Contents