How to calculate IntegrationHub Usage per Flow?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-21-2025 06:10 PM
Hello Community,
We have been operating many Flows since the beginning of this year. While reviewing the IntegrationHub usage (ua_ih_usage) on a monthly basis, we noticed a sharp increase in user count starting in February 2025.
We were able to identify that the root cause was related to Flows being invoked through the "Update Record" action. However, we are unsure how to calculate the IntegrationHub usage per Flow.
Does a table exist where both the Flow SysID and its corresponding IntegrationHub usage are stored?
Any guidance or advice would be greatly appreciated.
Thank you in advance!
Best regards,
Kentaro
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-22-2025 04:09 AM
If you prefer a reportable artifact:
-
Create a DB View that joins:
-
ua_ih_usage.flow_action_execution → sys_flow_context_action.sys_id
-
sys_flow_context_action.flow_context → sys_flow_context.sys_id
-
sys_flow_context.definition → sys_flow.sys_id
-
-
Expose columns like: month, flow_sys_id, flow_name, action_name, count.
-
Build a Report or PA indicator grouping by Flow (and month).
If you found my response helpful, I would greatly appreciate it if you could mark it as "Accepted Solution" and "Helpful."
Your support not only benefits the community but also encourages me to continue assisting. Thank you so much!
Thanks and Regards
Ravi Gaurav | ServiceNow MVP 2025,2024 | ServiceNow Practice Lead | Solution Architect
CGI
M.Tech in Data Science & AI
YouTube: https://www.youtube.com/@learnservicenowwithravi
LinkedIn: https://www.linkedin.com/in/ravi-gaurav-a67542aa/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-22-2025 05:19 AM
Could you please share screenshots supporting your response?
How can we join on something which doesn't exist in the instance?
When I checked the table "ua_ih_usage", I couldn't find the field "flow_action_execution" which you have mentioned in your response.
Also are you sure this table exists OOTB "sys_flow_context_action"?
I couldn't find this as well in my instance.
It would be great if you could share the same so that it helps members.
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-25-2025 02:51 AM
Any thoughts for the above?
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-22-2025 05:09 AM - edited 08-22-2025 05:11 AM
no direct table is present which maps Flow SysId and Integration Hub usage count.
the table "ua_ih_usage" contains integration hub transactions.
Check this KB which explains it well
Understanding Integration Hub Usage Dashboard and Transaction Count
Check this link where similar discussion happened
About counting IntegrationHub Transactions
See in that table if you can find the flow or subflow/action
check below link as well
IntegrationHub Usage also counts integrations triggered by Flow Designer!
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader