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 11.1.2.3.0 and laterInformation in this document applies to any platform.
Goal
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:
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. |
Solution
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
| Goal |
| Solution |
| References |