Avalanche Reporting: Custom Report for Serial Number and Modelname.

Version 1

    Summary:

    This would be how to create a custom report, reporting the devices ModelName and SerialNumber

     

    Custom Report :

     

    Select b.Model, a.PropertyValue

    From DeviceProperty as a, MobileDevice as b

    Where a.PropertyName='SerialNumber' and a.DeviceId=b.Id