Search Engine: Elastic

Article ID: 117994, created on Oct 16, 2013, last review on May 10, 2014

  • Applies to:
  • Operations Automation


As Provider I want to find customers' subscriptions with resource overusage through POA.


In the current version of POA it is not possible to get the list of subscription with resource overusage through the Provider Control Panel, such information may be fetched from the POA database only.

Use the following database query to get the the list of subscriptions as well as the resources that are used over the limit:

SELECT sr.sub_id AS subscription_ID, sr.rt_id AS resource_ID, rt.restype_name, sr.curr_usage AS current_usage, sr.sub_limit AS usage_limit FROM subs_resources sr JOIN resource_types rt ON sr.rt_id = rt.rt_id WHERE (sr.curr_usage > sr.sub_limit) AND sr.sub_limit != -1;

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF