Hi James, you can mark the mgmt server as removed by sql below
update mshost set removed=now() where id=XXX; -Wei On Tue, 3 Aug 2021 at 16:16, James Steele <jsteele.em...@gmail.com> wrote: > Hi, I have an unwanted management server reported here on macfgan01, it is > marked as DOWN: > > mysql> SELECT * FROM mshost; > > +----+-----------------+---------------+----------+--------------------------------------+-------+----------+------------+--------------+---------------------+---------+-------------+ > | id | msid | runid | name | uuid > | state | version | service_ip | service_port | > last_update | removed | alert_count | > > +----+-----------------+---------------+----------+--------------------------------------+-------+----------+------------+--------------+---------------------+---------+-------------+ > | 1 | 207360503444273 | 1627662680438 | macfgan01 | > f685b3cf-5459-4425-bd2e-6be2865540c4 | Down | 4.15.1.0 | 10.257.0.4 | > 9090 | 2021-07-30 17:17:36 | NULL | 0 | > | 2 | 279278805491062 | 1627987566294 | macfgan01 | > 64ce078b-e945-475d-a9d6-30dbe30569a7 | Up | 4.15.1.0 | 10.257.0.4 | > 9090 | 2021-08-03 10:46:27 | NULL | 0 | > | 3 | 191709488474348 | 1627987314655 | macfgan05 | > 03544bf1-41af-4d5f-b36d-e7190b3c5504 | Up | 4.15.1.0 | 10.257.0.8 | > 9090 | 2021-08-03 10:46:28 | NULL | 0 | > | 4 | 38182022782117 | 1627980352341 | macfgan04 | > 19c51d30-2d29-4a0e-8991-1af35835b6dd | Up | 4.15.1.0 | 10.257.0.7 | > 9090 | 2021-08-03 10:46:27 | NULL | 0 | > | 5 | 209430416376190 | 1627987033082 | macfgan02 | > de6d0fa5-6c8f-40b4-88de-7a9bcf717e07 | Up | 4.15.1.0 | 10.257.0.5 | > 9090 | 2021-08-03 10:46:27 | NULL | 0 | > | 6 | 205492837091104 | 1627987210052 | macfgan03 | > 5ed659d7-8c9b-4499-86a0-321531fab9aa | Up | 4.15.1.0 | 10.257.0.6 | > 9090 | 2021-08-03 10:46:27 | NULL | 0 | > > +----+-----------------+---------------+----------+--------------------------------------+-------+----------+------------+--------------+---------------------+---------+-------------+ > 6 rows in set (0.00 sec) > > > What are the commands needed to remove this management server? MySQL > newbie question probably! > > TIA, Jim >
