-
Title
Hostname missing for a SQL Server agent in Global View databases dashboard -
Description
Host name is missing in Global View Database Dashboard for a SQL Server agent.
There are no associated errors in the FMS or SQL Server agent log files that accompany this error
-
Cause
Host Group collection has been disabled, so it cannot collect the SQL Server instance hostname to display in the databases dashboard.
In cases where the DBSS_Host_Group collection is enabled for a while and then disabled later for some reason, the hostname will not disappear immediately, since UI displays the hostname from the ‘last collected’ topology until this topology is deleted based on the FMS retention policy. The default retention policy is deleting the topology object after 1 month if there is no more update for this topology. So the hostname will disappeared after 1 month. This is why a user can observe a hostname in the dashboard even though the DBSS_Host_Group collection is disabled.
-
Resolution
Activate the DBSS_Host_Group collection in the Agent Status Properties or the SQL Server Host Group collection in the SQL Server agent administration panel.