2025-09-14 21:52:36 +00:00
|
|
|
|
# WMS-UTR SIP日志定期导出
|
|
|
|
|
|
|
|
|
|
|
|
| ID | Creation Date | Assignee | Status |
|
|
|
|
|
|
|----|----------------|----------|--------|
|
|
|
|
|
|
| OMPUB-1502 | 2024-10-10T17:13:13.000+0800 | 张洪庆 | 完成 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
---
|
|
|
|
|
|
|
|
|
|
|
|
需要定期导出SIP日志，包含特定字段，CSV格式。定期是指24h或若干天，可以后台执行，无需界面。**doufenghu** commented on *2024-10-11T10:54:24.012+0800*:
|
|
|
|
|
|
|
|
|
|
|
|
基于XXL-JOB，默认每天凌晨1点，导出ClickHouse voip_record 最近24小时日志记录，命名为voip-records-yyyymmdd.csv，并转换字段名称。具体结构见 https://docs.geedge.net/pages/viewpage.action?pageId=48043939。
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
---
|
|
|
|
|
|
|
|
|
|
|
|
**zhanghongqing** commented on *2024-10-12T17:47:00.726+0800*:
|
|
|
|
|
|
|
|
|
|
|
|
@王成成 已更新至现场
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
---
|
|
|
|
|
|
|
|
|
|
|
|
**zhanghongqing** commented on *2024-10-12T18:54:24.289+0800*:
|
|
|
|
|
|
|
|
|
|
|
|
* 服务器：172.18.10.175
|
|
|
|
|
|
* 周期：每天当地时间01:00 执行导出操作
|
|
|
|
|
|
* 目录： /data/hdd/tsg/olap/schedule-service/data/voip-record/
|
|
|
|
|
|
* 压缩文件：如 voip-record-20241014.csv.tar.gz , 文件大小 11GB
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
---
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2025-09-14 22:26:17 +00:00
|
|
|
|
# Attachments
|
2025-09-14 21:52:36 +00:00
|
|
|
|
|
