How to calculate IntegrationHub Usage per Flow?

Kentaro Numata
Tera Guru

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

7 REPLIES 7

Ravi Gaurav
Giga Sage
Giga Sage

Hi @Kentaro Numata 

If you prefer a reportable artifact:

  1. 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

  2. Expose columns like: month, flow_sys_id, flow_name, action_name, count.

  3. 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/

@Ravi Gaurav 

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.

AnkurBawiskar_4-1755865131607.png

 

Also are you sure this table exists OOTB "sys_flow_context_action"?

I couldn't find this as well in my instance.

AnkurBawiskar_3-1755865096967.png

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.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@Ravi Gaurav 

Any thoughts for the above?

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Ankur Bawiskar
Tera Patron
Tera Patron

@Kentaro Numata 

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.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader