none
Need list of devices added in multiple device collections RRS feed

  • 問題

  • Hi,

    I want to get list of devices added to multiple device collection from SCCM. please guide.

    Regards

    2019年12月4日 上午 09:27

所有回覆

  • Using this query you can get collection details for specific device, I dont think we can get it for list of device at the same time.

    select 
    C.CollectionID,
    C.Name,
    C.Comment
    from 
    dbo.v_Collection C
    join dbo.v_FullCollectionMembership FCM on C.CollectionID = FCM.CollectionID
    Where
    FCM.Name = 'Computername'

    Also check this blog

    https://blogs.technet.microsoft.com/configurationmgr/2009/08/24/how-to-find-the-collection-membership-information-of-a-specific-client-machine/

    2019年12月4日 上午 10:02
  • All sccm clients will always belong to a minimum of two collections, so what exactly is the goal.

    Garth Jones

    Blog: https://www.enhansoft.com/blog Old Blog: https://sccmug.ca/

    Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleashed

    2019年12月4日 下午 12:29
    版主
  • This will show you all resources that are members of more than two collections (excluding the built-in All Systems and All Desktops and Servers collections):

    SELECT v_R_System_Valid.Netbios_Name0
    , count(v_FullCollectionMembership.CollectionID) As CollectionCount
    FROM v_FullCollectionMembership
    INNER JOIN v_R_System_Valid
      ON v_R_System_Valid.ResourceID = v_FullCollectionMembership.ResourceID
    WHERE v_FullCollectionMembership.CollectionID NOT IN ('SMSDM003','SMS00001')
    GROUP BY v_R_System_Valid.Netbios_Name0
    HAVING count(v_FullCollectionMembership.CollectionID) > 1


    Jason | https://home.configmgrftw.com | @jasonsandys

    2019年12月4日 下午 01:37
  • Hi,

    Hope to get a more detailed description of the list you want, both Kalyan and Jason's sql query are useful, just depends on your requirement.

    Regards,
    Allen

    Please remember to mark the replies as answers if they help.

    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    2019年12月5日 上午 05:55
  • Hi,

    It seems there is no update for a couple of days. May we know the current status of the problem? Is there any other assistance we can provide?

    If the above responses help you, please mark them as answers.

    Regards,
    Allen


    Please remember to mark the replies as answers if they help.

    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    2019年12月11日 上午 08:31