Differences

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

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

Sidebar

Internal Errigal Collaboration Wiki

Differences

Sidebar

Internal Errigal Collaboration Wiki

User Tools

Site Tools

Differences

Page Tools