In Subscription management the Intregration Hub Stater is showin Overallocated

NeethuB
Tera Contributor

In Subscription management the Intregration Hub Stater is showin Overallocated.
i want to know which one is using most . But i can't find any useful table where i can find which one is using the  integration Hub starter the most

4 REPLIES 4

pr8172510
Mega Guru

Hi Neethu,

This is a common challenge with IntegrationHub usage — the ā€œOverallocatedā€ status doesn’t directly tell you what is consuming the transactions.

How IntegrationHub usage works

IntegrationHub Starter is consumed based on:

  • Flow Designer executions
  • Spoke actions (REST, SOAP, etc.)
  • Subflows / Actions

But unfortunately, there is no single OOTB table that shows ā€œtop consumersā€ directly.


How to identify what’s using it

1. Check Flow executions

Go to:

  • Flow Designer → Executions (sys_flow_context)

Here you can:

  • See which flows are running most frequently
  • Identify high-volume flows

2. Check Action / Step usage

Table:

  • sys_flow_log
  • sys_flow_step_execution

These help you see:

  • Which actions (especially IntegrationHub spokes) are being executed
  • Frequency of usage

3. Look for IntegrationHub-specific usage

Check:

  • sys_hub_flow_context (if available in your version)

This can give more insight into hub-related executions.


4. Analytics (best approach)

Create a quick report on:

  • Flow executions by Flow name
  • Filter on flows using IntegrationHub actions

This helps you identify:

  • ā€œTop consumersā€ by volume

5. Common causes of overallocation

Usually it’s:

  • Scheduled flows running too frequently
  • Loops inside flows calling actions multiple times
  • High-volume integrations (REST calls, etc.)

Important point

Subscription Management shows aggregate usage only — it does not break it down per flow/action, so some investigation is always needed.

Hi @pr8172510 

Your statement is quite misleading - there is no single OOTB table that shows ā€œtop consumersā€ directly.

There's an OOB table called ua_ih_usage where you can see the actual usage.

Regards,

Siva

Uday Damaraju
Kilo Guru

Hi @NeethuB -
Generally iHub subscription is #of transactions game, can you check and confirm you see overallocated for transactions or other metric type(role)? 
For transactions, to get to the granular data , you need to look at the execution engine (Usage Dashboard), not just the Subscription Management info.

 "Hope it helps, if so please accept the solution and mark it helpful as needed"
You may share a screenshot of what you see for better answers. šŸ˜‰

BR, UD

J Siva
Kilo Patron

Hi @NeethuB 
You can find the usgae data by using the following links

1. Cumulative usage over the last 12 months

https://<instance-id>/usageanalytics_count_list.do?sysparm_list_header_search=true&sysparm_choice_query_raw=&sysparm_view=&sysparm_first_row=1&sysparm_query=definition_idSTARTSWITHLICMCUIntegrationHubPool&sysparm_clear_stack=true

 

2. Usage count for each month

https://<instance-id>/usageanalytics_count_list.do?sysparm_list_header_search=true&sysparm_choice_query_raw=&sysparm_view=&sysparm_first_row=1&sysparm_query=definition_idSTARTSWITHLICIHMIntegrationHubPool&sysparm_nostack=true&sysparm_clear_stack=true

 

3. IntegrationHub usage detailed view

https://<instance-id>/ua_ih_usage_list.do?sysparm_list_header_search=true&sysparm_choice_query_raw=&sysparm_view=&sysparm_first_row=1&sysparm_query=license_idSTARTSWITHIntegrationHubPool&sysparm_clear_stack=true

 

Regards,
Siva