Level: Critical

Purpose: Notify Errigal Operations staff that a network element has been created which does not have a billing tier set.

Scenario: If there is no billing tier set this will cause issues with Billing at the end of the month.

Resolution: Run query to find elements affected and set the appropriate billing tier (You may have to inquire depending on the environment.)

Manual Action Steps: This query will find the element(s) in question:

  SELECT COUNT(*) AS count FROM network_element ne
        WHERE (ne.tier_id IS NULL
        OR ne.tier_id = '')
        AND ne.on_air
        AND ne.show_in_monitor
        AND ne_type != 'CUSTOMER-NETWORK'
        AND technology NOT IN ('NON_DAS', 'n/a')
        AND ne.parent_id != 3045 # orphan
        AND ne.date_added > '2023-03-28 00:00:00';
        

You can see what different billing tiers exist on the environment with this query

select * from billing_tiers

Then you need to run an update query and insert the relevant Tier id in the “tier_id” field of the network element.

Auto Clear: Will clear when network elements affected are assigned a billing tier.