Hello.
I have attached an Excel-document that contains the information from NAS_ALARMS, CM_DEVICE, CM_COMPUTER_SYSTEM and a query.
The dev_id from NAS_ALARMS is not present in CM_DEVICES.
I run this query to find the devices that match part of the hostname:
select * from CM_DEVICE where dev_name like 'eli%'
The result is listen under CM_DEVICES in Excel.
I then run this:
select * from CM_COMPUTER_SYSTEM where cs_id in (select cs_id from CM_DEVICE where dev_name like 'eli%')
The result is listen under CM_COMPUTER_SYSTEMS
In addition I ran this query:
SELECT CASE WHEN dev.dev_id IS NULL THEN -9999 ELSE dev.cs_id END AS cs_id,
cim.ci_id,
cs.dedicated,
cs.os_name,
cs.os_type,
nas.supptime,
nas.assigned_at,
ts.nimid,
ts.visible,
ts.nimts,
ts.suppcount,
ts.level,
ts.message,
ts.dev_id,
ts.met_id,
ts.subsys,
ts.sid,
ts.source,
ts.hostname,
ts.prid,
ts.hub,
ts.robot,
ts.origin,
ts.user_tag1,
ts.user_tag2,
ts.assigned_to,
ts.assigned_by,
ts.acknowledged_by,
ts.custom_1,
ts.custom_2,
ts.custom_3,
ts.custom_4,
ts.custom_5,
ts.i18n_token,
ts.i18n_data,
ts.time AS update_time,
ts.closed,
'' AS device_ctd_id,
'' AS probe_address
FROM NAS_ALARMS nas
JOIN NAS_TRANSACTION_SUMMARY ts
ON ts.nimid = nas.nimid
LEFT JOIN CM_CONFIGURATION_ITEM_METRIC cim
ON cim.ci_metric_id = ts.met_id
LEFT JOIN CM_DEVICE dev
ON dev.dev_id = ts.dev_id
LEFT JOIN CM_COMPUTER_SYSTEM cs
ON cs.cs_id = dev.cs_id
WHERE ( 1=1
)
AND 1=1
ORDER BY update_time DESC
I’ve listed the one result that came with dev_id = -9999 under QUERY in Excel.
We have had other alarms that we’ve had similar problems with, but they are not present at the moment.
Regard
Espen
Fra: Yu_Ishitani
Sendt: onsdag 22. februar 2017 10:21
Til: Espen Bergvoll Hanssen <espen.hanssen@lindbak.no>
Emne: Re: - Re: Identical dev_src_id
CA Communities <https://communities.ca.com/?et=watches.email.thread>
Re: Identical dev_src_id
reply from YU ISHITANI<https://communities.ca.com/people/Yu_Ishitani?et=watches.email.thread> in CA Infrastructure Management - View the full discussion<>