Sometimes, Managed Host doesn't show under System and License management after adding. This article explains how to fix this issue
This is because the status of the Managed host shows ADDING in the database:
# psql -U qradar -c "select * from managedhost where ip=''<Managed Host IP>;"
id | ip | hostname | status | isconsole | appliancetype | creationdate | updatedate | qradar_version | primary_host | sec
ondary_host | haoptions | email_server_id
-----+---------------+------------+--------+-----------+---------------+------------------------+-------------------------+----------------+--------------+----
------------+-----------+-----------------
253 | Managed Host IP | jpams-jsa1 | ADDING | f | 1626 | 2014-02-12 01:55:46.82 | 2025-07-28 08:17:15.966 | 7.5.0 | 251 |
| | 1
(1 row)
To fix the issue,
-> Change the state of the host from ADDING to Active in the managed host by following the steps :
-> Take a backup of the database:
mkdir -p /store/ibm_support/TS019929832/ pg_dump -U qradar -t managedhost --inserts -f /store/ibm_support/TS019929832/managedhost-$(date +%F_%R).sql
-> Set the host to 'Active' in the managedhost table:
# psql -U qradar -c "update managedhost set status ='Active' where id=253"
->Refreshed the GUI, and host will be visible.
->Do full deploy configuration