My Oracle Support Banner

How To Find OAAM Devices That Have Been Used In The Last 30 Days (Doc ID 2703060.1)

Last updated on MAY 03, 2023

Applies to:

Oracle Adaptive Access Manager - Version and later
Information in this document applies to any platform.


How to find the registered devices you can use note : How To Find Registered Device for User In OAAM? (Doc ID 2503098.1)

The OAAM schema describes the creation date of the device and whether or not the user has marked it as a safe device.

The OAAM Schema Map is in the documentation:

Fusion Middleware Schema Reference for Oracle Adaptive Access Manager
Oracle Adaptive Access Manager Database Schema
1.2.73 VTUserDeviceMap
Description: This maintains the list of devices the user is using
Database table name: VT_USER_DEVICE_MAP
Primary Keys: mapId (MAP_ID)
(Please consult document link for full map)

The column IS_SECURE in table VT_USER_DEVICE_MAP which holds value 1 or 0. The value 1 means device is marked safely and otherwise it will be  0.

In your custom code the logic could leverage...these following data points to drive whether or not the safe device has been used or was created ( re-registered) 30 days ago.


Name Column Name Description
lastUsedTime LAST_USED_TIME Last used time for this device.
createTime CREATE_TIME Date/time when this object was created.
updateTime UPDATE_TIME Last update time for this object.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.