Hopefully by the time i get in to work tomorrow I can put a solve setting on this thread.
Yes I think you can.
Hosts are still here !!!
I can’t reproduce group issue, during 1 hour I delete hosts from groups, include them in existing or new groups, modify by group image association, service settings, active directory, and snapins.
I lost 1 member in a group only one time, 66 members at start, and 65 after modifying settings in the group, not sure but I think after active directory settings.
I decided to do that because I thought that after this bug my database was in an inconsistancy state.
I sent these 3 requests to my database:
SELECT * FROM hosts
WHERE hostID
NOT IN (SELECT hmhostID
FROM hostMAC
)
Before update, I had a lot of rows in result, and growing. But now it’s ok.
SELECT * FROM hostMAC
WHERE hmhostID
NOT IN (SELECT hostID
FROM hosts
)
Never had result, was ok and is still ok
SELECT * FROM snapinAssoc
WHERE saHostID
NOT IN (SELECT hostID
FROM hosts
)
Returned a few rows in result, maybe not directly due to this bug, maybe this table was corrupted before.
I think that tables refer to hosts by Mac adresses, except snapinAssoc table. Is it right ?
So with these 3 requests, I can find bad hosts and bad snapin assoc, and I delete them from database.
But maybe I forgot one or several tables to check ?
Thank you for you job !