get_servers_top_checkouts
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
}
Updated almost 5 years ago