Symptoms
As Provider I want to find customers' subscriptions with resource overusage through POA.
Resolution
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;