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

**URL:** <https://developer.sailpoint.com/discuss/t/filter-provisioning-events-based-on-access-profile-added-from-servicenow-using-sailpoint-application-for-servicenow-catalog/34763>\
**Category:** SHF Discussion and Questions\
**Tags:** identity-security-cloud, provisioning\
**Created:** [March 11, 2024, 1:47pm UTC](https://developer.sailpoint.com/discuss/t/filter-provisioning-events-based-on-access-profile-added-from-servicenow-using-sailpoint-application-for-servicenow-catalog/34763 "2024-03-11T13:47:38Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![kompala](https://avatars.discourse-cdn.com/v4/letter/k/ea5d25/32.png) [@kompala](https://developer.sailpoint.com/discuss/u/kompala)\
**Post date:** [March 11, 2024, 1:47pm UTC](https://developer.sailpoint.com/discuss/t/filter-provisioning-events-based-on-access-profile-added-from-servicenow-using-sailpoint-application-for-servicenow-catalog/34763/1 "2024-03-11T13:47:38Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![mcheek](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/mcheek/32/23705_2.png) [@mcheek](https://developer.sailpoint.com/discuss/u/mcheek)\
**Post date:** [March 11, 2024, 3:14pm UTC](https://developer.sailpoint.com/discuss/t/filter-provisioning-events-based-on-access-profile-added-from-servicenow-using-sailpoint-application-for-servicenow-catalog/34763/2 "2024-03-11T15:14:06Z")

</div>

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](https://developer.sailpoint.com/docs/api/v3/list-account-activities) or [access-request-status](https://developer.sailpoint.com/docs/api/v3/list-access-request-status) API endpoints

---

<div class="post-metadata">

**Author:** ![kompala](https://avatars.discourse-cdn.com/v4/letter/k/ea5d25/32.png) [@kompala](https://developer.sailpoint.com/discuss/u/kompala)\
**Post date:** [March 11, 2024, 4:14pm UTC](https://developer.sailpoint.com/discuss/t/filter-provisioning-events-based-on-access-profile-added-from-servicenow-using-sailpoint-application-for-servicenow-catalog/34763/3 "2024-03-11T16:14:54Z")

</div>

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 ?

---

<div class="post-metadata">

**Author:** ![mcheek](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/mcheek/32/23705_2.png) [@mcheek](https://developer.sailpoint.com/discuss/u/mcheek)\
**Post date:** [March 11, 2024, 5:18pm UTC](https://developer.sailpoint.com/discuss/t/filter-provisioning-events-based-on-access-profile-added-from-servicenow-using-sailpoint-application-for-servicenow-catalog/34763/4 "2024-03-11T17:18:33Z")

</div>

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

 ![image](https://global.discourse-cdn.com/sailpoint/original/2X/8/864cebafc9702b856509f1f99c061e362c8854cc.png)

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\
**Post date:** [May 18, 2024, 1:56pm UTC](https://developer.sailpoint.com/discuss/t/filter-provisioning-events-based-on-access-profile-added-from-servicenow-using-sailpoint-application-for-servicenow-catalog/34763/6 "2024-05-18T13:56:20Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.