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"
     }
  }
 
]