Filter provisioning events based on access profile added from ServiceNow using SailPoint application for ServiceNow catalog

[kompala (Vidya Sagar Kompala)]

I am using the Sailpoint application for ServiceNow catalog and everything is working fine.

I am trying to create a report on the events that are added by ServiceNow catalog application.

After the request in ServiceNow is approved, ServiceNow calls the IDN API and adds the access profile for an identity. In that API call, it passes the RITM number and the comments requester has entered.

I am trying to extract this information and unable to frame the query to extract this information.

I would appreciate any help.

[mcheek (Mark Cheek)]

If you don’t already, I would suggest creating an Identity tied to ServiceNow. That way, you can utilize the requested-by query parameter in either the list-account-activities or access-request-status API endpoints

[kompala (Vidya Sagar Kompala)]

Thanks Mark for your response.

Is it possible to extract the data only by calling API ?
Can’t we get it directly from Admin UI ?

[mcheek (Mark Cheek)]

If I were writing a report in a BI tool, I would get all the records from the account activities API with the filtering that I mentioned, and then convert the JSON to a flat/tabular view.

That’s what I’ve done in this PowerBI report to get the “Request” column from the clientMetadata in the account activity