---
# System prepended metadata

title: Tellus monthly report
tags: [tellus, work]

---

# Tellus monthly report
###### tags: `work` `tellus`

## Step 1: Download the raw data from sftp

Enter to sftp. (從哪進去, 下載東西會直接存在此路徑)
```
cd Downloads/account_expired/account_expired_raw_data
```
```
sftp maggiewang@puppet-prod.tellus.trendops.co
```
:::info
If RSA key 有問題: cd .ssh/
把puppet 砍掉
:::

Get the whole folder.
```
get -r /mnt/tellus-data/YYYY-MM-DD
```

## Step 2: Merge the raw data
```
./merge_ddb_data.py 2019-02-01
```
Two files will be created (*merged_bby_ddb_data* and *merged_ti_ddb_data*)

## Step 3: Calculate the expired info
```
python3 expired_handler_excel.py bby  
python3 expired_handler_excel.py ti
```
An excel file will be created.


## The website of Tellus's statistics
https://monitor-prod.tellus.trendops.co/grafana/d/FD8eX9smk/tellus-monthly-report?orgId=2

## Wiki need to be updated
https://wiki.jarvis.trendmicro.com/pages/resumedraft.action?draftId=544212334&draftShareId=dbbd46e7-0555-4c24-b7fd-3d8aba3d1f7e&

