Symptoms
When you view subcollections on child sites, some subcollections may be shown in the Systems Management Server (SMS) Administrator console, and others may not appear. For example, one child site may have a specific subcollection, while another child site does not. Note that the missing subcollections are the subcollections that are created from a parent site, not those that are created locally to the child site.
Resolution
The SMS Administrator console only presents collections that are defined both in the Collections and Collection_SubCollections SQL tables. Because of timing issues, SMS Collection Evaluator and SQL Monitor may not correctly update both tables.