As you can see from the screenshot, we have two devices with the same dev_src_id and one device is missing dev_ip. I suspect this is the reason why some alarms are not showing in USM.
When I look at one alarm that is missing in USM, it has cs_id = -9999 so it isn't connected to a device. It should be connected to the device that has dev_ip = NULL.
How can I correct the info in CM_DEVICES?