Known Issue: Hybrid MDM Migration and DEP Device Records

Published Feb 27 2019 04:07 PM 1,996 Views

We recently became aware of a known issue as part of the hybrid MDM migration. Customers mentioned that the Apple DEP device records are remaining in the ConfigMgr console. Unfortunately, once the MDM authority is changed to Intune, admins cannot remove these devices from the ConfigMgr console.
 
There’s two workarounds:
  1. If you happen to run into this prior to changing your MDM authority, then kindly delete the DEP records from ConfigMgr.
  2. If you’ve already migrated, then you can run the SQL command below on the ConfigMgr database, which will remove the records:
    Delete from MDMCorpOwnedDevices where DeviceType=8 and DiscoverySources=4
 
Here's documentation in case you would like additional information: 

https://docs.microsoft.com/sccm/mdm/deploy-use/migrate-change-mdm-authority#bkmk-ki-dep 

%3CLINGO-SUB%20id%3D%22lingo-sub-357949%22%20slang%3D%22en-US%22%3EKnown%20Issue%3A%20Hybrid%20MDM%20Migration%20and%20DEP%20Device%20Records%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-357949%22%20slang%3D%22en-US%22%3E%3CDIV%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%3CBR%20%2F%3EWe%20recently%20became%20aware%20of%20a%20known%20issue%20as%20part%20of%20the%20hybrid%20MDM%20migration.%20Customers%20mentioned%20that%20the%20Apple%20DEP%20device%20records%20are%20remaining%20in%20the%20ConfigMgr%20console.%20Unfortunately%2C%20once%20the%20MDM%20authority%20is%20changed%20to%20Intune%2C%20admins%20cannot%20remove%20these%20devices%20from%20the%20ConfigMgr%20console.%20%3C%2FFONT%3E%3C%2FDIV%3E%0A%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3EThere%E2%80%99s%20two%20workarounds%3A%3C%2FFONT%3E%3C%2FDIV%3E%0A%3COL%3E%0A%3CLI%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3EIf%20you%20happen%20to%20run%20into%20this%20prior%20to%20changing%20your%20MDM%20authority%2C%20then%20kindly%20delete%20the%20DEP%20records%20from%20ConfigMgr.%20%3C%2FFONT%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3EIf%20you%E2%80%99ve%20already%20migrated%2C%20then%20you%20can%20run%20the%20SQL%20command%20below%20on%20the%20ConfigMgr%20database%2C%20which%20will%20remove%20the%20records%3A%3C%2FFONT%3E%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CDIV%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%26nbsp%3B%20%26nbsp%3B%20%3CFONT%20color%3D%22%230000ff%22%3EDelete%20from%3C%2FFONT%3E%20MDMCorpOwnedDevices%20%3CFONT%20color%3D%22%230000ff%22%3Ewhere%3C%2FFONT%3E%20DeviceType%3D8%20%3CFONT%20color%3D%22%23808080%22%3Eand%3C%2FFONT%3E%20DiscoverySources%3D4%3C%2FFONT%3E%3C%2FDIV%3E%0A%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3EHere's%20documentation%20in%20case%20you%20would%20like%20additional%20information%3A%26nbsp%3B%3C%2FFONT%3E%3C%2FFONT%3E%3CP%3E%3CSPAN%20style%3D%22color%3A%20%23538135%3B%22%3E%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fdocs.microsoft.com%252Fsccm%252Fmdm%252Fdeploy-use%252Fmigrate-change-mdm-authority%2523bkmk-ki-dep%26amp%3Bdata%3D04%257C01%257Ccacamp%2540microsoft.com%257Caa3e9292039e48fc204f08d69cf65f30%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C636868979327867887%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C-1%26amp%3Bsdata%3DcIJSq37m0lwYfpk%252B5yPuT3jghkNDHtVYO%252FpmdXv9iTU%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fsccm%2Fmdm%2Fdeploy-use%2Fmigrate-change-mdm-authority%23bkmk-ki-dep%3C%2FA%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%0A%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-357949%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20those%20of%20you%20using%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsccm%2Fmdm%2Funderstand%2Fhybrid-mobile-device-management%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EHybrid%20MDM%3C%2FA%3E%2C%20the%20following%20known%20issue%20may%20be%20useful%20as%20you%20migrate.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-357949%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EIntune%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESupport%20Tip%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Feb 27 2019 04:07 PM
Updated by: