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>.
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
Automation Engine 11.2.1 - already available
Automation Engine 11.1.3 - already available
Automation Engine 10.0.7 - already available
Get a SQL update statement from Automic Support.