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:

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:

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.