How to determine what data source contributed a device

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

Is there a way to determine what data source contributed a device to Performance Manager?

Environment

Any version of Performance Manager

Resolution

The following can be done to determine which data source contributed a device to CAPM

1. Open a shell to NetOps Portal
2. Connect to mysql:  mysql -unetqos -p<password> netqosportal
3. Run the following command to see the list of data sources and their source id's:
   • select SourceID,ConsoleName,ConsoleHost from data_sources2;
4. 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