You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to add a filter to restrict retrieved data by timestamp in REST API SystemLog template report

Question
21
Views
0
Comments

Summary:

For the REST API SystemLog report, what is the syntax to filter the data by a start and end date/timestamp? I tried different formats and none worked.

Content (please ensure you mask any confidential information):

Here's an example of a json record returned when running the SystemLog report:

{

  "outputFormat": "json",

  "status": "201",

  "totalResults": 11099,

  "startIndex": 1,

  "itemsPerPage": 48,

  "rows": [{

      "meterAsOPCService": false,

      "id": "xxxx",

      "schemas": ["urn:ietf:params:scim:schemas:oracle:idcs:AuditEvent"],

      "SystemLog_SsoBrowser": "",

      "SystemLog_EventId": "admin.user.update.success",

      "SystemLog_Timestamp": "2023-10-27T20:24:07.902Z",

      "SystemLog_SsoMatchedSignOnRule": "",

      "SystemLog_TargetName": "****",

      "SystemLog_EventDescription": "User update",

      "SystemLog_SsoPolicyObligation": "",

      "SystemLog_Ecid": "****",

      "SystemLog_ActorName": "idcsmessaging",

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!