DB Query to list the deleted/unenrolled Devices

DM
D Malipatil
Daimler AG

Hello Team,

As I remember there is a Query to list out the deleted/unenrolled devices in the DB, possible to get that DB query ,

Also we want to check who deleted that device like user name.

We have not enabled in the Global Settings to Delete when it unenrolled toggle.

a year ago
SOTI MobiControl
ANSWERS
J
JCMOD@SOTI
a year ago

Hi D Malipatil,

Thank you for posting on SOTI Pulse.

Try SELECT * FROM dbo.DevInfo WHERE Mode < 0; to list devices that have been deleted/unenrolled. Equally you can use SELECT * FROM dbo.DevInfoModeLkup; to view the meaning of the various "Mode" values.


In regards to how to find out who unenrolled a device through the web console. You can export the logs of the respective user groups through "Users & Permissions" > "Logs".


To find the keywords you can perform a test unenrollment and observe the text shown in the "Description" column. Then use the generic keywords to quickly search the CSV export.


I hope this helps!

Regards,

Technical Support | SOTI Inc. |1.905.624.9828 | support@soti.net | www.soti.net