Alarm clearing in Prod OSS environment

clear alarms from backend DB

DEV and UAT comes under OMS project ,Pre Prod is for preprod01 And Prod is the Product. In Every project, the Timescale DB can be Found on TSDB vm. The Timescale Table used for the Alarm is network_element_alarms. Steps to be Followed (Mandatory) : 1. Make a select query with the Alarms condition ,verify the Count and get the Data . 2. Store the data to be Cleared in a csv File on the VM .(Must be Implemented for Record ) 3. Clear the Alarms in DB with the Clear Query Below by Updating UTC Time , and Proper Where Condition . The alarm_action, acknowledgement_state , status are to be Provided with the Default value shared. Select and count Query : Select COUNT(*) from network_element_alarms Where ; Select * from network_element_alarms Where ; *** USE PG Dump to make a csv file for the Where condition USED**** - Since the Scope of this DOCUMENT is for Updating the Skylo Table. Clear Query : update network_element_alarms set clearance_time = ,alarm_action = 'clear',status = 'Cleared',acknowledgement_state = 'Acknowledged' where ; update network_element_alarms set clearance_time =,alarm_action = 'clear',status = 'Cleared',acknowledgement_state = 'Acknowledged' where ;