Help with Reporting

[danieljackson]

Hello all,

I’m looking to create some reports to extract the following information
Role & criteria attached to the role
Entitlement & Identities that have the specific entitlement

I am attempting to pull this information using the API, but cannot find how to do so - any pointers would be appreciated.

Thanks, Daniel.

[filip_johansson]

Hello @danieljackson,

To my knowledge, the Role membership criteria is not attainable through Search unfortunately. It is however attainble through the API on /roles/{roleid} (List Roles)

For the entitlements and identities, you can use the “Perform Search” API in the V3 collection (Perform Search)

Depending on the form you want it in, you could try something like:

{
  "indices": [
    "entitlements"
  ],
  "query": {
    "query": "*"
  }
}

to find all entitlements, and then:

{
  "indices": [
    "identities"
  ],
  "query": {
    "query": "@access(type:ENTITLEMENT AND id:<technical id of the entitlement>)"
  }
}

to find the identites whom pocess the entitlement with a specific entitlement id.

For full reference on what to query depending on what you’re looking for, see Searchable Fields