Case 372

Thread #955 | 2020-09-22 08:27 UTC | James | replies: 0

Post #1 | 2020-09-22 08:27 UTC | James

Question:
How can I see the events in the RMS DB?

Solution:

Open the database and look for the "AlarmItems" table.

Add this query to see the last 1000 entries:

SELECT TOP (1000) [ID]
,[BeginTime]
,[EndTime]
,[Status]
,[Level]
,[Category]
,[Typ]
,[Confirmed]
,[Source]
,[SourceId]
,[Target]
,[TargetId]
,[Details]
,[CommandId]
,[RetryCount]
,[Inhibited]
,[RepeatTime]
,[CompanyId]
,[ConfirmCount]
,[Hash]
FROM [RMS].[dbo].[AlarmItems]
order by id desc

No matching posts in this thread.