Internal Errigal Collaboration Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== 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>

Sidebar

Internal Errigal Collaboration Wiki

User Tools

Site Tools

Page Tools