get_servers_top

Gets the servers with the most checkouts.

Path:
/lib/get_servers_top_checkouts.js

Parameters:
None.

Example Request:

POST /redrock/query

{  
   "Script":"@/lib/get_servers_top_checkouts.js"
}

Example Response:

{
    "success": true,
    "Result": {
        "IsAggregate": false,
        "Count": 3,
        "Columns": [
            {
                "Name": "ID",
                "IsHidden": false,
                "DDName": "ComputerID",
                "Title": "ID",
                "DDTitle": "Guid",
                "Description": null,
                "Type": 12,
                "Format": null,
                "Width": 0,
                "TableKey": "NotAKey",
                "ForeignKey": "Server",
                "TableName": "Event"
            },
            ...
        ],
        "FullCount": 3,
        "Results": [
            {
                "Entities": [
                    {
                        "Type": "Server",
                        "Key": "9ac809bc-...",
                        "IsForeignKey": true
                    },
                    {
                        "Type": "Event",
                        "Key": "772a703f639e5...",
                        "IsForeignKey": false
                    }
                ],
                "Row": {
                    "SessionType": "Rdp",
                    "LastState": "OK",
                    "Name": "simmy test",
                    "FQDN": "10.111.22.333",
                    "ID": "9ac809b...",
                    "Computer": "simmy test",
                    "Count": 2,
                    "EventID": "772a703f639e5...",
                    "HealthStatus": "OK",
                    "ComputerClass": "Windows"
                }
            },
            ...
        ],
        "ReturnID": ""
    },
    "Message": null,
    "MessageID": null,
    "Exception": null,
    "ErrorID": null,
    "ErrorCode": null,
    "InnerExceptions": null
}