A SQL Server database is configured to use the FQDN (Fully Qualified Domain Name).
In the Agent Status Properties (ASP) of the database agent is the following:
monICHostName=HOSTNAME
monHost=myhost.subdomain.domain
In the agent log file was printed
INFO [DBSS-myhost.subdomain.domain.-INTB1W-highPriorityPool-1] com.quest.qsi.fason.sqlserver.agent.SqlServerAgentData - Physical host name changed from null to HOSTNAME
Since the user does not want to use the short hostname, the parameter was disabled.
If the osUsePhysicalHostName=0 , the SQL Server agent will use the SQL Server Host (monHost=myhost.subdomain.domain) as the hostname for the OS connection, otherwise else it will use the short hostname which comes from database from this query:
Select ServerProperty ( 'ComputerNamePhysicalNetBIOS' ) as host_name
Users can find the FQDN name in the OS collection log.
INFO [DBSS-myhost.subdomain.domain-lowPriorityPool-1-[DBSS_Maintenance][]] com.quest.glue.core.services.AgentEstablishedConnectionStore - Established a PoolableWMINativeConnectionImpl connection to myhost.subdomain.domain [root/cimv2]
The SQL Server agent will also use the short hostname "HOSTNAME" which come from the database to create the Infrastructure (IC) agent.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center