get_device_breakdown

POST /redrock/query

{  
   "Script":"@/lib/get_device_breakdown.js",
   "Args":{  
      "PageNumber":1,
      "PageSize":10,
      "Limit":10,
      "SortBy":"",
      "direction":"False",
      "Caching":-1
   }   
}

{
    "success": true,
    "Result": {
        "IsAggregate": false,
        "Count": 10,
        "Columns": [
            {
                "Name": "ID",
                "IsHidden": false,
                "DDName": "_ID",
                "Title": "ID",
                "DDTitle": "ID",
                "Description": "Row Identifier (primary key)",
                "Type": 12,
                "Format": null,
                "Width": 0,
                "TableKey": "Primary",
                "ForeignKey": null,
                "TableName": "Device"
            },
            {
                "Name": "Platform",
                "IsHidden": false,
                "DDName": null,
                "Title": "Platform",
                "DDTitle": null,
                "Description": null,
                "Type": 16,
                "Format": null,
                "Width": 0,
                "TableKey": null,
                "ForeignKey": null,
                "TableName": ""
            },
            {
                "Name": "DisplayOsVersion",
                "IsHidden": false,
                "DDName": "DisplayOsVersion",
                "Title": "Display OS Version",
                "DDTitle": "Display OS Version",
                "Description": null,
                "Type": 12,
                "Format": null,
                "Width": 0,
                "TableKey": "NotAKey",
                "ForeignKey": null,
                "TableName": "Device"
            },
            {
                "Name": "_I18N_state_of_device",
                "IsHidden": false,
                "DDName": null,
                "Title": null,
                "DDTitle": null,
                "Description": null,
                "Type": 16,
                "Format": null,
                "Width": 0,
                "TableKey": null,
                "ForeignKey": null,
                "TableName": ""
            },
            {
                "Name": "DisplayState",
                "IsHidden": false,
                "DDName": "DisplayState",
                "Title": "State",
                "DDTitle": "State",
                "Description": "Device state text (e.g. Enrolling, Enrolled, Unreachable, Unenrolled)",
                "Type": 12,
                "Format": null,
                "Width": 0,
                "TableKey": "NotAKey",
                "ForeignKey": null,
                "TableName": "Device"
            }
        ],
        "FullCount": 13,
        "Results": [
            {
                "Entities": [
                    {
                        "Type": "Device",
                        "Key": "0e77...",
                        "IsForeignKey": false
                    }
                ],
                "Row": {
                    "DisplayState": "Enrolled",
                    "Platform": "iOS",
                    "ID": "0e77...",
                    "DisplayOsVersion": "iOS 11",
                    "_I18N_state_of_device": "compliance_summary_status_not_compliant"
                }
            },
            {
                "Entities": [
                    {
                        "Type": "Device",
                        "Key": "1fb1...",
                        "IsForeignKey": false
                    }
                ],
                "Row": {
                    "DisplayState": "Unreachable",
                    "Platform": "Android",
                    "ID": "1fb1...",
                    "DisplayOsVersion": "Android 5.1",
                    "_I18N_state_of_device": "compliance_status_unknown"
                }
            },
            ...
        ],
        "ReturnID": ""
    },
    "Message": null,
    "MessageID": null,
    "Exception": null,
    "ErrorID": null,
    "ErrorCode": null,
    "InnerExceptions": null
}