The Proxy table contains the connectors that the tenant can use or is currently running.

Column	Type	Description
ID	String	Proxy's `UUID` (primary key).
Ping	String	Whether the proxy is pingable; values are `Y` or `N`.
Online	Boolean	Whether the proxy is online.
LastPing	DateTime	Date/time of the last successful ping of the proxy.
MachineName	String	Machine name hosting the proxy.
LogRedirected	Boolean	Whether proxy logs are redirected.
Version	String	Proxy version.
LastPingAttempted	DateTime	Date/time the last ping of the proxy was attempted.
BandwidthKbps	Double	Bandwidth in kilobytes — includes the proxy and cloud.
Forest	String	Primary Active Directory forest of the proxy. Applicable only if proxy is connected to Active Directory.
IwaEnabled	Boolean	Whether Integrated Windows Authentication (IWA) is enabled on the proxy.
IwaHostname	String	Host for Integrated Windows Authentication (IWA).
IwaPort	Integer	Port for Integrated Windows Authentication (IWA).
IwaHttpPort	Integer	Http port for Integrated Windows Authentication (IWA).
AppGateway	Localized String	Status of the proxy's App Gateway plug-in.
ADProxy	Localized String	Status of the proxy's Active Directory plug-in.
LDAPProxy	Localized String	Status of the proxy's LDAP plug-in.
LDAPServiceInstances	Localized String	List of LDAP service instances of the proxy.

Example Query

The following query returns all of the entries in the Proxy table, ordered by Machine Name:

{
Script: "Select * from Proxy ORDER BY Machinename COLLATE NOCASE"
}

Proxy table query response:

...
"FullCount": 2,
"Results": [
  {
    "Entities": [
      {
        "Type": "Proxy",
        "Key": "********-****-****-****-************",
        "IsForeignKey": false
      }
    ],
    "Row": {
      "LastPing": "/Date(1444751500721)/",
      "IwaPort": 8443,
       "LastPingAttempted": "/Date(1444751500721)/",
      "ADProxy": "Enabled",
      "AppGateway": "Enabled",
      "AppGatewayDisplay": "Enabled",
      "MachineName": "Kibble-4",
      "LDAPServiceInstances": "",
      "Online": true,
      "Ping": "Y",
      "LDAPProxyDisplay": "Enabled",
      "_MatchFilter": null,
      "LogRedirected": null,
      "IwaEnabled": true,
      "IwaHostname": "Kibble-4",
      "Forest": "idaptive.app",
      "ADProxyDisplay": "Enabled",
      "Version": "15.9.172.0",
      "BandwidthKbps": 617.425384383479,
      "IwaHttpPort": 80,
       "CustomerName": "Cloud Service Portal For Idaptive Employees",
      "ID": "********-****-****-****-************",
       "LDAPProxy": "Enabled"
    }
  },
  {
     "Entities": [
      {
        "Type": "Proxy",
         "Key": "********-****-****-****-************",
        "IsForeignKey": false
      }
    ],
    "Row": {
       "LastPing": "/Date(1444751581309)/",
      "IwaPort": 8443,
      "LastPingAttempted": "/Date(1444751581309)/",
      "ADProxy": "Disabled",
      "AppGateway": "Enabled",
      "AppGatewayDisplay": "Enabled",
      "MachineName": "KIBBLE-AG-1",
      "LDAPServiceInstances": "",
      "Online": true,
      "Ping": "Y",
       "LDAPProxyDisplay": "Enabled",
      "_MatchFilter": null,
      "LogRedirected": null,
      "IwaEnabled": true,
      "IwaHostname": "KIBBLE-AG-1",
      "Forest": null,
      "ADProxyDisplay": "Disabled",
      "Version": "15.9.172.0",
      "BandwidthKbps": 974.7739171822941,
       "IwaHttpPort": 80,
      "CustomerName": "Cloud Service Portal For Idaptive Employees",
      "ID": "********-****-****-****-************",
      "LDAPProxy": "Enabled"
     }
  }
 
]