Endpoint Security Complete

Hi guys,

I upgraded our MDM to 7.2 over the weekend and it's appeared to upgrade without issue. Existing devices (which were upgraded ahead of time as per Implimentation guide) accepted policy changes and are communicating to the server ok.

Something I've noticed is that devices that have enrolled since the upgrade are populating data in the generic "Mobile_Devices" table (For example the UserID field, which we use to establish ownership), whereas pre-upgrade devices are still populating the Mobile_Device_iOS table for this type of data.

All devices are showing Client Date and last check in times as expected, they're just dumping this data in different tables. I've been through the documentation and there's no mention of this as expected behavior. Has anyone else come across this?

-EDIT-

Upon further investigation it looks like I am getting inventory from existing devices in the correct tables (Mobile_Device, Mobile_Phone, etc), the main data I'm missing is the UserID, I'm wondering if this information only gets populated upon enrollment.

The old devices are missing entires in the Mobile_Common table, but as soon as you specify if it's a corp or BYO device, that data remains.

Hi,

 

The userID, is populated from the user used during enrollment and can not be changed latter without enrollment, unless edited manually in the DB.

Run a SQL statement to update Mobile_Devices UserID with the value from Mobile_Device_iOS's UserID field.  You can do this manually without disasters.

Any luck with the SQL statement to update userID?

Thanks for that, Mina. That's what I ended up concluding, it makes sense it would only update that info upon enrollment. Great idea Mike, that will save me a job. SQL below if anyone else needs it: UPDATE dbo.Inv_Symantec_Mobile_Device SET UserId = dbo.Inv_Symantec_Mobile_Device_iOS.UserId FROM dbo.Inv_Symantec_Mobile_Device_iOS WHERE dbo.Inv_Symantec_Mobile_Device._ResourceGuid = dbo.Inv_Symantec_Mobile_Device_iOS._ResourceGuid P.S. Sorry for the delay in reply, I've been on leave.