DX Unified Infrastructure Management

Hi All,

How to find servers with multiple dev_src_id from SQL database ,any query is there ? For single cs_id multiple dev_src_id is created with niscache probe ,need to flush all with single query.Kindly help.

Hi Issac08

I've used the following query to identify duplicate dev_ids: 

select dev_id from CM_DEVICE

  group by dev_id

  having (count(dev_id)) > 1

You should be able to modify this query using "dev_src_id" to make it work for you. 

Hope this helps. 

Kind regards, 

Ryan