Find duplicate item names coming from the DA?
Article ID: 191090
Updated On:
Products
CA Infrastructure Management
CA Performance Management - Usage and Administration
DX NetOps
Issue/Introduction
How do I find duplicate item names coming from the DA?
Environment
Release : 3.7
Component : IM Reporting / Admin / Configuration
Resolution
Access the Performance Center CLI and run the below call on the command line:
Your duplicate names will be contained within /tmp/fullList.txt
mysql -uroot -p netqosportal -e "select itemid from dst_device where sourceid=3 group by 1 having count(*) > 1" > /tmp/fullList.txt
Your duplicate names will be contained within /tmp/fullList.txt
Feedback
Yes
No
Powered by
