Differences

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

--- support:site_tracker [2021/11/02 10:21] – created 10.91.120.28
+++ support:site_tracker [2021/11/16 17:07] (current) – [Database Query Example] 10.91.120.28
@@ Line 1: / Line 1: @@
-EXTENET SITE TRACKER
+====== ExteNet Site Tracker ======
+==== Important Tips ====
+==== Database Query Example ====
+<code>
+SELECT
+    ne.id,
+    ne.name,
+    ne.jde_contract_id as 'Site Tracker Revenue Product Id',
+    ne.circuit_id,
+    stpc.identifier as 'Site Tracker Project Identifier',
+    stpc.id as 'Site Tracker Project Id',
+    stpc.name as 'Site Tracker Project Name',
+    stsc.identifier as 'Site Tracker Site Identifier',
+    stsc.name as 'Site Tracker Site Name',
+    stpc.identifier as 'Site Tracker Program Name',
+    stpc.name as 'Site Tracker Program Name',
+    stprc.market as 'Site Tracker Market',
+    stprc.region as 'Site Tracker Region'
+FROM
+    network_element ne
+        LEFT JOIN
+    snmp_manager.site_tracker_mapping stmc ON stmc.target_id = ne.id
+        AND stmc.target_class = ne.class
+        LEFT JOIN
+    snmp_manager.site_tracker_project stpc ON stpc.identifier = stmc.project_identifier
+        LEFT JOIN
+    snmp_manager.site_tracker_site stsc ON stsc.id = stpc.site_id
+        LEFT JOIN
+    snmp_manager.site_tracker_program stprc ON stprc.id = stpc.program_id
+WHERE
+    ne.parent_id = 281881 OR ne.id = 281881;
+</code>

Internal Errigal Collaboration Wiki