Hi,
I have a required to merge all sub-collection to another new single collection as in below scenario.
Main Root collections are Root A and Root B which doesnt have any members, but sub-collection. Now in each subcollection, there are multiple members, say 100-200 computer objects.
Root A
A1
A2
A3
Root B
B1
B2
B3
Now I required to merge all these subcollections of Root A and Root B sub-collections to a new collection called Root_All.
And in future, whenever we will be adding more subcollection in Root A and Root B, the machines in those new sub-collection also should visible under the Root_All collection.
We have access only to use the SQL SCCM query in the collection. Please help on this.
Regards
Sudheep