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
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