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