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

모든 응답

  • 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

    • 답변으로 제안됨 Kalyan Sundar 2019년 12월 4일 수요일 오후 3:07
    2019년 12월 4일 수요일 오후 1: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일 목요일 오전 5: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일 수요일 오전 8:31