多平台数据采集监控钉钉报警配置
需监控平台：速卖通，ShopeeV2，Lazada，Allegro，Cdiscount，Mercadolibre，Kogan
监控原则 ：速卖通为例子，
10000
告警指标：告警消息模板：超过1W+数据未采集，请检查
多平台数据采集监控钉钉报警配置
需监控平台：速卖通，ShopeeV2，Lazada，Allegro，Cdiscount，Mercadolibre，Kogan
监控原则 ：速卖通为例子，
select count(1) t1 from ( select count(1) as total from p_market_product_category_collection where CustomerId = 1 and MarketId = 57 and `Status` = 1 and SiteCode = 'RU') a where a.total>10000
告警指标：告警消息模板：超过1W+数据未采集，请检查
006-<img src="/zentao/file-read-211292.png" alt="" />
006+
006-<p><img src="/zentao/file-read-211292.png" alt="" /></p>
006+ <p><img src="{211292.png}" alt="" /></p>
006-<img src="/zentao/file-read-211292.png" alt="" />
006+
006-<p><img src="/zentao/file-read-211292.png" alt="" /></p>
006+ <p><img src="{211292.png}" alt="" /></p>
| 所属迭代 | 综合平台智能刊登系统优化专项 |
|---|---|
| 所属模块 | / |
| 相关需求 | 多平台采集服务数据异常监控报警配置 |
| 指派给 | Closed 于 2023-01-18 09:21:28 |
| 任务类型 | 后端 |
| 任务标签 | 初始 |
| 开发组 | |
| 任务状态 | 已关闭 |
| 进度 | 100% |
| 优先级 | P3 |
| 关键词 | |
| 抄送给 |
| 由谁创建 | 韦思成 于 2022-10-11 10:15:01 |
|---|---|
| 由谁完成 | 朱思文 于 2022-10-14 10:01:04 |
| 由谁取消 | 暂无 |
| 由谁关闭 | 韦思成 于 2023-01-18 09:21:28 |
| 关闭原因 | 已完成 |
| 最后编辑 | 韦思成 于 2023-01-18 09:21:28 |
| 团队 | 最初预计 | 总计消耗 | 预计剩余 |
|---|
| 最初预计 | 8工时 |
|---|---|
| 总计消耗 | 16工时 |
| 预计剩余 | 0工时 |
| 预计开始 | 2022-10-11 |
| 实际开始 | 2022-10-14 |
| 截止日期 | 2022-10-14 |
select count(1) Total from (select count(1) as total from p_market_product_category_collection where CustomerId = 1 and MarketId = 97 and `Status` = 0 and TIMESTAMPDIFF(HOUR, LastModificationTime,NOW()) > 4+8) a where a.total>10000;
select count(1) Total from (select count(1) as total from p_market_product_category_collection where CustomerId = 1 and MarketId = 58 and `Status` = 0 and TIMESTAMPDIFF(HOUR, LastModificationTime,NOW()) > 4+8) a where a.total>10000;
select count(1) Total from (select count(1) as total from p_market_product_category_collection where CustomerId = 1 and MarketId = 67 and `Status` = 0 and TIMESTAMPDIFF(HOUR, LastModificationTime,NOW()) > 4+8) a where a.total>10000;
select count(1) Total from (select count(1) as total from p_market_product_category_collection where CustomerId = 1 and MarketId = 70 and `Status` = 0 and TIMESTAMPDIFF(HOUR, LastModificationTime,NOW()) > 4+8) a where a.total>10000;
select count(1) Total from (select count(1) as total from p_market_product_category_collection where CustomerId = 1 and MarketId = 81 and `Status` = 0 and TIMESTAMPDIFF(HOUR, LastModificationTime,NOW()) > 4+8) a where a.total>10000;