1. Working with EPM Automate for Oracle Enterprise Performance Management Cloud
  2. Command Reference
  3. EPM Automate Commands
  4. invalidLoginReport

invalidLoginReport

In OCI (Gen 2) environments, creates the Invalid Login Report, which lists the failed attempts to sign into the environment over a specified period of time corresponding to the audit retention period specified for your environment. The default retention period is 30 days. You can extend it to a maximum of 90 days by changing the Audit Retention Period (days) setting in the Oracle Cloud Identity Console. To retain the audit data for duration longer than 90 days, periodically download and archive this report and the Role Assignment Audit Report.

The Invalid Login Report contains information such as the following:

  • User name of the user who attempted to sign in
  • Remote IP address from which the user attempted to sign in
  • Timestamp of the sign in attempt

This report shows all the unsuccessful login attempts to the corresponding Identity Cloud Service. These may not all be related to one Oracle Enterprise Performance Management Cloud instance.
Sample Invalid Login report

Use the downloadFile command to download the report to a local computer.

Applies to

Planning, Planning Modules, FreeForm, Financial Consolidation and Close, Tax Reporting, Account Reconciliation, Profitability and Cost Management, Enterprise Profitability and Cost Management, Oracle Enterprise Data Management Cloud, Narrative Reporting, Strategic Workforce Planning, and Sales Planning.

Required Roles

Identity Domain Administrator and any predefined role (Service Administrator, Power User, User, or Viewer)

Usage

epmAutomate invalidLoginReport FROM_DATE TO_DATE FILE_NAME.CSV where:

  • FROM_DATE indicates the start date (in YYYY-MM-DD format) of the period for which the report is to be generated. This date must fall within the audit data retention period specified in the Oracle Cloud Identity Console.
  • TO_DATE indicates the end date (in YYYY-MM-DD format) of the period for which the report is to be generated.
  • FILE_NAME is the name of a CSV file for the report.

Note:

This report can be generated only for the last 90 days.

Example

epmAutomate invalidLoginReport 2021-06-01 2021-06-30 invalidLoginReport.CSV