I think my approach is going to be to walk from the instances up to build out a dataset.
-
Instances
-
- InstanceID
-
- DeviceID
-
- PrefCollectorID
-
Collector
-
- ID
-
- CollectorGroupID
So each object in my data set will contain the info to relate the instance to the Device and the Collector Group. That will allow me to gather the # of instance / device, sort by that, then distribute to the collectors in the group in a round robin fashion. Just have to figure out how to gather the next 1000 instances :)/emoticons/smile@2x.png 2x" title=":)" width="20"> I have that code somewhere laying around. Nearly there.