User Tools

Site Tools


procedures:monthly

This is an old revision of the document!


Monthly

Introduction

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.

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 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

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:

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.

procedures/monthly.1728383397.txt.gz · Last modified: by antonio.andriychuk

Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
Public Domain Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki