| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| procedures:monthly [2024/10/10 08:54] – CDRs specifications sysadm | procedures:monthly [2025/12/09 14:30] (current) – [Concurrent Calls for Lario Reti] gemma.coppeta |
|---|
| |
| ===== Concurrent Calls for Lario Reti ===== | ===== Concurrent Calls for Lario Reti ===== |
| As previously explained, this task is an easy one. In order to do them correctly, you must open two webpages: | On the first day of every month at 8 A.M. UTC, a cronjob scheduled in the machine named "Monitoring" runs a script that automatically retrieves the graph from Grafana showing the concurrent calls of the previous month and sends an email with the updated data in the tables. |
| * [[https://docs.google.com/spreadsheets/d/1q6RmMTfVOOOKflRkCBqde_Pi7vzcF116/edit?gid=1738010108#gid=1738010108|Angelo Procedures Docs]]; | |
| * [[https://monitor.ccaas.becloudsolutions.com:3000/d/I-DWGHD7z/lrh-concurrent-calls?orgId=1|BeCloud's Grafana Monitor]]; | |
| \\ | |
| On the Monitor you must copy each percentages to the spreadsheet (From 10>) and change the days to the number of days of the calculating month. Once this has been done, copy the value highlighted in yellow in the next tab, and these will be used in the e-mail that I'm going to explain later. \\ | |
| | |
| Once saving the value, proceed with a tool like Photoshop that will help you to "hide" the spikes where the concurrencies will exceed. What I've usually used to do is to copy each layer of a clean area and cover the spikes, Since the programme you're going to use may vary (you can even use a photo editor tool like gimp or paint), this is the explaination of what you will have to perform. \\ | |
| | |
| Then, once these data are collected, go to the Support mail and copy the email with subject "Progetto Lario Reti: Occupazione canali" and paste the data you've previously gathered and change the image. Then you can finally send the mail, and this task is completed. | |
| \\ \\ | |
| ===== Concurrent Usage ===== | ===== Concurrent Usage ===== |
| As per the Concurrent Usage, I'm more than happy to let you know that I've developed a script for it! :) \\ | As per the Concurrent Usage, I'm more than happy to let you know that I've developed a script for it! :) \\ |
| \\ | \\ |
| Then you can proceed with running the Python script, it will ask for an input regarding GTT to be extrapulated as well then you will receive in your terminal the values divided per each customer.\\ | Then you can proceed with running the Python script, it will ask for an input regarding GTT to be extrapulated as well then you will receive in your terminal the values divided per each customer.\\ |
| The next step is to store the "**Reselling Cost**" data in the [[https://docs.google.com/spreadsheets/d/1yTjXipu9NEHD21jLWteb6nDszzZonydV/edit?gid=692771078#gid=692771078|Master Traffico Ricariche]] spreadsheet, in the desired month and per each customer. After, you will have to repeat the same procedure on the monitor. \\ | The next step is to store the "**Reselling Cost**" data in the [[https://docs.google.com/spreadsheets/d/1yTjXipu9NEHD21jLWteb6nDszzZonydV/edit?gid=692771078#gid=692771078|Master Traffico Ricariche]] spreadsheet, in the desired month and per each customer.\\ |
| | After, you will have to follow this procedure on the monitor: |
| | - Go to the [[https://monitor.ccaas.becloudsolutions.com:3000/d/wMoz45sWz/traffic-situation?orgId=1|Monitor "Traffic Situation" page]] |
| | - Click on the interested tenant and select "Edit" |
| | - In the query editor you can see that there is a calculation: the first number is the recharge that Stefano will communicate to you (this is not monthly, a customer could be recharging every n month for example, you need to update this number **only if** it is communicated to you) and you also have to update it on the [[https://docs.google.com/spreadsheets/d/1yTjXipu9NEHD21jLWteb6nDszzZonydV/edit?gid=692771078#gid=692771078|shared spreadsheet]] and the second is the total traffic for the previous months. *BOTH NUMBERS ARE CUMULATIVE*, that means that at the start of the month (or 15 of the month for GTT) you need to add the total costs to the second number, and whenever Stefano communicate to you a recharge (it could be whenever during the month) you need to add the amount to the first number |
| \\ | \\ |
| In the [[https://monitor.ccaas.becloudsolutions.com:3000/d/wMoz45sWz/traffic-situation?orgId=1|monitor]], I strongly advise you to disable every [[https://monitor.ccaas.becloudsolutions.com:3000/alerting/list|alarm]] before performing any changes. Once you've secured that every alarm has been disabled you can proceed to open each window and change the first value of the query with the total gathered from the spreadsheet and save. \\ \\ | In the [[https://monitor.ccaas.becloudsolutions.com:3000/d/wMoz45sWz/traffic-situation?orgId=1|monitor]], I strongly advise you to disable every [[https://monitor.ccaas.becloudsolutions.com:3000/alerting/list|alarm]] before performing any changes. Once you've secured that every alarm has been disabled you can proceed to open each window and change the first value of the query with the total gathered from the spreadsheet and save. \\ \\ |
| |
| The last step to do is to deliver an Email from Voicetraffic to these customers: | The last step to do is to deliver an Email from Voicetraffic to these customers: |
| * Farmacie Italiane ([[mailto:sabrina.rispoli@gruppofarmacieitaliane.it|Sabrina Rispoli]], [[mailto:andrea.durante@gruppofarmacieitaliane.it|Andrea Durante]], [[mailto:umberto.gallo@gruppofarmacieitaliane.it|Umberto Gallo]]); | * Farmacie Italiane ([[mailto:andrea.durante@gruppofarmacieitaliane.it|Andrea Durante]], [[mailto:umberto.gallo@gruppofarmacieitaliane.it|Umberto Gallo]]); |
| * Ingo-LRH ([[mailto:davide.signorelli@ingogroup.it|Davide Signorelli]], [[mailto:luana.beni@ingogroup.it|Luana Beni]]); | * Ingo-LRH ([[mailto:davide.signorelli@ingogroup.it|Davide Signorelli]], [[mailto:luana.beni@ingogroup.it|Luana Beni]]); |
| * E80 ([[mailto:fatture@elettric80.it|E80]]); | * E80 ([[mailto:fatture@elettric80.it|Fatture E80]]); |
| * BeEasy ([[mailto:m.rocchi@beeasy.cloud|Matteo Rocchi]], [[mailto:s.alpeggiani@beeasy.cloud|Sabina Alpeggiani]]); | * BeEasy ([[mailto:m.rocchi@beeasy.cloud|Matteo Rocchi]]); |
| Only after you will receive the GTT file you have to send the CDR (with our prices) to this customer: | Only after you will receive the GTT file you have to send the CDR (with our prices) to this customer: |
| * RedSun ([[mailto:ict@arquati.it|ICT]]); | * RedSun ([[mailto:ict@arquati.it|ICT]]); |
