Differences

This shows you the differences between two versions of the page.

--- resolution_area:prometheus_resolutions:res-p9127 [2023/03/28 11:35] – 10.91.110.100
+++ resolution_area:prometheus_resolutions:res-p9127 [2023/04/27 09:59] (current) – 10.91.110.100
@@ Line 13: / Line 13: @@
 **Manual Action Steps:**
 This query will find the element(s) in question:
-<code>  SELECT COUNT(*) AS count FROM network_element ne
+<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 = '')
@@ Line 20: / Line 20: @@
         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';
         </code>
@@ Line 29: / Line 28: @@
 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.

Internal Errigal Collaboration Wiki