Notes

Notes - notes.io

try {
let sql = `SELECT "Alert Date", y."eNodeB Id", "Alert Id", "Abnormal KPI", "KPI Value", "KPI Mean", ROUND(("KPI Value" * 100),2) as Improvement
from
(SELECT * from
(SELECT CASE
WHEN changerate_bearer_drop_rate < -0.1 THEN 'Bearer Drop Rate' END AS "Abnormal KPI",
"day" as "Alert Date",
Lpad(Cast(enodeb AS CHAR(50)), 6, '0') as "eNodeB Id",
alert_id as "Alert Id",
ROUND(Cast(changerate_bearer_drop_rate as DOUBLE),4) as "KPI Value"
FROM "snap_data_post_event"
WHERE "day" = '${date}'
AND Lpad(Cast(enodeb AS CHAR(50)), 6, '0') = '${enodebID}'
) WHERE "Abnormal KPI" <> '') as y
INNER JOIN
(SELECT
Lpad(Cast(enodeb AS CHAR(50)), 6, '0') as "eNodeB Id",
ROUND(AVG(CAST(changerate_bearer_drop_rate as DOUBLE)),4) as "KPI Mean"
FROM "snap_data_post_event"
WHERE enodeb = '${enodebID}'
AND CAST("day" AS Date) BETWEEN CAST('${date}' AS Date) - INTERVAL '14' DAY AND CAST('${date}' AS Date)
GROUP BY enodeb) as x
on y."eNodeB Id" = x."eNodeB Id"
UNION ALL
SELECT "Alert Date", y."eNodeB Id", "Alert Id", "Abnormal KPI", "KPI Value", "KPI Mean", ROUND(("KPI Value" * 100),2) as Improvement
from
(SELECT * from
(SELECT CASE
WHEN changerate_avgconnected_users < -0.1 THEN 'Avgconnected Users' END AS "Abnormal KPI",
"day" as "Alert Date",
Lpad(Cast(enodeb AS CHAR(50)), 6, '0') as "eNodeB Id",
alert_id as "Alert Id",
ROUND(Cast(changerate_avgconnected_users as DOUBLE),4) as "KPI Value"
FROM "snap_data_post_event"
WHERE "day" = '${date}'
AND Lpad(Cast(enodeb AS CHAR(50)), 6, '0') = '${enodebID}'
) WHERE "Abnormal KPI" <> '') as y
INNER JOIN
(SELECT
Lpad(Cast(enodeb AS CHAR(50)), 6, '0') as "eNodeB Id",
ROUND(AVG(CAST(changerate_avgconnected_users as DOUBLE)),4) as "KPI Mean"
FROM "snap_data_post_event"
WHERE enodeb = '${enodebID}'
AND CAST("day" AS Date) BETWEEN CAST('${date}' AS Date) - INTERVAL '14' DAY AND CAST('${date}' AS Date)
GROUP BY enodeb) as x
on y."eNodeB Id" = x."eNodeB Id"
UNION ALL
SELECT "Alert Date", y."eNodeB Id", "Alert Id", "Abnormal KPI", "KPI Value", "KPI Mean", ROUND(("KPI Value" * 100),2) as Improvement
from
(SELECT * from
(SELECT CASE
WHEN changerate_bearer_drop_voice_rate < -0.1 THEN 'Bearer Drop Voice Rate' END AS "Abnormal KPI",
"day" as "Alert Date",
Lpad(Cast(enodeb AS CHAR(50)), 6, '0') as "eNodeB Id",
alert_id as "Alert Id",
ROUND(Cast(changerate_bearer_drop_voice_rate as DOUBLE),4) as "KPI Value"
FROM "snap_data_post_event"
WHERE "day" = '${date}'
AND Lpad(Cast(enodeb AS CHAR(50)), 6, '0') = '${enodebID}'
) WHERE "Abnormal KPI" <> '') as y
INNER JOIN
(SELECT
Lpad(Cast(enodeb AS CHAR(50)), 6, '0') as "eNodeB Id",
ROUND(AVG(CAST(changerate_bearer_drop_voice_rate as DOUBLE)),4) as "KPI Mean"
FROM "snap_data_post_event"
WHERE enodeb = '${enodebID}'
AND CAST("day" AS Date) BETWEEN CAST('${date}' AS Date) - INTERVAL '14' DAY AND CAST('${date}' AS Date)
GROUP BY enodeb) as x
on y."eNodeB Id" = x."eNodeB Id"
UNION ALL
SELECT "Alert Date", y."eNodeB Id", "Alert Id", "Abnormal KPI", "KPI Value", "KPI Mean", ROUND(("KPI Value" * 100),2) as Improvement
from
(SELECT * from
(SELECT CASE
WHEN changerate_dl_data_volume < -0.1 THEN 'Dl Data Volume' END AS "Abnormal KPI",
"day" as "Alert Date",
Lpad(Cast(enodeb AS CHAR(50)), 6, '0') as "eNodeB Id",
alert_id as "Alert Id",
ROUND(Cast(changerate_dl_data_volume as DOUBLE),4) as "KPI Value"
FROM "snap_data_post_event"
WHERE "day" = '${date}'
AND Lpad(Cast(enodeb AS CHAR(50)), 6, '0') = '${enodebID}'
) WHERE "Abnormal KPI" <> '') as y
INNER JOIN
(SELECT
Lpad(Cast(enodeb AS CHAR(50)), 6, '0') as "eNodeB Id",
ROUND(AVG(CAST(changerate_dl_data_volume as DOUBLE)),4) as "KPI Mean"
FROM "snap_data_post_event"
WHERE enodeb = '${enodebID}'
AND CAST("day" AS Date) BETWEEN CAST('${date}' AS Date) - INTERVAL '14' DAY AND CAST('${date}' AS Date)
GROUP BY enodeb) as x
on y."eNodeB Id" = x."eNodeB Id"
UNION ALL
SELECT "Alert Date", y."eNodeB Id", "Alert Id", "Abnormal KPI", "KPI Value", "KPI Mean", ROUND(("KPI Value" * 100),2) as Improvement
from
(SELECT * from
(SELECT CASE
WHEN changerate_uptp_user_perceived_throughput < -0.1 THEN 'Uptp User Perceived Throughput' END AS "Abnormal KPI",
"day" as "Alert Date",
Lpad(Cast(enodeb AS CHAR(50)), 6, '0') as "eNodeB Id",
alert_id as "Alert Id",
ROUND(Cast(changerate_uptp_user_perceived_throughput as DOUBLE),4) as "KPI Value"
FROM "snap_data_post_event"
WHERE "day" = '${date}'
AND Lpad(Cast(enodeb AS CHAR(50)), 6, '0') = '${enodebID}'
) WHERE "Abnormal KPI" <> '') as y
INNER JOIN
(SELECT
Lpad(Cast(enodeb AS CHAR(50)), 6, '0') as "eNodeB Id",
ROUND(AVG(CAST(changerate_uptp_user_perceived_throughput as DOUBLE)),4) as "KPI Mean"
FROM "snap_data_post_event"
WHERE enodeb = '${enodebID}'
AND CAST("day" AS Date) BETWEEN CAST('${date}' AS Date) - INTERVAL '14' DAY AND CAST('${date}' AS Date)
GROUP BY enodeb) as x
on y."eNodeB Id" = x."eNodeB Id"
UNION ALL
SELECT "Alert Date", y."eNodeB Id", "Alert Id", "Abnormal KPI", "KPI Value", "KPI Mean", ROUND(("KPI Value" * 100),2) as Improvement
from
(SELECT * from
(SELECT CASE
WHEN changerate_bearer_setup_failure_rate < -0.1 THEN 'Bearer Setup Failure Rate' END AS "Abnormal KPI",
"day" as "Alert Date",
Lpad(Cast(enodeb AS CHAR(50)), 6, '0') as "eNodeB Id",
alert_id as "Alert Id",
ROUND(Cast(changerate_bearer_setup_failure_rate as DOUBLE),4) as "KPI Value"
FROM "snap_data_post_event"
WHERE "day" = '${date}'
AND Lpad(Cast(enodeb AS CHAR(50)), 6, '0') = '${enodebID}'
) WHERE "Abnormal KPI" <> '') as y
INNER JOIN
(SELECT
Lpad(Cast(enodeb AS CHAR(50)), 6, '0') as "eNodeB Id",
ROUND(AVG(CAST(changerate_bearer_setup_failure_rate as DOUBLE)),4) as "KPI Mean"
FROM "snap_data_post_event"
WHERE enodeb = '${enodebID}'
AND CAST("day" AS Date) BETWEEN CAST('${date}' AS Date) - INTERVAL '14' DAY AND CAST('${date}' AS Date)
GROUP BY enodeb) as x
on y."eNodeB Id" = x."eNodeB Id"
UNION ALL
SELECT "Alert Date", y."eNodeB Id", "Alert Id", "Abnormal KPI", "KPI Value", "KPI Mean", ROUND(("KPI Value" * 100),2) as Improvement
from
(SELECT * from
(SELECT CASE
WHEN changerate_sip_dc_rate < -0.1 THEN 'Sip Dc Rate' END AS "Abnormal KPI",
"day" as "Alert Date",
Lpad(Cast(enodeb AS CHAR(50)), 6, '0') as "eNodeB Id",
alert_id as "Alert Id",
ROUND(Cast(changerate_sip_dc_rate as DOUBLE),4) as "KPI Value"
FROM "snap_data_post_event"
WHERE "day" = '${date}'
AND Lpad(Cast(enodeb AS CHAR(50)), 6, '0') = '${enodebID}'
) WHERE "Abnormal KPI" <> '') as y
INNER JOIN
(SELECT
Lpad(Cast(enodeb AS CHAR(50)), 6, '0') as "eNodeB Id",
ROUND(AVG(CAST(changerate_sip_dc_rate as DOUBLE)),4) as "KPI Mean"
FROM "snap_data_post_event"
WHERE enodeb = '${enodebID}'
AND CAST("day" AS Date) BETWEEN CAST('${date}' AS Date) - INTERVAL '14' DAY AND CAST('${date}' AS Date)
GROUP BY enodeb) as x
on y."eNodeB Id" = x."eNodeB Id"
UNION ALL
SELECT "Alert Date", y."eNodeB Id", "Alert Id", "Abnormal KPI", "KPI Value", "KPI Mean", ROUND(("KPI Value" * 100),2) as Improvement
from
(SELECT * from
(SELECT CASE
WHEN changerate_packet_retransmission_rate < -0.1 THEN 'Packet Retransmission Rate' END AS "Abnormal KPI",
"day" as "Alert Date",
Lpad(Cast(enodeb AS CHAR(50)), 6, '0') as "eNodeB Id",
alert_id as "Alert Id",
ROUND(Cast(changerate_packet_retransmission_rate as DOUBLE),4) as "KPI Value"
FROM "snap_data_post_event"
WHERE "day" = '${date}'
AND Lpad(Cast(enodeb AS CHAR(50)), 6, '0') = '${enodebID}'
) WHERE "Abnormal KPI" <> '') as y
INNER JOIN
(SELECT
Lpad(Cast(enodeb AS CHAR(50)), 6, '0') as "eNodeB Id",
ROUND(AVG(CAST(changerate_packet_retransmission_rate as DOUBLE)),4) as "KPI Mean"
FROM "snap_data_post_event"
WHERE enodeb = '${enodebID}'
AND CAST("day" AS Date) BETWEEN CAST('${date}' AS Date) - INTERVAL '14' DAY AND CAST('${date}' AS Date)
GROUP BY enodeb) as x
on y."eNodeB Id" = x."eNodeB Id"
UNION ALL
SELECT "Alert Date", y."eNodeB Id", "Alert Id", "Abnormal KPI", "KPI Value", "KPI Mean", ROUND(("KPI Value" * 100),2) as Improvement
from
(SELECT * from
(SELECT CASE
WHEN changerate_packet_loss_rate < -0.1 THEN 'packet_loss_rat' END AS "Abnormal KPI",
"day" as "Alert Date",
Lpad(Cast(enodeb AS CHAR(50)), 6, '0') as "eNodeB Id",
alert_id as "Alert Id",
ROUND(Cast(changerate_packet_loss_rate as DOUBLE),4) as "KPI Value"
FROM "snap_data_post_event"
WHERE "day" = '${date}'
AND Lpad(Cast(enodeb AS CHAR(50)), 6, '0') = '${enodebID}'
) WHERE "Abnormal KPI" <> '') as y
INNER JOIN
(SELECT
Lpad(Cast(enodeb AS CHAR(50)), 6, '0') as "eNodeB Id",
ROUND(AVG(CAST(changerate_packet_loss_rate as DOUBLE)),4) as "KPI Mean"
FROM "snap_data_post_event"
WHERE enodeb = '${enodebID}'
AND CAST("day" AS Date) BETWEEN CAST('${date}' AS Date) - INTERVAL '14' DAY AND CAST('${date}' AS Date)
GROUP BY enodeb) as x
on y."eNodeB Id" = x."eNodeB Id"
UNION ALL
SELECT "Alert Date", y."eNodeB Id", "Alert Id", "Abnormal KPI", "KPI Value", "KPI Mean", ROUND(("KPI Value" * 100),2) as Improvement
from
(SELECT * from
(SELECT CASE
WHEN changerate_radio_signal_freq_rate < -0.1 THEN 'Radio Signal Freq Rate' END AS "Abnormal KPI",
"day" as "Alert Date",
Lpad(Cast(enodeb AS CHAR(50)), 6, '0') as "eNodeB Id",
alert_id as "Alert Id",
ROUND(Cast(changerate_radio_signal_freq_rate as DOUBLE),4) as "KPI Value"
FROM "snap_data_post_event"
WHERE "day" = '${date}'
AND Lpad(Cast(enodeb AS CHAR(50)), 6, '0') = '${enodebID}'
) WHERE "Abnormal KPI" <> '') as y
INNER JOIN
(SELECT
Lpad(Cast(enodeb AS CHAR(50)), 6, '0') as "eNodeB Id",
ROUND(AVG(CAST(changerate_radio_signal_freq_rate as DOUBLE)),4) as "KPI Mean"
FROM "snap_data_post_event"
WHERE enodeb = '${enodebID}'
AND CAST("day" AS Date) BETWEEN CAST('${date}' AS Date) - INTERVAL '14' DAY AND CAST('${date}' AS Date)
GROUP BY enodeb) as x
on y."eNodeB Id" = x."eNodeB Id"
UNION ALL
SELECT "Alert Date", y."eNodeB Id", "Alert Id", "Abnormal KPI", "KPI Value", "KPI Mean", ROUND(("KPI Value" * 100),2) as Improvement
from
(SELECT * from
(SELECT CASE
WHEN changerate_context_drop_rate < -0.1 THEN 'Context Drop Rate' END AS "Abnormal KPI",
"day" as "Alert Date",
Lpad(Cast(enodeb AS CHAR(50)), 6, '0') as "eNodeB Id",
alert_id as "Alert Id",
ROUND(Cast(changerate_context_drop_rate as DOUBLE),4) as "KPI Value"
FROM "snap_data_post_event"
WHERE "day" = '${date}'
AND Lpad(Cast(enodeb AS CHAR(50)), 6, '0') = '${enodebID}'
) WHERE "Abnormal KPI" <> '') as y
INNER JOIN
(SELECT
Lpad(Cast(enodeb AS CHAR(50)), 6, '0') as "eNodeB Id",
ROUND(AVG(CAST(changerate_context_drop_rate as DOUBLE)),4) as "KPI Mean"
FROM "snap_data_post_event"
WHERE enodeb = '${enodebID}'
AND CAST("day" AS Date) BETWEEN CAST('${date}' AS Date) - INTERVAL '14' DAY AND CAST('${date}' AS Date)
GROUP BY enodeb) as x
on y."eNodeB Id" = x."eNodeB Id"`;
tableData = await dbUtils.getObjectsFromDBAsync(sql);
console.log(sql)
}

Notes.io is a web-based application for taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000 notes created and continuing...

With notes.io;

* You can take a note from anywhere and any device with internet connection.
* You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
* You can quickly share your contents without website, blog and e-mail.
* You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
* Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.

Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.

Easy: Notes.io doesn’t require installation. Just write and share note!

Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )

Free: Notes.io works for 12 years and has been free since the day it was started.

You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;

Email: [email protected]

Twitter: http://twitter.com/notesio

Instagram: http://instagram.com/notes.io

Facebook: http://facebook.com/notesio

Regards;
Notes.io Team

Notes

Notes - notes.io

Shortened Note Link

Long File

Notes