locked
List All Collection ID's RRS feed

  • Question

  • Is there a canned report that lists all Collection ID's in my SCCM 2012 environment? If not, which attributes would be use to create a query showing all collection id's?
    Wednesday, October 29, 2014 5:28 PM

Answers

  • SELECT CollectionID, Name FROM v_Collection ORDER BY Name Asc

    There is a built-in report:

    Software Distribution - Collections > All collections 


    • Edited by fern.santos Wednesday, October 29, 2014 5:40 PM
    • Proposed as answer by Jason Sandys [MSFT]MVP Wednesday, October 29, 2014 5:49 PM
    • Marked as answer by Joyce L Wednesday, November 5, 2014 6:39 AM
    Wednesday, October 29, 2014 5:38 PM
  • There is also a builtin report called "All Collections"which will list all collections in the site and their collectionIDs.

    Regards,
    Jörgen


    -- My System Center blog ccmexec.com -- Twitter @ccmexec

    • Proposed as answer by Jason Sandys [MSFT]MVP Wednesday, October 29, 2014 5:49 PM
    • Marked as answer by Joyce L Wednesday, November 5, 2014 6:39 AM
    Wednesday, October 29, 2014 5:40 PM

All replies

  • SELECT CollectionID, Name FROM v_Collection ORDER BY Name Asc

    There is a built-in report:

    Software Distribution - Collections > All collections 


    • Edited by fern.santos Wednesday, October 29, 2014 5:40 PM
    • Proposed as answer by Jason Sandys [MSFT]MVP Wednesday, October 29, 2014 5:49 PM
    • Marked as answer by Joyce L Wednesday, November 5, 2014 6:39 AM
    Wednesday, October 29, 2014 5:38 PM
  • There is also a builtin report called "All Collections"which will list all collections in the site and their collectionIDs.

    Regards,
    Jörgen


    -- My System Center blog ccmexec.com -- Twitter @ccmexec

    • Proposed as answer by Jason Sandys [MSFT]MVP Wednesday, October 29, 2014 5:49 PM
    • Marked as answer by Joyce L Wednesday, November 5, 2014 6:39 AM
    Wednesday, October 29, 2014 5:40 PM
  • Thank you very much.
    Wednesday, October 29, 2014 5:46 PM