When updating from version 8 to a higher version, inactive Agents are not shown in the System Overview.

Document ID : KB000088178
Last Modified Date : 14/04/2018
Show Technical Document Details
Error Message :

When upgrading from version 8 some of the Agents are not visible within the System Overview.
In the past we updated the OH_isTemplate with 0 for all OH’s where oh_otype = ‘HOST’.  During the upgrade the new field is added to OH with a default value of <NULL>.  This value is changed by the system as soon as an Agent connects to the System.  All Agents that have not connected to the system since the start (after the upgrade) are not visible within the System Overview.  This is due to the query that delivers the objects to display within the System Overview is using a 0 and not <NULL>.

Cause type:
Root Cause: This is because the new column OH_IsTemplate is initially set to NULL but is expected to be 0 or 1.
This field was added on 30/03/2017. This article has not been updated yet. Refer to the "Description" or "Workaround" sections for solution information.

Fix Status: Released

Fix Version(s):
Automation Engine 11.2.1 - already available
Automation Engine 11.1.3 - already available
Automation Engine 10.0.7 - already available
Additional Information:
Workaround :
Get a SQL update statement from Automic Support.