How to determine what data source contributed a device

book

Article ID: 184129

calendar_today

Updated On:

Products

CA Infrastructure Management CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

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

Environment

Any version of CAPM

Resolution

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

  1. Open a shell to CAPC
  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 CAPM through the sync process