locked
SCCM Query for number of members in all collections RRS feed

  • Question

  • Hello, I would like to make the following query : having a list of all collections with their amount of members and their collection ID...

    The closest I have found in the report is the one that lists all the collections and their ID :

    SELECT Name , Comment, CollectionID FROM v_Collection order by Name

    But I would also like to have the number of members they have in them.

    Any help would be appreciated,


    Thanks!

    Thursday, November 22, 2012 7:20 PM

Answers

  • try this : http://eskonr.com/2012/11/sccm-report-count-computers-from-collections/

    Please click on "vote as Helpful" if you feel this post helpful to you.

    Eswar Koneti | My Tech blog: www.eskonr.com | Linkedin: Eswar Koneti

    • Proposed as answer by Sherry Kissinger Friday, November 23, 2012 12:51 PM
    • Marked as answer by Pierre-Luc R Friday, November 23, 2012 2:32 PM
    Friday, November 23, 2012 2:11 AM

All replies

  • try this : http://eskonr.com/2012/11/sccm-report-count-computers-from-collections/

    Please click on "vote as Helpful" if you feel this post helpful to you.

    Eswar Koneti | My Tech blog: www.eskonr.com | Linkedin: Eswar Koneti

    • Proposed as answer by Sherry Kissinger Friday, November 23, 2012 12:51 PM
    • Marked as answer by Pierre-Luc R Friday, November 23, 2012 2:32 PM
    Friday, November 23, 2012 2:11 AM
  • Exactly what I was looking for

    Many thanks!

    Friday, November 23, 2012 2:32 PM