Every start of the month, it is necessary to perform various tasks, which may vary due to them being different.
Currently, the ones that I've (Antonio Andriychuk) been following and being involved with are:

• Concurrent Usage;
• Concurrent Calls for the Lario Reti Holding tenant;
• CDRs;

Usually, I always started with the concurrent calls since they're easy to do and also because, contractually speaking, they must be sent every start of each month.

As previously explained, this task is an easy one. In order to do them correctly, you must open two webpages:

• Angelo Procedures Docs;
• 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.

As per the Concurrent Usage, I'm more than happy to let you know that I've developed a script for it! :)
In order to run the script you need something beforehand:

• To install Python on your device (from 3.12 >): https://www.python.org/downloads/;
• To install Python-Pandas: https://pandas.pydata.org/;
• Download my script: Concurrent Usage Script

If it's your first time doing this procedure, you must first create a folder in your pc where you can store the usages files and the script. Once done that, proceed with the next step.

The procedure goes as follows:

1. Go to the sysmgmt page of the region (FK or SYD), to “Usage” and click on “Concurrent Users License Report 3 months” to download the usage;
2. Extract the file onto the folder where the .py script is located;
3. Ensure that the file is named as “license_usage_report.csv”;
4. Launch the .py script;
5. The only input from the user will be to declare whether it's Frankfurt or Sydney;
6. Then, you will be printed with “This is the max –>” and a value, you must pass this file to whom's following the Usage update, and if you want you can even hand them the usage_(month)_(year)_(region).csv file, which is already parsed with the correct month;
7. Repeat the process with the next region;

As you could've guessed, this one was an oddly easy task, and with the help of my script, you perform it in a matter of seconds.

This topic is rather important since it involves an economic value for the company. And guess what? I've developed a script for this part as well! :)

Download links for all CDRs:

• Voxbone –> Click on “DOWNLOAD CSV” and select month time range
• Irideos –> Click on the only folder, then select the interested month and click “download”
• GTT –> download the .csv of the interested month
• Telnyx –> TODO LORENZO
• Colt –> TODO LORENZO

The required tools are the same as specified in the Concurrent Usage tab, thus you need the script in order to run the code, which can be downloaded from the following link:

• CDRs code: CDRs
  

My best advice is to create a Master folder for the year (Eg. 2024) and inside create a Month folder everytime you have to handle this task. So, inside the 2024 folder you can create for example an “April” folder where you can work on.
Proceed with creating the carrier folders (Voxbone / GTT / Irideos) and by downloading them through the Carrier's portal you have to save the .csv files on the folder for each carrier:

• In the Voxbone folder: you have to save the file as “cdrs.csv”;
• In the GTT folder: you have to save the file as “cdrs.csv”;
• In the Irideos folder: you have to create two files, one called “cdrs.csv” for outbound (the one that ends with …38) and “cdrs_green.csv” for the toll-free traffic(the one that ends with …39);

Specifically for Irideos, I have a few tips:
Once you've downloaded the file and extract them, you will obtain two folders as previously noted:

• if you use unix (MacOS or Linux) go inside the folder (for example the one that ends with …38) and do this command:

  cat 90* > cdrs.csv && mv cdrs.csv ../../ 

  to save the file in the correct folder;

• if you use Windows (download Powershell 7) go inside the folder (for example the one that ends with …38) and do this command:

  cat 90* > cdrs.csv && mv cdrs.csv ../../ 

  to save the file in the correct folder;

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 Master Traffico Ricariche spreadsheet, in the desired month and per each customer. After, you will have to repeat the same procedure on the monitor.

In the monitor, I strongly advise you to disable every 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 next step will be to access (SSH) to the monitor machine and navigate to the /home/centos/monitorTraffic folder and open the calculate.js file to change the month with the current one (variable “month” at line 25) in the format YYYY-MM-DD, then proceed with running the script with

 node calculate.js 

and wait until it finishes.

After, you will have to wait until you see that in the Traffic Situation monitor the values has been changed before restarting the alerts.

The next steps will take you some time, which is to deliver the Carrier Costs and Reselling Costs to Admin for each customer… Feel free to use this E-Mail as an example:

Ciao Stefano,
Di seguito il traffico telefonico erogato per E80 nel mese di Settembre 2024:

Trunk Irideos Numero verde:         Fatturato: € 167.07 -  ( Costo a noi: € 97.73 )
Trunk Irideos Outbound :            Fatturato: € 152.97 -  ( Costo a noi: € 77.94 )

Trunk VoxBone Numero Verde:         Fatturato: € 56.4 -  ( Costo a noi: € 35.15 )
Trunk VoxBone Outbound:             Fatturato: € 622.82 -  ( Costo a noi: € 39.46 )

Totale: 
Costo a noi: € 250.28
Fatturato:   € 999.26
Come da accordi, provvederemo ad inoltrare il CRD a E80 da VoiceTraffic.

Saluti,
Antonio A.

Be aware that only on the tenant Omega3C - Microdata you have to attach the .csv file

The last step to do is to deliver an Email from Voicetraffic to these customers:

• Farmacie Italiane (Sabrina Rispoli, Andrea Durante, Umberto Gallo);
• Ingo-LRH (Davide Signorelli, Luana Beni);
• E80 (E80);
• BeEasy (Matteo Rocchi, Sabina Alpeggiani);

Only after you will receive the GTT file you have to send the CDR (with our prices) to this customer:

• RedSun (ICT);

You will find every data, as well as a template on the sent item of that same mailbox.

— Antonio Andriychuk 2024/10/08 13:28