Generate reports on managed data

To generate a report on managed data, run a filtered query on the report/managed endpoint. These reports enable data analysis on areas such as:

Number of active managed users
Number of self-registered managed users
Number of enabled roles

The following example generates a report on the number of managed users born in the year 1999 and aggregates those users by birth month:

curl \
--header "X-OpenIDM-Username: openidm-admin" \
--header "X-OpenIDM-Password: openidm-admin" \
--header "Accept-API-Version: resource=1.0" \
--request GET \
'http://localhost:8080/openidm/report/managed/user?_queryFilter=/birthdate+gt+"1998-12-31T23:59:59.999Z"and/birthdate+lt+"2000-01-01T00:00:00.000Z"&aggregateFields=TIMESTAMP=/birthdate;scale:month;utcOffset:-0700'
{
  "result": [
    {
      "birthdate": {
        "epochSeconds": 933490800,
        "iso8601": "1999-08-01T00:00:00.0-0700"
      },
      "count": 8
    },
    {
      "birthdate": {
        "epochSeconds": 915174000,
        "iso8601": "1999-01-01T00:00:00.0-0700"
      },
      "count": 8
    },
    {
      "birthdate": {
        "epochSeconds": 917852400,
        "iso8601": "1999-02-01T00:00:00.0-0700"
      },
      "count": 10
    },
    {
      "birthdate": {
        "epochSeconds": 920271600,
        "iso8601": "1999-03-01T00:00:00.0-0700"
      },
      "count": 6
    },
    {
      "birthdate": {
        "epochSeconds": 928220400,
        "iso8601": "1999-06-01T00:00:00.0-0700"
      },
      "count": 10
    },
    {
      "birthdate": {
        "epochSeconds": 930812400,
        "iso8601": "1999-07-01T00:00:00.0-0700"
      },
      "count": 6
    },
    {
      "birthdate": {
        "epochSeconds": 936169200,
        "iso8601": "1999-09-01T00:00:00.0-0700"
      },
      "count": 7
    },
    {
      "birthdate": {
        "epochSeconds": 922950000,
        "iso8601": "1999-04-01T00:00:00.0-0700"
      },
      "count": 5
    },
    {
      "birthdate": {
        "epochSeconds": 925542000,
        "iso8601": "1999-05-01T00:00:00.0-0700"
      },
      "count": 3
    }
  ],
  "resultCount": 9,
  "pagedResultsCookie": null,
  "totalPagedResultsPolicy": "NONE",
  "totalPagedResults": -1,
  "remainingPagedResults": -1
}

The admin UI provides a number of count widgets that generate reports on the following managed data:

Number of active users (users whose account status is active
Number of enabled social providers
Number of enabled roles
Number of configured connectors
Number of manual user registrations

The count widgets are provided by default on the Resource Report and Business Report dashboards. Select Dashboards > Resource Report or Dashboards > Business Report to use these widgets, or add them to any other dashboard.

IDM 7.2.1

Generate reports on managed data