Close Menu
    Facebook X (Twitter) Instagram
    Sunday, October 12
    X (Twitter) LinkedIn Reddit RSS
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»CM2012»SCCM Migration report Collections with mix of users and computers

    SCCM Migration report Collections with mix of users and computers

    Eswar KonetiBy Eswar KonetiApril 01, 1:17 pm1 Min Read CM2012 248 Views
    Share
    Facebook Twitter LinkedIn Reddit

    If you are planning to migrate your SCCM 2007 environment to SCCM 2012,you may have to think about your packages,collections,OSD and other stuff.

    you cannot migrate all collections from SCCM 2007 to SCCM 2012.Couple of things to note before you migrate them.

    Points to note  on collection migration:

    1. Collection can contain only either devices or users but not both.

    2.  Every collection must have Limitation.

    3.   Sub collections are no longer exists instead you have folders.

    blogged couple of posts on archiving/removing packages not been used for X days that will help you to not migrate them to CM12.

    In this blog,will show you how to identify the collections that has both users and computers member of it  to look at the collections if you want to take of users/Computers query before you go on migration.

    Configmgr Report:

    select
    fcm.CollectionID 'Collection ID',COLL.Name
    from
    v_FullCollectionMembership fcm,v_Collection COLL
    where fcm.CollectionID=coll.CollectionID
    group by
    fcm.CollectionID,COLL.Name
    having
    count(distinct fcm.ResourceType) > 1

    CM12 Collection Collection mix of users and computers Migration ResourceType SCCM 2007 SCCM 2012 sccm report
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    SCCM SQL Report – Compare Installed Apps on TWO Different Computers

    July 13, 10:35 am

    Migrate Microsoft 365 Updates from SCCM/MECM to Intune for Co-Managed Devices

    February 11, 9:50 pm

    Monitoring Endpoint Security Applications with SCCM ConfigMgr SQL

    October 11, 8:48 pm

    Leave a ReplyCancel reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Sign Up

    Get email notifications for new posts.

    Author

    I’m Eswar Koneti ,a tech enthusiast, security advocate, and your guide to Microsoft Intune and Modern Device Management. My goal? To turn complex tech into actionable insights for a streamlined management experience. Let’s navigate this journey together!

    Support

    Awards

    Archives

    © Copyright 2009-2025 Eswar Koneti, All rights reserved.

    Type above and press Enter to search. Press Esc to cancel.