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.
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.
Retrieving data ...