Below is the SQL code needed to retrieve all of the collections from ConfigMgr. This is useful when creating custom reports that need to be scoped to a specific collection. The query below selects the CollectionName and CollectionID columns and sorts the CollectionName column alphabetically.
|
1 2 3 |
SELECT CollectionName, CollectionID FROM v_Collections ORDER BY CollectionName |
Results from the query on my test system.
