I had a request from My Customer and they want to do some customized reporting to get current active alarms.
I would like to know which table and column name to store Created and Last updated time? I ran the query from table Alerts but (ReportedTime, LoggedTime, RetireTimeStamp) it shows difference value.
Does anyone having experience in the database SAMStore.
Thanks and Regards,
These values are coming from Alerts table from SAMStore DB
LoggedTime: Time when SOI gets the alert (Last Update column in the console)
ReportedTime: Time when the alert occurred (Created column in the console)
ClearedTime: Time when the alert was cleared
Created: column represents the time when the alert was created in MDR in other words...Time when the alert is occurred in MDR (Ex: Spectrum, Nimsoft etc)
=> This column is mapped to 'ReportedTime' column in the 'Alerts' table in SAMStore DB
Last Updated: column represents the time when alert was received at SOI or Time when SOI gets the alert
=> This column is mapped to 'LoggedTime' column in the Alerts table
=> This column will be updated for any alert update be at MDR or SOI
Note: "LoggedTime" and "ReportedTime" are in GMT
Thanks for the reply. I already checked the LoggedTime and ReportedTime but it shows difference value between SOI Console and Alerts Table. Please see below picture:
Logged Time July, 22th 2018
Last Updated July 13th 2018
Do you have any ideas for this?