After having migrated our MySQL database from 5.6.x to 5.5.x, the database is populating with incorrect data. I had to re-save criteria on smart groups several times in order to gather valid machines. I'm wondering if there's a particular query I can run on our database to zone in on possible null values or other erroneous data within the table which contains smart computer groups. Does anyone have any experience or knowledge of this?
There seem to be a few issues around Smart Groups not updating properly in a number of cases in Casper 9 and there are a few threads similar to this one... I have been in touch with support a few times since upgrading about Smart Groups that did not update automatically and we found a few bugs (D-006041 and D-006066) that apparently they will be fixing in an upcoming release.
I don't know if this applies to yourselves but would the affected Smart Groups use extension attributes? This seemed to be the problem with us and in particular with pop-up menu extension attributes that we created manually.
If so, I'd be happy to share how we fixed the issue until the defects are rectified.
We are currently on 9.22 and see any Smart Group that is based on an extension attribute have this issue where the group membership continues to grow and grow. It's calculated once properly and then as systems check in it grows until all 28,000 systems are in that collection. I feel this is a 9.22 defect, does anyone see this on 9.32? Super annoying and really limits the product.