Devices.

View Specific Information

Required Scopes

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

Select

The driver 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 driver.

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