The following can be done to determine which data source contributed a device to CAPM
- Open a shell to NetOps Portal
- Connect to mysql: mysql -unetqos -p<password> netqosportal
- Run the following command to see the list of data sources and their source id's:
- select SourceID,ConsoleName,ConsoleHost from data_sources2;
- Run the following command to see where a device comes from:
- select SourceID,LocalID,ItemID,ItemName from dst_device where ItemName='Device Item Name';
- Or you could do select SourceID,LocalID,ItemID,ItemName from dst_device where ItemName like 'Device Item Name%'; Where % is a wild card
Running these few commands will be able to tell you which datasource(s) contributed a device to Performance Manager through the sync process