Sometimes it is good to know who acknowledged an alarm and when. This SQL query should figure this out.

As always you can find it on my GitHub: https://github.com/benonvms/bens-support-scripts/blob/master/doctor-who-ack.sql

Please Note: This script is not supported by VMware. And running untrusted code on your vCenter Server can have a negative effect.

SELECT
    vpx_alarm.name,
    vpx_entity.name, 
    vpx_alarm_state.ack_user, 
    vpx_alarm_state.ack_time 
FROM vpx_alarm_state
    INNER JOIN vpx_alarm ON (vpx_alarm_state.alarm_id = vpx_alarm.alarm_id)
    INNER JOIN vpx_entity ON (vpx_alarm_state.entity_id = vpx_entity.id)
WHERE vpx_alarm_state.alarm_acknowledged=1;

What to expect:

root@vcsa-01 [ ~ ]# /opt/vmware/vpostgres/current/bin/psql -U postgres -d VCDB
[...]
VCDB=# SELECT
VCDB-#  vpx_alarm.name,
VCDB-#     vpx_entity.name, 
VCDB-#     vpx_alarm_state.ack_user, 
VCDB-#     vpx_alarm_state.ack_time 
VCDB-# FROM vpx_alarm_state
VCDB-#     INNER JOIN vpx_alarm ON (vpx_alarm_state.alarm_id = vpx_alarm.alarm_id)
VCDB-#     INNER JOIN vpx_entity ON (vpx_alarm_state.entity_id = vpx_entity.id)
VCDB-# WHERE vpx_alarm_state.alarm_acknowledged=1;
             name             |    name     |          ack_user           |        ack_time         
------------------------------+-------------+-----------------------------+-------------------------
 alarm.CertificateStatusAlarm | Datacenters | VSPHERE.LOCAL\Administrator | 2020-01-06 14:57:43.741
(1 row)