=====MissingBillingTiers=====

**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:
<code>  SELECT id,date_added,name,ip_address,port,technology,tier_id 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.date_added > '2023-03-28 00:00:00';
        </code>

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

<code>
select * from billing_tiers
</code>

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.