JDBC Driver for PingOne

Build 25.0.9434

Licenses

The licenses available in your organization.

View-Specific Information

We recommend using the built-in Organization Admin role to read data from this view.

SELECT

Reading data from this view requires Read License/licensing:read:license permission.

To execute SELECT statements on this view, the OrganizationId column must be specified in the criteria as shown in the examples below:

SELECT * FROM Information.Licenses WHERE OrganizationId IN ('c96005d1-3bc6-4ee9-972d-d15754de6aec', '4c5896b6-3452-4a90-982a-1fd7d5687dbc');
SELECT * FROM Information.Licenses WHERE OrganizationId = 'c96005d1-3bc6-4ee9-972d-d15754de6aec' AND Id = 'f0eeeeb2-ff36-4af3-8561-183dc4f23cb6'

The driver uses the PingOne Platform API to process WHERE clause conditions built with the following columns and operators.

  • OrganizationId supports the following operators: =, IN.
  • Id supports the following operators: =.

All other filters are processed client-side within the driver.

Columns

Name Type References Description
Id [KEY] String The license identifier (UUID).
Name String The name of the license.
Status String The status of the license. Possible values are: 'ACTIVE', 'EXPIRED', and 'FUTURE'.
Package String A string that specifies the license template on which the license is based. Possible values are: 'TRIAL', 'STANDARD', 'PREMIUM', 'MFA', 'RISK', 'MFARISK', and 'GLOBAL'.
EnvironmentsAssignedCount Integer The total number of environments within the organization to which this license has been assigned.
BeginsAt Datetime The time when this license begins.
ExpiresAt Datetime The time when the license expires.
TerminatesAt Datetime The time when the license terminates, blocking access to all PingOne services in your organization.
OrganizationId String Information.Organizations.Id The identifier (UUID) of the organization in which the environment exists.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434