Migrating SCCM 07 Queries RRS feed

  • Question

  • Hi there

    We're planning and testing migration to SCCM 2012 Sp1.

    We are currently running SCCM 2007 R3. We have a lot of collections built from SCCM queries. Some of these collections have direct memberships

    After I migrate these collections, only the direct memberships are populated in the collections on the CM 2012 destination environment

    I have since read that queries are not migrated?

    We have over 200 collections built from dynamic query.  What options do we have here aside from re-writing all the queries in CM 2012??

    Can you advise if there is an easy way to bulk export/import all the SCCM queries from 2007 and import them to 2012 SP1?

    Any help greatly appreciated

    • Edited by Max_Christopher Monday, November 18, 2013 9:26 PM updated for readability
    Monday, November 18, 2013 9:16 PM


All replies

  • Collection queries will be migrated by default (exception: collections containing users and computers at the same time).
    How do the existing queries look like? Is there anything special?

    Torsten Meringer | http://www.mssccmfaq.de

    Monday, November 18, 2013 9:57 PM
  • Hi,

    Under the collections membership rules, the query is visible, however none of the queries are populating the collections in the new 2012 environment

    Here's an example of a collection which is built from an AD Group membership (this is copy/paste directly from CM 2012 console). This collection has several members in the 2007 environment, 0 in the 2012 environment. If I add direct memberships, they show up almost instantly (after update coll membership and refresh)

    select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.SystemGroupName = "DOMAIN\GROUPNAME"

    Any ideas?

    Max Christopher

    Monday, November 18, 2013 10:29 PM
  • Have you enabled AD group discovery on the CM12 site at all? That's needed to populate the group information.

    Torsten Meringer | http://www.mssccmfaq.de

    Monday, November 18, 2013 10:48 PM
  • Torsten, thankyou.. amazing how you can overlook the small details when doing some testing/playing around.. i've just enabled, hopefully that should tidy things up.

    Again, thanks..


    Max Christopher

    Tuesday, November 19, 2013 1:58 AM
  • OK, enabled AD group discovery and kicked off full discovery last night.

    Returned this morning, and the memberships are populating. thanks..

    Something else I've noticed though, is that all my log files appear to have a date/timestamp of 01/01/1601 12:00am ?

    Date and time on server is correct.. anyone have any ideas on this?

    Max Christopher

    Tuesday, November 19, 2013 9:17 PM
  • Which timestamp are you talking about? The one on the file system? Or something that can be found in the logs?

    Torsten Meringer | http://www.mssccmfaq.de

    Tuesday, November 19, 2013 10:17 PM
  • The one on the logs Torsten, all the server log files have the following <snip>

    Max Christopher

    Tuesday, November 19, 2013 10:20 PM
  • I've seen this behavior when using the "wrong" version of cmtrace.exe (rtm vs sp1). Just give it a try.

    Torsten Meringer | http://www.mssccmfaq.de

    Tuesday, November 19, 2013 10:36 PM
  • Thanks will re-download, as the Trace32 I'm using is from the ConfigMgr 2007 toolkit.. I'll try out this afternoon.


    Max Christopher

    Tuesday, November 19, 2013 11:08 PM