Problem: Appliance CPE not listed for Tenant/ORG

How to:

    1. Check the Analytic Database for any Tenant ORG listed appliances 

    2. Verify the Site ID and other location parameters are correct in Analytics Database

    3. Correct the Site-ID or other location parameters 

Check Analytic Database for the Tenant/Org listed appliances.

    • Login to the Analytic Node Shell

    • Enter the database via cqlsh -u cassandra -p cassandra

    • Verify the site appliance in question is listed in the database for respective Tenant/ORG

SELECT * FROM van_analytics.tenants_info WHERE type='APPLIANCE' and tenant='Versa-LAB' ALLOW FILTERING ; 

Verify the Site-ID and other location parameters are correct.

    • Enter the database via cqlsh -u cassandra -p cassandra

    • Verify the Site-ID and other parameters for the site in question

SELECT * FROM van_analytics.sdwan_sites_info where tenant='Versa-LAB' and type='SITE' and site='Branch-1' ALLOW FILTERING ;

Correct the Site-ID and other parameters (if incorrect) in Analytics database

    • Verify the Site-ID of the appliance on the appliance itself 

show orgs org Versa-LAB sd-wan detail | match Site

    • If the Site-ID you verify is not the same in Analytics Database for the Tenant/ORG, correct it via VD in appliance context

        ○ Login to VD

        ○ Administration > Appliances > Select the Appliance > Configuration > Others > System > Configuration >             Identification 

        ○ To rectify the Site-ID or other location parameter inconsistency, toggle the value of Latitude to some other value, save it and then change it back to the original value. 

Now, verify the Site-ID and other location parameters for the appliance in Analytics Database by following Step 2. 

Once the values are correct, the site will be visible on UI

---------------------------------------------------------------------------------------------x