Avalanche 6.1 - How To Create Custom Report Showing Device Serial Numbers

Version 2

    Verified Product Versions

    Avalanche 6.1Avalanche 5.3


    Avalanche 6.0 or 6.1

    Using AIDC (Ruggedized Mobile Devices)


    How To Video:


    Step-by-Step Instructions

    1. Log into Avalanche 6.1
    2. Click on 'Reports'
    3. In the configured reports section, press the + sign to 'Add Report'
    4. Select Custom Report
    5. Select Enterprise Server and click Next
    6. Select DeviceProperty and check the box for PropertyValue
    7. In the select line add "b.Model as ModelName, a.PropertyValue as SerialNumber"
    8. In the From line add "DeviceProperty as a, MobileDevice as b"
    9. In the Where line add "a.PropertyName='SerialNumber' and a.DeviceId=b.Id"
    10. Press the 'Test' button to verify that you have entered the right values.
    11. If it shows two columns (modelname and the Serial Number) then you are good to go and press "Next"
    12. Enter the name of the report and the output format and press Next
    13. Press Finish
    14. Select the report and press "Run Now"
    15. Wait a few moments and then Press F5 to refresh the screen and your report should appear in the completed reports section