AesixSeven Tech

 The following is an example of an Ericsson 4G LTE Query for finding the CQI=Carrier Quality Index from performance parameter pmRadioUeRepCqiDistr  by method of Weighted Average. SELECT Date_ID,HOUR_ID,ERBS,EUTRANCELLFDD, cast((SUM(A_0)+SUM(A_1)+SUM(A_2)+SUM(A_3)+SUM(A_4)+SUM(A_5)+SUM(A_6)+SUM(A_7)+SUM(A_8)+SUM(A_9)+SUM(A_10)+SUM(A_11)+SUM(A_12)+SUM(A_13)) as float) as TS,  cast((SUM(A_0) * 0.5) + (SUM(A_1) * 1) + (SUM(A_2) * 2) + (SUM(A_3) * 3) + (SUM(A_4) * 4) + (SUM(A_5) * 5) + (SUM(A_6) * 6) + (SUM(A_7) * 7) + (SUM(A_8) * 8) + (SUM(A_9) * 9+ (SUM(A_10) * 10) + (SUM(A_11) * 11) + (SUM(A_12) * 12) + (SUM(A_13) * 13)) as float) as Wgtd  ,cast((Wgtd/TS) as dec (19,3)) as Reported_CQI, SUM(A_0) as pm_0, SUM(A_1) as pm_1, SUM(A_2) as pm_2, SUM(A_3) as pm_3, SUM(A_4) as pm_4, SUM(A_5) as pm_5, SUM(A_6) as pm_6, SUM(A_7) as pm_7, SUM(A_8) as pm_8, SUM(A_9) as pm_9, SUM(A_10) as pm_10, SUM(A_11) as pm_11, SUM(A_12) as pm...

The following is an example of an Ericsson ENIQ SQL Query for finding the IUB Frame Loss Intensity by method of Weighted Average. SELECT Date_ID,Hour_ID,MIN_ID,RNC,RBS, SUM(A_0) as A_0,SUM(A_1) as A_1,SUM(A_2) as A_2,SUM(A_3) as A_3,SUM(A_4) as A_4,SUM(A_5) as A_5,SUM(A_6) as A_6,SUM(A_7) as A_7,SUM(A_8) as A_8,SUM(A_9) as A_9,SUM(A_10) as A_10,SUM(A_11) as A_11,SUM(A_12) as A_12,SUM(A_13) as A_13,SUM(A_14) as A_14,SUM(A_15) as A_15,(A_0 * 1) as B_0,(A_1 * 1.5) as B_1,(A_2 * 3.5) as B_2,(A_3 * 6.5) as B_3,(A_4 * 12.5) as B_4,(A_5 * 24.5) as B_5,(A_6 * 48.5) as B_6,(A_7 * 96.5) as B_7,(A_8 * 192.5) as B_8,(A_9 * 384.5) as B_9,(A_10 * 768.5) as B_10,(A_11 * 1536.5) as B_11,(A_12 * 3072.5) as B_12,(A_13 * 6144.5) as B_13,(A_14 * 12288.5) as B_14,(A_15 * 16385) as B_15, cast(100*((B_1+B_2+B_3+B_4+B_5+B_6+B_7+B_8+B_9+B_10+B_11+B_12+B_13+B_14+B_15)/(B_0+B_1+B_2+B_3+B_4+B_5+B_6+B_7+B_8+B_9+B_10+B_11+B_12+B_13+B_14+B_15)) as dec(19,5)) as C_1...

The following is an example of an Ericsson ENIQ SQL Query for finding the daily aggregated Power Average in Watts and dBm.   SELECT Date_ID,RNC,RBS,Sector,Carrier, cast((SUM(A_0)+SUM(A_1)+SUM(A_2)+SUM(A_3)+SUM(A_4)+SUM(A_5)+SUM(A_6)+SUM(A_7)+SUM(A_8)+SUM(A_9)+SUM(A_10)+SUM(A_11)+SUM(A_12)+SUM(A_13)+SUM(A_14)+SUM(A_15)+SUM(A_16)+SUM(A_17)+SUM(A_18)+SUM(A_19)+SUM(A_20)+SUM(A_21)+SUM(A_22)+SUM(A_23)+SUM(A_24)+SUM(A_25)+SUM(A_26)+SUM(A_27)+SUM(A_28)+SUM(A_29)+SUM(A_30)+SUM(A_31)+SUM(A_32)+SUM(A_33)+SUM(A_34)+SUM(A_35)+SUM(A_36)+SUM(A_37)+SUM(A_38)+SUM(A_39)+SUM(A_40)+SUM(A_41)+SUM(A_42)+SUM(A_43)+SUM(A_44)+SUM(A_45)+SUM(A_46)+SUM(A_47)+SUM(A_48)+SUM(A_49)+SUM(A_50)+SUM(A_51)) as float) as TS,  cast (((SUM(A_0) * 0) +(SUM(A_1) * 0.5) +(SUM(A_2) * 1.5) +(SUM(A_3) * 2.5) +(SUM(A_4) * 3.5) +(SUM(A_5) * 4.5) +(SUM(A_6) * 5.5) +(SUM(A_7) * 6.5) +(SUM(A_8) * 7.5) +(SUM(A_9) * 8.5) +(SUM(A_10) * 9.5) +(SUM(A_11) * 10.5) +(SUM(A_12) * 11.5) +(SUM(A_13) ...

Decimal Number To Hexadecimal Converter Tools This is the code calculator for the dashboard in Kilometres. The resulting code is one of the 5 codes that appear below. Please discuss in the comments column if there are difficulties. Edit EEPROM at spesific memory address acording to type of device, for example shown in picture below honda with EEPROM 93C76 Disclaimer : The use of this software is intended for repair purposes only or experimental, we are not responsible for the misuse of this software resulting in criminal acts according to applicable state laws. Thank you for reading. This tools maybe save your live, so please donate to support me through my paypal https://www.paypal.me/aesixnet Note Please enter a description USD Please enter a price Please enter an Invoice ID

  Tool Name : ExpOSS  Compliance : 3GPP 32.435 V10.0 & 32.401 V6.2  Application   : RNC, NodeB, EnodeB Table Of Contents 1. Goals 2. Ericsson 3G & 4G LTE Statsfile 3. Hardware & Operating System Platform 4. Installations, Operations & Maintenance 5. Support 1. Goals - Build alternative performance data collection system, as we know Ericsson has ENIQ. - Make everything simple, Build Light System in Inexpensive Hardware. - Source Codes are open for continuity in order to follow Ericsson system upgraded. - Target System Owner : Ericsson STS Provider. 2. Ericsson 3G & 4G LTE Statsfile - RNC : 3GPP 32.401 OSS RC dir : /var/opt/ericsson/nms_umts_wran_pms OSS ENM dir : /ericsson/pmic1 & /ericsson/pmic2 - RBS : 3GPP 32.435 & 32.401 ...