Check total number of alarm sync from spectrrum to SOI

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

 

Is there a way to check total number of spectrum alarm sent across to SOI on monthly basis? I.e. I want to generate this month report how many alarm from spectrum send over to SOI.

Environment

Release : 4.2

Resolution

Run the below query at database:-

select * from ConnectorConfiguration

select * from alerts where ConnectorID = 15 and ReportedTime > = '2022-11-15';
put connector id from ConnectorConfiguration table