Installation consist of scom 2007 r2 on windows 2003 r2 with one management group. About 15 management packs deployed and about 3000 agents. All in all it is working good but recently I stumble upon an issue with populating dynamic groups. Although I've excluded members (windows computer entity) from a dynamic group (either by exclude tab or by query) it doesn't seems to work.
In view members entity isn't there but I have health state view which is narrowed to that group and that computer is still showing there. By querying the db I can see that computer is still member of that group although view members doesn't shows it.
I've tried creating new groups with different kind of queries and behavior is the same. Even tried creating groups in different management packs. All the same. Waited for interval to pass, the same.
Any ideas what to look at next?