So the way we do it is to look at events in the WWALMDB. I then display it using a SQL grid. Not the most elegant way but it gets the information displayed.
This will return alarms that are inhibted or silenced. For this to work you need to ensure the Log Events are activated in the alarm logger. The graphic i attached already has the script inside it you will just need to change the custom property to define your SQL server and username/password.
This is the SQL query i use as you can see i look at the EventHistory View in WWALMDB.
Note this is a beta version at the moment i am not completely happy with the display it is very basic.
I developed this in System Platform 2014.
You can run the query in the WWALMDB database and it should return your results.
WITH dateorderedcommandevents AS
(
SELECT *, RNum=ROW_NUMBER() OVER (PARTITION BY [TagName] ORDER BY EventStamp DESC)
FROM dbo.v_EventHistory
WHERE [TagName] LIKE '%AlarmModeCmd'
AND [Description] LIKE '%Write success%'
)
SELECT EventStamp, LEFT(TagName, LEN(TagName) - 13) , Area, Value, Operator, OperatorNode
FROM dateorderedcommandevents
WHERE RNum=1 AND NOT Value='Enable'
The file is a bit big but if you pm me i can send it to you.(2.1MB)