Differences

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

--- resolution_area:prometheus_resolutions:res-p9127 [2023/04/27 09:58] – 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 id,date_added,name,ip_address,port,technology 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>

Internal Errigal Collaboration Wiki