geedge-jira/md/OMPUB-635.md

# 【E21现场】Network Zodiac系统界面22.07版本Asset models：TSG-9K-NPB展示时显示两次TSG-9140-NPB-FIREWALL

| ID | Creation Date | Assignee | Status |
|----|----------------|----------|--------|
| OMPUB-635 | 2022-09-21T15:36:44.000+0800 | 方顺健 | 已关闭 |


---

Network Zodiac系统界面22.07版本Asset models：TSG-9K-NPB展示时显示两次TSG-9140-NPB-FIREWALL，目前看到所有的TSG-9K-NPB Asset 都存在这种情况

以10.219.11.2为例，2022-08-12 E现场数据并没有出现重复的情况，

今天查询结果，10.219.11.2  dashboard内容展示显示两次TSG-9140-NPB-FIREWALL图表数据。

详情见附件。**fangshunjian** commented on *2022-09-21T16:57:25.501+0800*:

[~liuju]  暂时通过执行sql 删除重复内容修复，待bug修复后更新

ssh 10.224.11.3 执行以下命令

 
{code:java}
mysql -unezha -pNezha@02! -D nz -e "DELETE FROM visual_chart_element WHERE chart_id IN (SELECT id FROM visual_chart vc WHERE vc.group_id IN (SELECT vc.maxId FROM (SELECT panel_id,NAME,count(1) c,max(id) maxId,min(id) minId FROM visual_chart vc WHERE vc.panel_id !=0 AND vc.NAME='TSG-9140-NPB-FIREWALL' GROUP BY panel_id,NAME ORDER BY c DESC) vc WHERE vc.c> 1));DELETE FROM visual_chart WHERE group_id IN (SELECT maxId FROM (SELECT panel_id,NAME,count(1) c,max(id) maxId,min(id) minId FROM visual_chart vc WHERE vc.panel_id !=0 AND vc.NAME='TSG-9140-NPB-FIREWALL' GROUP BY panel_id,NAME ORDER BY c DESC) vc WHERE vc.c> 1);DELETE FROM visual_chart WHERE id IN (SELECT maxId FROM (SELECT panel_id,NAME,count(1) c,max(id) maxId,min(id) minId FROM visual_chart vc WHERE vc.panel_id !=0 AND vc.NAME='TSG-9140-NPB-FIREWALL' GROUP BY panel_id,NAME ORDER BY c DESC) vc WHERE vc.c> 1);" {code}
 

 



---

**liuju** commented on *2022-09-21T19:49:46.220+0800*:

好的，已执行完毕，现在已无重复内容。



---



# Attachments

Attachment: 微信图片_20220921103450.png

![微信图片_20220921103450.png](https://gfwleak.exec.li/admin/geedge-jira/raw/branch/master/attachment/31288/微信图片_20220921103450.png)