[Environment]
SDS IAM & EMM
Samsung devices

[Summary]

I want to create a report that provides details of all devices associated with Samsung EMM SDS & IAM.

 

[Resolution]
In the Reporting tab create a report with the following syntax:

Select name, serial, modelname, osversion, owner, carrier, phonenumber, imei, case(State) when 3 then 'Unreachable/Enrolled' when 4 then 'Unenrolled' end as Staus From Device

3 definition: unreachable, enrolled
4 definition: unenrolled