Excel Add-In for Okta

Build 24.0.9062

Devices

Devices.

View Specific Information

Required Scopes

To query this view, Scope must include okta.devices.read.

Select

The 本製品 uses the Okta API to process WHERE clause conditions built with the following columns and operators.
  • Id supports the '=' and 'LIKE (starts with)' operators
  • Status supports the '=' and 'LIKE (starts with)' operators
  • LastUpdated supports the '>', '>=', '=', '<=', and '<' operators
  • Name supports the '=' and 'LIKE (starts with)' operators
  • Platform supports the '=' and 'LIKE (starts with)' operators
  • Registered supports the '=' operator
  • Encryption supports the '=' and 'LIKE (starts with)' operators
  • Imei supports the '=' and 'LIKE (starts with)' operators
  • IntegrityJailbreak supports the '=' operator
  • Manufacturer supports the '=' and 'LIKE (starts with)' operators
  • Meid supports the '=' and 'LIKE (starts with)' operators
  • Model supports the '=' and 'LIKE (starts with)' operators
  • OsVersion supports the '=' and 'LIKE (starts with)' operators
  • SecureHardware supports the '=' operator
  • SerialNumber supports the '=' and 'LIKE (starts with)' operators
  • Sid supports the '=' and 'LIKE (starts with)' operators
  • TpmPublicKeyHash supports the '=' and 'LIKE (starts with)' operators
  • Udid supports the '=' and 'LIKE (starts with)' operators

All other filters are processed client-side within the 本製品.

For example, the following queries are processed server-side:

SELECT * FROM Devices WHERE Id = 'guoip3dpn2A6oGEqJ5d8'

SELECT * FROM Devices WHERE Id LIKE 'guoip3dpn2A6oGEqJ5d%'

Columns

Name Type Description
Id [KEY] String Id of the device
Status String Status of the device
Created Datetime When the item was created
LastUpdated Datetime When the item was last updated
Name String Display name of the device
Platform String OS platform of the device
Registered Boolean Whether the device is registered at Okta
Encryption String Type of encryption used on the device
Imei String International Mobile Equipment Identifier of the device
IntegrityJailbreak Boolean If the device is jailbroken or rooted
Manufacturer String Manufacturer of the device
Meid String Mobile Equipment Identifier of the device
Model String Model of the device
OsVersion String Version of the device OS
SecureHardware Boolean Whether the device has secure hardware functionality
SerialNumber String Serial Number of the device
Sid String Windows Security Identifier of the device
TpmPublicKeyHash String Windows Trusted Platform ModuleHash of the device
Udid String MacOS Unique Device Identifier of the device
ResourceId String Alternate key for the id
ResourceDisplayName String Display name of the device
ResourceDisplayNameSensitive Boolean Whether the display name of the device is sensitive
ResourceType String Resource Type
ResourceAlternateId String Resource Alternate Id

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062